A company stores a large dataset in a single-AZ Amazon RDS for MySQL DB instance. The company wants business reporting queries to run without impacting write operations on the production DB. Which solution meets this requirement?
Choose an answer
Tap an option to check your answer.
Correct answer: Deploy RDS read replicas to process the business reporting queries..
Why this is the answer
Deploying RDS read replicas is the correct solution because read replicas are designed to offload read-heavy workloads, such as business reporting queries, from the primary DB instance. This ensures that write operations on the primary instance are not impacted, as the reporting queries execute against the replica. Scaling out with an Elastic Load Balancer is not applicable for a single relational database instance; ELBs distribute traffic across multiple independent instances, not a single DB. Scaling up the DB instance would increase its capacity but would not separate read and write workloads, meaning reporting queries would still contend with write operations. Deploying in multiple Availability Zones enhances availability and disaster recovery but does not inherently separate read and write workloads for performance isolation.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed