AWS Certified Database – Specialty — Question 179

A bank plans to use an Amazon RDS for MySQL DB instance. The database should support read-intensive traffic with very few repeated queries.
Which solution meets these requirements?

Answer options

• A. Create an Amazon ElastiCache cluster. Use a write-through strategy to populate the cache.
• B. Create an Amazon ElastiCache cluster. Use a lazy loading strategy to populate the cache.
• C. Change the DB instance to Multi-AZ with a standby instance in another AWS Region.
• D. Create a read replica of the DB instance. Use the read replica to distribute the read traffic.

Correct answer: D

Explanation

The correct answer is D because creating a read replica allows the application to distribute read traffic effectively, optimizing performance for read-intensive workloads. Options A and B involve caching strategies, which may reduce database load but do not specifically address the need for distributing read traffic. Option C enhances availability but does not directly improve read performance.