SAP-C02 Question 639
Single answerYour organization is running a critical e-commerce application using Amazon RDS for MySQL. Recently, you have been experiencing performance issues during peak traffic hours, and database read latency has significantly increased. You want to improve read performance without changing the application code or migrating to a different database engine. Which solution should you implement?
- A
Enable Multi-AZ deployment for the RDS instance.
- B
Scale up the RDS instance to a larger instance size.
- C
Create a read replica for the RDS instance and update the application to use it for read queries.
- D
Implement Amazon ElastiCache in front of the RDS instance to cache frequent queries.
Show answer and explanation
Correct answer: C
Explanation
The most effective solution for reducing read latency in Amazon RDS without modifying application code is to create a read replica. Read replicas provide a way to offload read traffic from the primary instance, improving performance during peak traffic. Other options, such as enabling Multi-AZ or scaling up the instance, do not directly address read performance or may involve higher costs, while implementing caching with Amazon ElastiCache would require changes to the application.
- A. Incorrect.
Multi-AZ deployment improves availability and failover capabilities but does not improve read performance. It is primarily a high availability feature.
- B. Incorrect.
Scaling up the RDS instance can address some performance issues, but it is a costly solution and may not be sufficient if the problem is due to high read traffic.
- C. Correct.
Creating a read replica allows you to offload read traffic from the primary database, significantly improving read performance. This is an effective solution for reducing read latency without altering the application code.
- D. Incorrect.
Amazon ElastiCache can improve performance but would require application changes to implement caching logic. The question explicitly states that no application code changes should be made.