AWS Certified Developer – Associate (DVA-C02) — Question 25

A company is migrating an on-premises database to Amazon RDS for MySQL. The company has read-heavy workloads. The company wants to refactor the code to achieve optimum read performance for queries.
Which solution will meet this requirement with LEAST current and future effort?

Answer options

• A. Use a multi-AZ Amazon RDS deployment. Increase the number of connections that the code makes to the database or increase the connection pool size if a connection pool is in use.
• B. Use a multi-AZ Amazon RDS deployment. Modify the code so that queries access the secondary RDS instance.
• C. Deploy Amazon RDS with one or more read replicas. Modify the application code so that queries use the URL for the read replicas.
• D. Use open source replication software to create a copy of the MySQL database on an Amazon EC2 instance. Modify the application code so that queries use the IP address of the EC2 instance.

Correct answer: C

Explanation

The correct answer is C because deploying read replicas is specifically designed to enhance read performance without significant changes to the existing architecture. Options A and B do not significantly improve read performance and may add complexity, while option D introduces unnecessary overhead and management of an EC2 instance.