SAA-C03 Question 308
Single answerYour company runs a global e-commerce platform that uses an Amazon RDS MySQL database to store customer and order data. Traffic to the platform has increased significantly in certain regions, causing high read latency on your database. You want to improve read performance for users in these regions without affecting the performance of the primary database. Which solution would best address this issue?
- A
Create Amazon RDS read replicas in the regions experiencing high traffic.
- B
Enable Multi-AZ deployment for your Amazon RDS database.
- C
Migrate your database to Amazon DynamoDB for better scalability.
- D
Increase the instance size of your Amazon RDS primary database.
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS read replicas are specifically designed to improve read performance by allowing read traffic to be offloaded from the primary database to replica databases. By creating read replicas in regions with high traffic, you can improve latency and ensure a better user experience without impacting the primary database's performance.
- A. Correct.
Creating Amazon RDS read replicas in the regions experiencing high traffic is the correct solution. Read replicas allow you to offload read traffic from the primary database, reducing latency and improving performance for read-intensive workloads.
- B. Incorrect.
Enabling Multi-AZ deployment improves database availability and failover capabilities but does not address read performance. Multi-AZ is designed for high availability, not load balancing read traffic.
- C. Incorrect.
Migrating to Amazon DynamoDB could improve scalability for certain use cases, but it would require significant changes to your application and is not a straightforward solution for resolving high read latency in this scenario.
- D. Incorrect.
Increasing the instance size of the primary database may temporarily improve performance but does not address the regional read traffic issue or distribute the load effectively.