SAA-C03 Question 511
Select 3Your company runs a web application backed by an Amazon RDS MySQL database in a single Availability Zone. The application experiences a high volume of read requests, causing performance degradation. To improve read performance and ensure high availability, which solution should you implement?
- A
Create one or more read replicas in the same AWS Region.
- B
Enable Multi-AZ deployment for the RDS instance.
- C
Create one or more read replicas in a different AWS Region.
- D
Migrate the database to Amazon DynamoDB.
- E
Use Amazon ElastiCache to cache frequently read data.
Show answer and explanation
Correct answers: A, C, E
Explanation
To address a high volume of read requests and improve performance, you can implement read replicas in the same or different regions to offload read traffic from the primary database. Additionally, using Amazon ElastiCache can further improve read performance by caching frequently accessed data. Multi-AZ deployment, while improving availability, does not help with read performance, and migrating to DynamoDB is not a simple or relevant solution in this case.
- A. Correct.
Creating read replicas in the same AWS Region can offload read traffic from the primary database, improving performance for read-heavy workloads.
- B. Incorrect.
Enabling Multi-AZ deployment improves database availability for failover scenarios, but it does not directly improve read performance as the standby instance is not used for read traffic.
- C. Correct.
Creating read replicas in a different AWS Region can improve read performance for global users and offload the primary database, especially if the application serves users across multiple regions.
- D. Incorrect.
Migrating to Amazon DynamoDB is not a straightforward solution for this scenario, as it involves significant architectural changes and is not specifically designed to handle the described read-heavy workload for an RDS MySQL database.
- E. Correct.
Using Amazon ElastiCache to cache frequently read data can significantly improve read performance by reducing load on the database and serving cached data to the application.