Answer-first summary for fast verification
Answer: By deploying RDS read replicas.
The correct answer is A: 'By deploying RDS read replicas.' RDS read replicas allow you to offload read traffic from the primary database instance, ensuring that intensive read operations, such as business reporting queries, do not impact the write performance of the primary instance. Scaling horizontally with Elastic Load Balancers or vertically to a larger instance can improve performance but will not isolate read queries from write operations. Deploying across multiple Availability Zones (D) offers high availability and failover capabilities but does not specifically address the requirement to handle reporting queries separately from write operations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can a company ensure that business reporting queries do not impact write operations on its production Amazon RDS MySQL instance?
A
By deploying RDS read replicas.
B
By scaling the DB instance horizontally with an Elastic Load Balancer.
C
By scaling the DB instance vertically to a larger type.
D
By deploying the DB instance across multiple Availability Zones.