AWS Certified Solutions Architect – Associate (SAA-C02) — Question 44

A company's production application runs online transaction processing (OLTP) transactions on an Amazon RDS MySQL DB instance. The company is launching a new reporting tool that will access the same data. The reporting tool must be highly available and not impact the performance of the production application.
How can this be achieved?

Answer options

• A. Create hourly snapshots of the production RDS DB instance.
• B. Create a Multi-AZ RDS Read Replica of the production RDS DB instance.
• C. Create multiple RDS Read Replicas of the production RDS DB instance. Place the Read Replicas in an Auto Scaling group.
• D. Create a Single-AZ RDS Read Replica of the production RDS DB instance. Create a second Single-AZ RDS Read Replica from the replica.

Correct answer: B

Explanation

The correct answer is B because a Multi-AZ RDS Read Replica provides high availability and allows read operations without affecting the performance of the primary DB instance. The other options either do not provide sufficient availability (A and D) or do not utilize the benefits of Multi-AZ configurations (C).