SOA-C02 Question 62
Single answerA company hosts a high-traffic web application backed by an Amazon RDS database. The database is experiencing performance issues due to frequent identical read queries. As a SysOps Administrator, you need to implement a caching solution to improve performance and reduce database load. Which approach should you take?
- A
Use Amazon ElastiCache to store frequently accessed data in memory.
- B
Enable Amazon RDS caching by increasing the database instance class size.
- C
Configure Amazon CloudFront to cache dynamic content from the database.
- D
Set up an Amazon DynamoDB table to cache the database queries.
Show answer and explanation
Correct answer: A
Explanation
To address performance issues caused by frequent identical read queries, implementing a caching solution is the best approach. Amazon ElastiCache is specifically designed for this use case, offering in-memory caching to reduce database load and improve application performance. Other options either do not involve caching or are not suitable for database query caching.
- A. Correct.
Amazon ElastiCache is a fully managed caching service that can significantly improve application performance by storing frequently accessed data in memory, reducing the load on the database.
- B. Incorrect.
Increasing the database instance class size may improve performance temporarily but does not implement caching. This is not a scalable or cost-efficient long-term solution for reducing database load.
- C. Incorrect.
Amazon CloudFront is used for caching static content and optimizing delivery of web assets, not for caching database queries or dynamic content.
- D. Incorrect.
Amazon DynamoDB is a NoSQL database, not a caching service. While it can store data, it is not designed for in-memory caching and would not reduce database load effectively in this scenario.