How can this be achieved?

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

View Answer

Answer: B

Explanation:

Reference: https://aws.amazon.com/blogs/database/best-storage-practices-for-running-production-workloadson-hosted-databases-with-amazon-rds-or-amazon-ec2/

Amazon RDS Read Replicas Now Support Multi-AZ Deployments

Amazon RDS Read Replicas enable you to create one or more read-only copies of your database instance within the same AWS Region or in a different AWS Region. Updates made to the source database are then asynchronously copied to your Read Replicas. In addition to providing scalability for read-heavy workloads, Read Replicas can be promoted to become a standalone database instance when needed.

Amazon RDS Multi-AZ deployments provide enhanced availability for database instances within a single AWS Region. With Multi-AZ, your data is synchronously replicated to a standby in a different Availability Zone (AZ). In the event of an infrastructure failure, Amazon RDS performs an automatic failover to the standby, minimizing disruption to your applications.

You can now use Read Replicas with Multi-AZ as part of a disaster recovery (DR) strategy for your production databases. A well-designed and tested DR plan is critical for maintaining business continuity after a disaster. A Read Replica in a different region than the source database can be used as a standby database and promoted to become the new production database in case of a regional disruption.

https://aws.amazon.com/about-aws/whats-new/2018/01/amazon-rds-read-replicas-now-support-multi-az-deployments/#:~:text=Starting%20today%2C%20Amazon%20RDS%20Read,your%20database%20engine%20upgrade%20process.