Q57 — AWS DVA-C02 Ch.2

Question 57 of 100 | ← Chapter 2

A company is migrating its on-premises database to Amazon RDS for MySQL. The company has a heavy read workload and wants to refactor its code to achieve optimal query read performance. Which solution meets this requirement with minimal current and future effort?

• A. Use a Multi-AZ Amazon RDS deployment. Increase the number of connections the application establishes to the database or increase the connection pool size if using a connection pool.
• B. Use a Multi-AZ Amazon RDS deployment. Modify the code so queries access the standby RDS instance.
• C. Deploy Amazon RDS with one or more read replicas. Modify the application code so queries use the read replica endpoint URL. ✓
• D. Use open-source replication software to create a MySQL database replica on Amazon EC2 instances. Modify the application code so queries use the EC2 instance IP address.

Correct Answer: C. Deploy Amazon RDS with one or more read replicas. Modify the application code so queries use the read replica endpoint URL.

Explanation

Option A (Multi-AZ + increased connections/pool size) improves connection management but does not meaningfully enhance read scalability. Option B incorrectly assumes the standby instance in a Multi-AZ deployment is available for read traffic—it is not; it’s only used for failover. Option D requires managing replication, patching, scaling, and high availability manually on EC2, significantly increasing operational overhead. Option C leverages Amazon RDS read replicas, which are fully managed, scalable, and designed specifically to offload read traffic from the primary instance. Applications route read queries to replica endpoints with minimal code changes, delivering immediate and sustained read performance gains with low maintenance effort. Therefore, Option C is optimal.