SAA-C03 Question 96
Single answerA company is running a web application with a MySQL database hosted on an Amazon RDS instance. The application is experiencing intermittent high latency during peak traffic hours. The solution architect has been tasked with improving database performance without significant application changes. Which solution would address this issue effectively?
- A
Enable Amazon RDS Read Replicas and configure the application to use them for read operations.
- B
Scale the RDS instance vertically by upgrading to a larger instance type.
- C
Enable Multi-AZ deployment for the RDS instance to improve performance.
- D
Migrate the database to Amazon Redshift for better performance.
Show answer and explanation
Correct answer: A
Explanation
Using Amazon RDS Read Replicas is the most effective solution for handling read-heavy traffic during peak times without significant application changes. Read replicas provide additional read capacity, which can reduce latency and improve performance without needing to scale the primary database instance vertically or migrate to a different database technology.
- A. Correct.
This is the correct answer. Amazon RDS Read Replicas allow you to offload read-heavy traffic from the primary database, reducing latency during peak traffic hours. The application can use the read replicas for read queries without significant changes.
- B. Incorrect.
Although scaling the RDS instance vertically can improve performance, it may not effectively handle traffic spikes caused by read-heavy operations. Additionally, it could be costlier and does not optimize read scalability.
- C. Incorrect.
Multi-AZ deployment improves database availability and durability by maintaining a standby in another Availability Zone. However, it does not address performance issues as it is not designed for load balancing or read optimization.
- D. Incorrect.
Amazon Redshift is a data warehousing service optimized for analytical queries, not transactional databases like MySQL. Migrating to Redshift would involve significant application changes and is not suitable for this scenario.