AWS Certified Solutions Architect Associate SAA-C03 Practice Question
A company's web application uses a relational database hosted in AWS. The application is experiencing performance issues due to a high volume of data retrieval queries, but data modifications remain at normal levels. What is the best way to improve the database's ability to handle the increased demand for data reads?
Enable a Multi-AZ deployment to offload queries to a standby instance.
Create read replicas and configure the application to use them for data retrieval operations.
Implement a database proxy to improve connection management.
Upgrade the database instance to a larger instance class.
To enhance the database's ability to manage increased data read requests, creating read replicas is the most effective solution. Read replicas allow you to scale out read-heavy workloads by distributing read traffic across multiple replica databases, reducing the load on the primary database. Upgrading the database instance to a larger class provides more resources but it may not suffice for significant increases in read traffic and requires continuous monitoring. Implementing a Multi-AZ deployment improves availability and failover capabilities but does not enhance read performance, as the standby instance cannot serve read traffic. Using a database proxy helps manage connections but does not specifically address scaling 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 AWS relational databases?
Open an interactive chat with Bash
How does Multi-AZ differ from read replicas?
Open an interactive chat with Bash
What is a database proxy, and when should it be used?