SAP-C02 Question 272
Select 2A global e-commerce company wants to ensure high availability and disaster recovery for their application, which is hosted on Amazon RDS using a MySQL database. The company needs to minimize downtime in case of a Region-wide failure while ensuring cost efficiency. Which of the following approaches should you recommend?
- A
Configure Amazon RDS with Multi-AZ deployment within a single Region and enable automated backups.
- B
Set up a cross-Region read replica for the Amazon RDS database and promote it to a standalone database in case of a primary Region failure.
- C
Use Amazon Aurora Global Database to replicate the database across Regions with low-latency replication.
- D
Use Amazon RDS Multi-AZ deployment across multiple Regions to ensure automatic failover between Regions.
- E
Configure AWS Backup to take cross-Region backups of the database and restore them in a new Region upon failure.
Show answer and explanation
Correct answers: B, C
Explanation
To design a highly available and disaster-resilient architecture for Amazon RDS in a multi-Region setup, using a cross-Region read replica (manual promotion) or Amazon Aurora Global Database (automatic failover) are the most effective options. These approaches ensure minimal downtime during a Region-wide failure. Multi-AZ deployments and AWS Backup are effective for other use cases, but they do not meet the requirement for cross-Region protection and rapid recovery.
- A. Incorrect.
This option only provides high availability within a single Region. It does not protect against Region-wide failures, which makes it insufficient for the given scenario.
- B. Correct.
A cross-Region read replica can serve as a disaster recovery solution. In case of a Region-wide failure, you can promote the replica to a standalone database, minimizing downtime. However, this requires manual intervention to promote the replica.
- C. Correct.
Amazon Aurora Global Database is designed for multi-Region architectures with low-latency replication, offering near-instant failover capabilities in case of a Regional failure. This makes it an excellent solution for minimizing downtime.
- D. Incorrect.
Amazon RDS Multi-AZ deployment does not natively support automatic failover across multiple Regions. It only provides high availability within a single Region.
- E. Incorrect.
While AWS Backup can provide cross-Region backups, restoring the database from a backup can result in significant downtime, which does not meet the requirement to minimize downtime.