AWS Certified Solutions Architect Associate SAA-C03 Practice Question
A customer-facing online reporting dashboard requires low latency access to a significantly read-heavy database for real-time data retrieval. You must optimize this database's performance without increasing infrastructure complexity. Which solution should you implement to best meet these requirements?
Introduce Amazon ElastiCache to provide in-memory caching.
Scale the relational database using Amazon RDS Read Replicas.
Use DynamoDB Accelerator (DAX) to cache frequently accessed items.
Switch to using Amazon Aurora with automatic scaling enabled.
Amazon ElastiCache effectively addresses read-heavy workloads by enabling in-memory caching, which reduces the number of direct read operations to the database and hence significantly decreases response times for data retrieval. While RDS Read Replicas improve scalability by distributing the read load, they may not be optimal for real-time data requirements due to potential replication lag. Amazon Aurora's automatic scaling is powerful for overall performance and scalability but does not specifically target the low latency access needed for a real-time reporting dashboard. DAX is specific to Amazon DynamoDB which wasn't specified as the service in use, and thus, doesn't hold as the best answer to the use case presented.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Amazon ElastiCache and how does it improve performance?
Open an interactive chat with Bash
What are the differences between read replicas and caching solutions like ElastiCache?
Open an interactive chat with Bash
What is replication lag and why is it a concern for real-time applications?