SAA-C03 Question 155
Single answerYour company runs a high-traffic e-commerce website using an Amazon RDS instance for its MySQL database. Recently, customers have reported delays in loading product pages due to increased database query response times. Upon investigation, you find that the database is experiencing a high volume of read queries, while the write operations are minimal. What is the best solution to improve the database performance in this situation?
- A
Enable Multi-AZ deployment for the RDS instance to improve read performance.
- B
Scale up the RDS instance to a larger instance type with more CPU and memory.
- C
Use Amazon RDS read replicas to offload read queries from the primary database.
- D
Migrate the database to Amazon DynamoDB to handle the increased read traffic.
Show answer and explanation
Correct answer: C
Explanation
When an Amazon RDS instance experiences high read traffic, read replicas are a cost-effective and scalable solution to offload read operations from the primary database. They allow read-heavy applications to distribute the query load across multiple replicas, improving performance without affecting write operations or requiring significant architectural changes. Other options like Multi-AZ deployment or scaling up the instance do not address the underlying issue of high read traffic as effectively.
- A. Incorrect.
Multi-AZ deployment is designed for high availability and failover, not for improving read performance. It does not address the issue of high read query load.
- B. Incorrect.
Scaling up the RDS instance can temporarily improve performance, but it is not a cost-effective or scalable solution for offloading high read traffic.
- C. Correct.
Using Amazon RDS read replicas is the best solution to offload read queries from the primary database, which can significantly improve performance for read-heavy workloads.
- D. Incorrect.
Migrating to DynamoDB is not necessary in this case, as the issue can be resolved by using read replicas. DynamoDB may require significant changes to the application and schema, which is not ideal for this scenario.