AWS Certified Developer – Associate — Question 4

A company is migrating its on-premises database to Amazon RDS for MySQL. The company has read-heavy workloads, and wants to make sure it re-factors its code to achieve optimum read performance for its queries.
How can this objective be met?

Answer options

• A. Add database retries to effectively use RDS with vertical scaling.
• B. Use RDS with multi-AZ deployment.
• C. Add a connection string to use an RDS read replica for read queries.
• D. Add a connection string to use a read replica on an EC2 instance.

Correct answer: C

Explanation

The correct answer is C because using an RDS read replica allows the application to offload read requests from the primary database, thereby improving performance. Option A is incorrect as database retries do not directly enhance read performance. Option B, while beneficial for availability, does not specifically optimize for read workloads. Option D is wrong because it suggests using an EC2 instance instead of a dedicated RDS read replica, which would not provide the same performance benefits.