SAA-C03 Question 37
Single answerA company runs a web application that stores critical business data in an Amazon RDS MySQL instance. The application has been experiencing performance issues, and the team has identified that the database is under heavy read traffic. The team wants to improve application performance and ensure high availability while minimizing changes to the existing application. What is the BEST solution to meet these requirements?
- A
Enable Multi-AZ deployment for the Amazon RDS MySQL instance.
- B
Create an Amazon RDS Read Replica and configure the application to offload read traffic to the replica.
- C
Increase the RDS instance size to handle more read and write traffic.
- D
Migrate the database to Amazon DynamoDB for better scalability.
Show answer and explanation
Correct answer: B
Explanation
The best solution to improve performance for a read-heavy workload while maintaining high availability is to create an Amazon RDS Read Replica. This allows the application to distribute read traffic between the primary instance and the replica, improving performance without requiring significant changes to the application. While other options provide benefits in specific scenarios, they do not address the specific need for scaling read traffic effectively with minimal changes.
- A. Incorrect.
Multi-AZ deployment provides high availability and fault tolerance by creating a standby instance in another Availability Zone. However, it does not improve performance or offload read traffic, as the standby instance cannot serve reads.
- B. Correct.
Creating an Amazon RDS Read Replica allows you to offload read traffic from the primary database, improving performance for read-heavy workloads without significant changes to the application.
- C. Incorrect.
Increasing the RDS instance size may temporarily alleviate performance issues, but it does not address the root cause of heavy read traffic. It is also not cost-effective for scaling read-heavy workloads.
- D. Incorrect.
Migrating to Amazon DynamoDB could improve scalability but would require significant changes to the application code and architecture. It is not the best solution for minimizing changes to the existing application.