SAP-C02 Question 485
Single answerYou are designing a multi-region disaster recovery solution for an e-commerce application hosted on Amazon RDS for PostgreSQL. The application must ensure minimal data loss and fast recovery in case of a regional failure. Which data replication method should you use to meet these requirements?
- A
Cross-region snapshot replication
- B
Multi-AZ deployment
- C
Read replica in another region
- D
Amazon RDS Global Database
Show answer and explanation
Correct answer: D
Explanation
Amazon RDS Global Database is the best choice for a multi-region disaster recovery solution because it provides near real-time replication with low-latency data access and minimal recovery time. Other options, like cross-region snapshot replication or read replicas, may result in data loss or slower recovery times, while Multi-AZ deployment is limited to a single region and does not meet the multi-region requirement.
- A. Incorrect.
Cross-region snapshot replication copies snapshots to another region on a schedule, but it does not provide real-time replication. This method could result in significant data loss during a regional failure.
- B. Incorrect.
Multi-AZ deployment provides high availability within a single region by synchronously replicating data to a standby instance. However, it does not replicate data across regions, so it does not meet the multi-region disaster recovery requirement.
- C. Incorrect.
Read replicas in another region provide asynchronous replication, which could lead to data loss in case of a failure. While they can be used for disaster recovery, they do not offer the same level of consistency and recovery speed as a Global Database.
- D. Correct.
Amazon RDS Global Database is specifically designed for low-latency, multi-region replication. It uses dedicated infrastructure to replicate data with minimal lag, enabling fast recovery and ensuring minimal data loss in the event of a regional failure.