A Company's Production Application Runs Online Transaction Processing (OLTP) Transactions

Multiple Choice

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?

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.