AWS Certified Solutions Architect Associate SAA-C03 Practice Question

Amazon ElastiCache effectively addresses the challenge of reducing database load by caching query results. It supports caching strategies, both for Redis and Memcached, that can store frequently accessed data in-memory, thereby improving application performance by providing low-latency access to the data and reducing the load on the database tier. This aligns with the criteria specified for enhancing performance and scalability for read-heavy operations, making it the best option given the scenario described.

Amazon RDS Read Replicas are not the ideal choice because, while they can reduce the load by serving read requests, they are not a caching layer and do not offer the same low latency as an in-memory cache. Using RDS Multi-AZ would provide high availability but would not address the performance issue related to read-heavy queries as effectively as a caching layer. Amazon S3 is primarily used for object storage and is not suitable for caching database query results.