AWS Certified Solutions Architect Associate SAA-C03 Practice Question
A company utilizing a managed relational database service is facing performance bottlenecks during sporadic peaks in read traffic. They need to improve query performance during these periods without incurring excessive costs. What should they implement to handle the varying read loads effectively?
Introduce a caching service to handle the read traffic.
Add an additional standby replica to distribute the load.
Scale up the primary instance to handle the increased load.
Create read replicas to distribute the incoming read requests.
Creating read replicas of the primary database instance allows for the distribution of the read query load, helping to maintain query performance during traffic peaks without a costly scaling of the primary instance. This technique improves read throughput at a lower cost compared to scaling up the primary instance or using a caching service for queries that cannot be cached. Implementing read replicas is more appropriate for balancing read traffic than using a caching service, which is mainly beneficial for frequently accessed immutable data, or leveraging an additional standby replica, which is more focused on high availability rather than read distribution.
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 are read replicas in the context of a managed relational database?
Open an interactive chat with Bash
How does creating read replicas help in cost management for database performance?
Open an interactive chat with Bash
What are the primary differences between read replicas and caching services?