ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to 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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
mbar94
Highly Voted 2 years, 7 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, 2 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 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, 6 months ago
Why not C - With Multi-AZ DB cluster we should be able to achieve this??
upvoted 1 times
Satprave
2 years, 5 months ago
It's a Standby Replica, not a Read replica, So it should be A
upvoted 1 times
...
Germaneli
1 year, 6 months ago
Multi-AZ serves for HA, not for performance improvement. The latter is asked here --> A.
upvoted 1 times
...
Pranava_GCP
1 year, 7 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, 7 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
SonamDhingra
2 years, 7 months ago
Selected Answer: A
A is correct
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago