SAP-C02 Question 275
Select 3A financial services company has a mission-critical application running on an Amazon RDS PostgreSQL database in a single Region. To ensure both high availability and disaster recovery with minimal downtime in the event of a Regional failure, which of the following architectural changes should you implement?
- A
Enable Multi-AZ for the Amazon RDS instance in the current Region.
- B
Create a cross-Region read replica and promote it to a standalone database in the event of a Regional failure.
- C
Set up an Amazon Aurora Global Database for cross-Region replication and failover.
- D
Configure AWS Backup to take cross-Region backups of the RDS instance and restore the database in the event of a failure.
- E
Deploy a second Amazon RDS instance in another Region and use AWS DataSync for replication.
Show answer and explanation
Correct answers: A, B, C
Explanation
To ensure high availability and disaster recovery across Regions, you need a combination of strategies. Enabling Multi-AZ provides high availability within the current Region. For Regional failures, setting up a cross-Region read replica or using an Aurora Global Database enables disaster recovery with minimal downtime. AWS Backup and AWS DataSync are not sufficient for the stringent requirements of mission-critical applications with minimal downtime.
- A. Correct.
Enabling Multi-AZ ensures high availability within the current Region by automatically failing over to a standby instance in case of an AZ failure. However, it does not provide protection against Regional failures, making it necessary but insufficient on its own.
- B. Correct.
Creating a cross-Region read replica offers disaster recovery capabilities. While it requires manual promotion in the event of a Regional failure, it supports recovery in another Region, improving availability.
- C. Correct.
Amazon Aurora Global Database is designed for cross-Region high availability and disaster recovery, offering low-latency replication and automated failover capabilities for supported workloads.
- D. Incorrect.
AWS Backup provides cross-Region backup capabilities, but restoring a database from a backup can result in significant downtime and data loss, which does not align with the requirement for minimal downtime.
- E. Incorrect.
AWS DataSync is used for data transfer and synchronization but is not a suitable solution for replicating Amazon RDS databases in a multi-Region setup.