SAA-C03 Question 509
Single answerYour company has a production workload running on an Amazon RDS MySQL database. The application experiences high read traffic, and there are performance issues because the primary database is under heavy load. You have been asked to design a solution that reduces the read load on the primary database while ensuring minimal impact on the write operations. What is the most cost-effective solution?
- A
Create an Amazon RDS Read Replica and configure the application to send read queries to the replica.
- B
Enable Multi-AZ for the RDS instance to offload read operations to the standby database.
- C
Migrate the database to Amazon Aurora and use Aurora Replica for read operations.
- D
Vertically scale the RDS instance by upgrading to a larger instance type to handle the increased load.
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS Read Replicas are specifically designed to offload read traffic from the primary database, making them a cost-effective and scalable solution for handling high read workloads. Multi-AZ is for failover and high availability, and scaling vertically or migrating to Aurora would either incur higher costs or add complexity unnecessarily.
- A. Correct.
This is the correct solution. Creating an Amazon RDS Read Replica allows the application to offload read traffic to the replica, reducing the load on the primary database. This is cost-effective and does not impact write operations.
- B. Incorrect.
Multi-AZ is designed for high availability and disaster recovery, not for read scaling. The standby database in a Multi-AZ setup cannot be used to serve read traffic.
- C. Incorrect.
Migrating to Amazon Aurora could solve the problem, but it introduces additional complexity and costs. This is not the most cost-effective solution compared to using RDS Read Replicas.
- D. Incorrect.
Vertically scaling the RDS instance may temporarily solve the issue, but it is not cost-effective for scaling read operations, especially if the read traffic continues to grow.