AWS Certified Solutions Architect Professional SAP-C02 Practice Question
A financial-services company runs a critical trading application on an Amazon RDS for PostgreSQL Multi-AZ DB instance in the us-east-1 Region. The company must create a disaster-recovery site in eu-west-1 that meets the following requirements:
Recovery Point Objective (RPO): < 10 seconds
Recovery Time Objective (RTO): < 10 minutes
High reliability with minimal ongoing operational overhead for the database team
Which data-replication strategy should a solutions architect recommend to meet these requirements?
Migrate the database to Amazon Aurora PostgreSQL-Compatible Edition and create an Aurora Global Database with a secondary cluster in eu-west-1.
Configure an Amazon RDS for PostgreSQL cross-Region read replica and promote it during a disaster event.
Use AWS Database Migration Service (DMS) with Change Data Capture (CDC) to keep a live copy of the database in eu-west-1.
Schedule automated cross-Region snapshots of the RDS instance and restore the latest snapshot in a disaster scenario.
Migrating the workload to Amazon Aurora PostgreSQL-Compatible Edition and configuring an Aurora Global Database best meets the stated objectives. Aurora Global Database uses physical, storage-based replication that achieves typical cross-Region latency of sub-second, delivering an effective RPO of about 1 second. In the event of a Regional outage, a secondary Region can be promoted to read/write status in less than 1 minute, satisfying the 10-minute RTO. The feature is fully managed, so ongoing maintenance overhead is low.
RDS cross-Region read replica: replication is WAL-based over the network and AWS notes that lag can reach several minutes, so the RPO can exceed 10 seconds under normal load.
AWS DMS with CDC: introduces additional components to operate and typically shows higher replication latency than Aurora's storage-level replication, risking the RPO and increasing operational overhead.
Cross-Region automated or manual snapshots: snapshot frequency defines the RPO (usually hours) and a restore operation is required, making the RTO far longer than 10 minutes.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is an Aurora Global Database?
Open an interactive chat with Bash
How does Aurora Global Database replication achieve sub-second latency?
Open an interactive chat with Bash
What are RPO and RTO, and how do they apply in disaster recovery?
Open an interactive chat with Bash
AWS Certified Solutions Architect Professional SAP-C02
Continuous Improvement for Existing Solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
IT & Cybersecurity Package Join Premium for Full Access