SAP-C02 Question 441
Select 3A company is hosting a high-traffic, read-heavy web application on Amazon RDS for MySQL. Users are experiencing increased latency during peak usage hours. As a Solutions Architect, you are tasked with determining a strategy to improve the application's performance. Which solution(s) should you implement?
- A
Enable Amazon RDS Read Replicas and configure the application to offload read requests to the replicas.
- B
Increase the size of the Amazon RDS instance to a larger instance class with more CPU and memory.
- C
Implement Amazon ElastiCache as a caching layer to store frequently accessed data.
- D
Enable Amazon RDS Multi-AZ deployment to improve read throughput.
- E
Switch to Amazon Aurora MySQL to leverage its built-in read scaling capabilities.
Show answer and explanation
Correct answers: A, C, E
Explanation
To improve performance for a read-heavy workload on Amazon RDS, the most effective strategies are to offload read operations using Read Replicas, implement a caching layer with Amazon ElastiCache, or migrate to Amazon Aurora MySQL, which offers enhanced read scaling capabilities. While increasing the instance size may help, it is a less efficient and more expensive approach. Multi-AZ deployment does not address read performance, as it is focused on high availability and failover.
- A. Correct.
Correct: Enabling Amazon RDS Read Replicas allows you to offload read operations to one or more replicas, reducing the load on the primary instance and improving read performance.
- B. Incorrect.
Partially correct, but not optimal: Increasing the instance size can improve performance by providing more compute and memory resources, but it does not specifically address the high read load during peak traffic. It is also more costly.
- C. Correct.
Correct: Implementing Amazon ElastiCache as an in-memory caching layer can significantly improve performance by reducing the load on the database for frequently accessed data.
- D. Incorrect.
Incorrect: Multi-AZ deployment is designed for high availability and failover purposes, not for improving read performance.
- E. Correct.
Correct: Amazon Aurora MySQL is optimized for performance and includes features like a distributed, fault-tolerant storage system and built-in read scaling via Aurora Replicas, which makes it a good choice for read-heavy workloads.