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?
Upgrade the database instance to a larger instance class.
Implement a database proxy to improve connection management.
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.
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 and how do they work?
Open an interactive chat with Bash
Why would I choose read replicas over upgrading the database instance?
Open an interactive chat with Bash
What is a Multi-AZ deployment and how is it different from read replicas?