SAA-C03 Question 510
Single answerAn e-commerce company is using Amazon RDS for MySQL to manage its transactional database. The application workload is read-heavy, and you notice performance degradation during peak traffic hours. The company wants to improve read performance without making major changes to the existing database setup. Which solution should you implement?
- A
Create a read replica of the RDS instance and configure the application to offload read requests to the replica.
- B
Enable Multi-AZ deployment for the RDS instance to distribute the read traffic across multiple Availability Zones.
- C
Migrate the database to Amazon Aurora and use Aurora Serverless to handle read and write scalability automatically.
- D
Increase the RDS instance size to a larger instance class to handle the increased workload.
Show answer and explanation
Correct answer: A
Explanation
Read replicas in Amazon RDS are specifically designed to improve the performance of read-heavy workloads by offloading read traffic to a replica instance. This allows the primary database instance to focus on write operations while maintaining a consistent replication of data. In this scenario, the company wants to improve read performance without making major changes, making read replicas the most suitable solution.
- A. Correct.
This is the correct option. Read replicas in Amazon RDS allow you to offload read traffic from the primary database instance, improving read performance during high traffic periods.
- B. Incorrect.
This is incorrect. Multi-AZ deployment is designed for high availability and failover support, not for improving read performance. It does not distribute read traffic.
- C. Incorrect.
This is incorrect. Migrating to Aurora and using Aurora Serverless could improve scalability, but it involves significant changes to the existing database setup, which the scenario explicitly wants to avoid.
- D. Incorrect.
This is incorrect. Increasing the instance size may temporarily improve performance, but it does not scale well for a read-heavy workload. Read replicas are a more cost-effective and scalable solution for this use case.