SOA-C02 Question 61
Single answerA company runs a highly trafficked e-commerce website. Customers frequently view product details, and the same product information is repeatedly retrieved from an Amazon RDS database, causing high read latency during peak times. As a SysOps Administrator, how can you reduce the database load and improve application performance with minimal operational overhead?
- A
Implement Amazon ElastiCache in front of the RDS database to cache frequent read queries.
- B
Enable automatic scaling for the RDS database to handle increased traffic.
- C
Use Amazon S3 to store product information and serve it directly to the application.
- D
Configure an Amazon CloudFront distribution in front of the RDS database.
Show answer and explanation
Correct answer: A
Explanation
To improve application performance and reduce database load in this scenario, caching is the most effective solution. Amazon ElastiCache provides a managed caching layer that stores frequent read queries, enabling faster responses without repeatedly querying the RDS database. This minimizes operational overhead and enhances the scalability of the application.
- A. Correct.
Correct. Amazon ElastiCache is specifically designed to cache frequent queries, reducing database load and improving performance. It integrates seamlessly with RDS in caching use cases.
- B. Incorrect.
Incorrect. While automatic scaling can help RDS handle additional traffic, it does not reduce database load or directly improve performance for repeated read queries. Additionally, this approach might increase costs.
- C. Incorrect.
Incorrect. Amazon S3 is used for object storage and is not suitable for storing dynamic product information retrieved from a relational database.
- D. Incorrect.
Incorrect. Amazon CloudFront is a content delivery network designed to cache and deliver static content, but it cannot cache queries from an RDS database.