SAP-C02 Question 552
Single answerA company runs a web application that uses an Amazon RDS database for transactional data. The database is experiencing performance issues during peak traffic hours due to a high volume of read requests. The company wants a cost-effective solution that minimizes changes to the application while alleviating the load on the database. As a Solutions Architect, which solution should you recommend?
- A
Enable Multi-AZ deployment for the RDS instance to improve read performance.
- B
Migrate the database to Amazon Aurora for better scalability.
- C
Use Amazon ElastiCache to cache frequently accessed data.
- D
Create read replicas of the RDS instance and update the application to route read traffic to the replicas.
Show answer and explanation
Correct answer: D
Explanation
Creating read replicas is the most appropriate solution to alleviate the load on the database caused by high read traffic. It offloads read operations from the primary database and requires only minor application updates to direct read traffic to the replicas. This approach meets the requirement of being cost-effective and minimizing changes to the application.
- A. Incorrect.
Enabling Multi-AZ deployment improves availability and failover capabilities but does not address read performance issues, as it is designed for disaster recovery and not for scaling read operations.
- B. Incorrect.
Migrating to Amazon Aurora could improve scalability but involves significant changes and potential downtime, which may not be cost-effective or necessary for the given scenario.
- C. Incorrect.
Amazon ElastiCache can improve performance by caching frequently accessed data; however, this solution requires application changes to query the cache, which might not align with the requirement to minimize changes.
- D. Correct.
Creating read replicas offloads read traffic from the primary database and is a cost-effective solution that requires minimal application changes (updating the application to route read queries to replicas).