AWS Certified Solutions Architect Associate SAA-C03 Practice Question
A company has an online transaction processing (OLTP) workload on an Amazon RDS instance that experiences high read traffic during business hours. The database performance degrades due to the high number of read requests, impacting the user experience. Which of the following solutions should you implement to reduce the read load on the primary database instance and provide high-performing database responses?
You selected this option
Convert the database deployment to a Multi-AZ deployment for improved performance.
You selected this option
Implement Amazon ElastiCache to cache common queries and reduce the read load.
You selected this option
Create multiple read replicas of the primary database instance and distribute the read traffic among them.
You selected this option
Increase the size of the existing database instance to a larger instance type.
Creating read replicas allows the primary database to offload read requests to the replicas, thereby improving the performance of the primary instance for write operations and providing faster read responses from the replicas. The deployment of read replicas in different Availability Zones (AZs) also increases high availability. The synchronization of read replicas is asynchronous, which helps in scaling-out read operations without impacting the write latency of the primary database. Increasing the instance size could improve performance but would not address the scalability or high availability. Multi-AZ deployment is for high availability and failover support, not for scaling read operations. Using a caching layer such as Amazon ElastiCache can indeed reduce database load, but it does not replace the need for read replicas when the goal is to scale read operations.
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 Amazon RDS?
Open an interactive chat with Bash
How does asynchronous replication affect read replicas?
Open an interactive chat with Bash
What is the difference between Multi-AZ and read replicas?