SAA-C03 Question 247
Single answerA company is hosting a web application that uses an Amazon RDS database instance for data storage. The company notices performance bottlenecks during peak usage times due to high read traffic. Which solution can help improve the database's performance and scalability while minimizing changes to the application?
- A
Enable Multi-AZ deployments for the RDS instance.
- B
Migrate the database to Amazon DynamoDB.
- C
Add read replicas to the RDS instance.
- D
Enable RDS Performance Insights to optimize queries.
Show answer and explanation
Correct answer: C
Explanation
The best solution to handle high read traffic is to add read replicas to the Amazon RDS instance. Read replicas allow you to offload read queries from the primary database instance, improving performance and scalability. This solution is straightforward to implement and requires minimal changes to the existing application.
- A. Incorrect.
Multi-AZ deployments are designed for high availability and failover support, not for improving read performance. This does not address the issue of high read traffic.
- B. Incorrect.
Migrating to Amazon DynamoDB may improve performance, but it requires significant changes to the application and is not the easiest solution for the given scenario.
- C. Correct.
Adding read replicas to the RDS instance allows the application to distribute read traffic across multiple replicas, improving performance and scalability without significant changes to the application.
- D. Incorrect.
Enabling RDS Performance Insights helps in diagnosing query performance issues but does not directly address read traffic bottlenecks.