AWS Certified Database – Specialty — Question 164

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct option, C, allows for an enhancement of performance by distributing read traffic to a read replica while still maintaining the primary instance for writes. Options A and B involve additional configurations that introduce more complexity and operational overhead, while option D suggests a more significant architectural change that may not be necessary for the current needs.