Q3 — AWS SAA-C03 Ch.6

Question 3 of 65 | ← Chapter 6

Q368. A solutions architect is designing a company's disaster recovery (DR) architecture. The company has a MySQL database that runs on an Amazon EC2 instance in a private subnet with scheduled backup. The DR design needs to include multiple AWS Regions.Which solution will meet these requirements with the LEAST operational overhead?

• A. Migrate the MySQL database to multiple EC2 instances. Configure a standby EC2 instance in the DR Region. Turn on replication
• B. Migrate the MySQL database to Amazon RDS. Use a Multi-AZ deployment. Turn on read replication for the primary DB instance in the different Availability Zones
• C. Migrate the MySQL database to an Amazon Aurora global database. Host the primary DB cluster in the primary Region. Host the secondary DB cluster in the DR Region ✓
• D. Store the scheduled backup of the MySQL database in an Amazon S3 bucket that is configured for S3 Cross-Region Replication (CRR). Use the data backup to restore the database in the DR Region

Correct Answer: C. Migrate the MySQL database to an Amazon Aurora global database. Host the primary DB cluster in the primary Region. Host the secondary DB cluster in the DR Region

Explanation

The solution that will meet the requirements with the least operational overhead is option C: Migrate the MySQL database to an Amazon Aurora global database. Host the primary cluster in the primary Region and host the secondary DB cluster in the DR Region.Amazon Aurora Global Database provides a fully managed, multi-region, and multi-master database replication feature. It allows you to create a single Aurora database that spans multiple AWS Regions, providing low-latency global reads and disaster recovery capabilities. By migrating the MySQL database to an Amazon Aurora global database, you can eliminate the need for manual replication setup and management. Aurora takes care of replicating the data across regions and ensures high availability and durability. In the event of a disaster in the primary Region, you can promote the secondary DB cluster in the DR Region to become the new primary and redirect traffic to it. This solution minimizes operational overhead because leverages the built-in capabilities of Amazon Aurora and does not require managing multiple EC2 instances or configuring replication manually.