Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 195 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 195
Topic #: 1

[All AWS Certified Database - Specialty Questions]

An application reads and writes data to an Amazon RDS for MySQL DB instance. A new reporting dashboard needs read-only access to the database. When the application and reports are both under heavy load, the database experiences performance degradation. A database specialist needs to improve the database performance.
What should the database specialist do to meet these requirements?

A. Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.
B. Create a read replica of the DB instance. Configure the application and reports to connect to the cluster endpoint.
C. Enable Multi-AZ deployment. Configure the reports to connect to the standby replica.
D. Enable Multi-AZ deployment. Configure the application and reports to connect to the cluster endpoint.

Show Suggested Answer

Suggested Answer: A 🗳️

by mbar94 at Sept. 3, 2022, 9:28 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

mbar94

Highly Voted 2 years, 10 months ago

Selected Answer: A

Take off only reports from the primary to read replica. It's A. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

upvoted 8 times

...

OCHT

Most Recent 2 years, 4 months ago

Selected Answer: B

Create a read replica of the DB instance. Configure the application and reports to connect to the cluster endpoint. By creating a read replica of the DB instance and directing the reporting dashboard to connect to the replica, the application can continue to read and write data to the primary DB instance without impacting the performance of the reporting dashboard. The read replica can handle the additional read-only load from the reporting dashboard, improving overall performance. By configuring the application and reports to connect to the cluster endpoint, the load can be distributed across the primary DB instance and the read replica. This approach provides a scalable and efficient solution for improving database performance while maintaining read-only access to the reporting dashboard.

upvoted 1 times

Mintwater

2 years, 2 months ago

The reason not to choose B is — both application and reports to connect to the cluster endpoint — nothing can distribute the workload to the new replica. Thus, to choose A to distribute the workload

upvoted 1 times

...

RBSK

2 years, 8 months ago

Why not C - With Multi-AZ DB cluster we should be able to achieve this??

upvoted 1 times

Satprave

2 years, 8 months ago

It's a Standby Replica, not a Read replica, So it should be A

upvoted 1 times

...

Germaneli

1 year, 9 months ago

Multi-AZ serves for HA, not for performance improvement. The latter is asked here --> A.

upvoted 1 times

...

Pranava_GCP

1 year, 9 months ago

standby replica configured for high availability in a Multi-AZ deployment. Replication with the standby replica is synchronous. Unlike a read replica, a standby replica can't serve read traffic.

upvoted 1 times

...

cloudsunriser

2 years, 9 months ago

Selected Answer: A

A is correct

upvoted 1 times

...

SonamDhingra

2 years, 10 months ago

Selected Answer: A

A is correct

upvoted 2 times

...