SAP-C02 Question 488
Single answerA company runs a critical application in the us-east-1 region using Amazon RDS for PostgreSQL. They require a near real-time replica of the database in another region (us-west-2) to ensure disaster recovery and meet compliance requirements. Which data replication method should the company use to achieve this?
- A
Multi-AZ Deployment
- B
Read Replica
- C
Database Snapshot Export
- D
AWS Database Migration Service (DMS)
Show answer and explanation
Correct answer: B
Explanation
To ensure near real-time replication of an Amazon RDS database between two regions, Read Replica is the correct choice. It supports asynchronous replication, enabling database synchronization between the primary region (us-east-1) and the secondary region (us-west-2). Other options either do not support cross-region replication or are not designed for continuous replication of data.
- A. Incorrect.
Multi-AZ Deployment provides high availability within a single region but does not replicate data across regions. It is not suitable for cross-region disaster recovery.
- B. Correct.
Read Replica allows asynchronous replication of the database to another region, making it an appropriate solution for creating a near real-time replica in us-west-2.
- C. Incorrect.
Database Snapshot Export creates a point-in-time backup of the database, but it does not provide ongoing replication or synchronization between regions.
- D. Incorrect.
AWS Database Migration Service (DMS) is used for migrating databases or replicating data between heterogeneous or homogeneous database systems, but it is not a native feature for ongoing replication of Amazon RDS across regions.