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.
Scale up the primary instance to handle the increased load.
Create read replicas to distribute the incoming read requests.
Add an additional standby replica to distribute the load.
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 managed relational database services?
Open an interactive chat with Bash
How do read replicas differ from standby replicas?
Open an interactive chat with Bash
When is scaling up the primary database instance a less preferred option for addressing read traffic issues?