Exam AWS Certified Database - Specialty topic 1 question 173 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 173
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company runs a MySQL database for its ecommerce application on a single Amazon RDS DB instance. Application purchases are automatically saved to the database, which causes intensive writes. Company employees frequently generate purchase reports. The company needs to improve database performance and reduce downtime due to patching for upgrades.
Which approach will meet these requirements with the LEAST amount of operational overhead?

A. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and enable Memcached in the MySQL option group.
B. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and set up replication to a MySQL DB instance running on Amazon EC2.
C. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and add a read replica.
D. Add a read replica and promote it to an Amazon Aurora MySQL DB cluster master. Then enable Amazon Aurora Serverless.

Show Suggested Answer

Suggested Answer: C 🗳️

by GMartinelli at Nov. 24, 2021, 12:33 p.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

novice_expert

3 years, 1 month ago

Selected Answer: C

Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and add a read replica. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

upvoted 2 times

...

ak9830

3 years, 2 months ago

Answer is C. Per - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.MySQL.html Using a read replica to reduce downtime when upgrading a MySQL database. If your MySQL DB instance is currently in use with a production application, you can use the following procedure to upgrade the database version for your DB instance. This procedure can reduce the amount of downtime for your application. By using a read replica, you can perform most of the maintenance steps ahead of time and minimize the necessary changes during the actual outage. With this technique, you can test and prepare the new DB instance without making any changes to your existing DB instance.

upvoted 2 times

...

RotterDam

3 years, 3 months ago

Selected Answer: C

C is the correct answer. The question mentions LEAST operational overhead and the employees frequently create purchase reports (Read heavy). Moving queries to RR will open up the Primary to take on additional loads wrt writes.

upvoted 1 times

...