SAP-C02 Question 181
Single answerA retail company wants to ensure business continuity for its e-commerce platform hosted on AWS. The platform uses Amazon RDS for PostgreSQL in a single Region. The company requires minimal downtime and automatic failover in case of a Regional outage. What solution should you implement to meet these requirements?
- A
Set up an Amazon RDS Read Replica in a different Region and promote it to a primary database during a Regional outage.
- B
Enable Amazon RDS Multi-AZ deployment within the same Region to handle Regional outages.
- C
Configure Amazon RDS Global Database to replicate data across multiple Regions and enable automatic failover.
- D
Use AWS Backup to regularly back up the database and restore it in another Region during a Regional outage.
Show answer and explanation
Correct answer: C
Explanation
The requirement is to ensure business continuity with minimal downtime and automatic failover in the event of a Regional outage. Amazon RDS Global Database is specifically designed to replicate data across multiple Regions with low latency and supports automatic failover, making it the ideal solution for this scenario. Other options either lack automatic failover or do not address Regional outages effectively.
- A. Incorrect.
This option provides a manual solution where the Read Replica can be promoted to a primary database, but it does not support automatic failover, which is a requirement in the scenario.
- B. Incorrect.
Multi-AZ deployment ensures high availability within a single Region but does not provide protection against Regional outages.
- C. Correct.
Amazon RDS Global Database replicates data across multiple Regions with low latency, and it supports automatic failover in case of a Regional outage, making it the best solution for this scenario.
- D. Incorrect.
AWS Backup allows for recovery of the database, but it involves a manual process and does not meet the requirement for automatic failover.