SAP-C02 Question 638
Single answerA retail company uses an Amazon RDS MySQL database for their e-commerce application. During high traffic events, such as sales promotions, they experience performance issues due to increased read traffic. The application is highly read-intensive and needs to scale seamlessly during these events. Which solution provides the most cost-effective and scalable way to handle the increased read traffic?
- A
Enable Amazon RDS Multi-AZ deployment to improve read performance.
- B
Scale the RDS instance vertically to a larger instance size.
- C
Create Amazon RDS Read Replicas and configure the application to read from them.
- D
Migrate the database to Amazon Aurora with Aurora Replicas.
Show answer and explanation
Correct answer: C
Explanation
Amazon RDS Read Replicas are designed to offload read traffic by replicating data asynchronously from the primary database. This allows the application to distribute read requests across multiple replicas, providing a scalable and cost-effective way to handle increased read traffic during peak events. Other options either do not address the problem directly or involve more complexity and cost than necessary for the given scenario.
- A. Incorrect.
Amazon RDS Multi-AZ deployment improves availability and failover support, not read performance. It is not designed to handle increased read traffic.
- B. Incorrect.
Scaling the RDS instance vertically might temporarily address the performance issue, but it is not cost-effective or scalable for handling fluctuating read traffic during high-demand events.
- C. Correct.
Amazon RDS Read Replicas are specifically designed to offload read traffic from the primary database. This is a cost-effective and scalable solution for handling increased read traffic.
- D. Incorrect.
Migrating to Amazon Aurora with Aurora Replicas could address the issue, but it involves additional migration effort and costs, which may not be justified if Read Replicas can handle the requirement.