SAA-C03 Question 491
Single answerA company runs a web application that frequently queries a database for product details. The application is experiencing high latency due to repeated queries for the same data. The company wants to implement a caching strategy to improve performance and reduce database load. Which solution is the MOST appropriate?
- A
Use Amazon ElastiCache with a Redis cluster to store frequently accessed product details.
- B
Enable Amazon RDS Multi-AZ for the database to improve query performance.
- C
Use Amazon S3 to cache the product details in an object storage bucket.
- D
Implement an Amazon CloudFront distribution to cache the database queries.
Show answer and explanation
Correct answer: A
Explanation
Amazon ElastiCache with Redis is the most appropriate solution in this scenario because it provides an in-memory caching layer that can store frequently accessed data, significantly reducing database load and query latency. This is a common strategy for improving application performance when dealing with repeated database queries.
- A. Correct.
Amazon ElastiCache with Redis is a high-performance in-memory caching service that is ideal for reducing database load and improving query performance by storing frequently accessed data.
- B. Incorrect.
Amazon RDS Multi-AZ improves database availability and disaster recovery, but it does not directly address the issue of reducing latency or caching query results.
- C. Incorrect.
Amazon S3 is an object storage service, and while it is highly durable, it is not designed for caching dynamic query results or providing low-latency responses.
- D. Incorrect.
Amazon CloudFront is a content delivery network designed for caching and serving static content, such as images or videos, but it is not suitable for caching database query results.