AWS Certified Solutions Architect Professional SAP-C02 Practice Question
Your organization operates a low-latency trading platform backed by an Amazon Aurora MySQL-Compatible cluster in the us-east-1 Region. Compliance requires that, if the entire Region is lost, the database must be recovered with a Recovery Point Objective (RPO) of no more than 5 seconds and a Recovery Time Objective (RTO) under 5 minutes. The solution should impose minimal performance impact on the primary cluster and avoid custom scripting or manual procedures.
Which approach will meet these objectives?
Use AWS Backup to take on-demand snapshots of the Aurora cluster every minute and copy them to a secondary Region; restore the most recent snapshot during a Regional outage.
Configure MySQL binary log replication from the primary Aurora cluster to an Amazon RDS for MySQL instance in a different Region and redirect application traffic with a custom Route 53 health check after promotion.
Create a cross-Region Aurora read replica using binlog replication and trigger an AWS Lambda function from a CloudWatch alarm to promote the replica once ReplicaLag falls below 5 seconds.
Enable Amazon Aurora Global Database and add a secondary Aurora MySQL cluster in another AWS Region; use the managed global database failover feature to promote the secondary cluster during a disaster.
Enabling Amazon Aurora Global Database adds a secondary Aurora MySQL cluster in another AWS Region that uses storage-level physical replication with typical latency under one second, yielding an RPO well below 5 seconds. A managed cross-Region failover can promote the secondary cluster to primary in under a minute, satisfying the 5-minute RTO, and the entire process is fully managed with no custom automation required.
Cross-Region Aurora read replicas rely on binlog (logical) replication, which can experience tens of seconds to minutes of lag under load, so the 5-second RPO cannot be guaranteed and Lambda-driven promotion still introduces custom logic. External binlog replication to an RDS instance suffers from the same lag characteristics and adds operational overhead. Snapshot or backup-copy solutions cannot achieve a 5-second RPO, and restoring a snapshot normally takes many minutes or longer, so they also miss the RTO requirement.
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 Amazon Aurora Global Database?
Open an interactive chat with Bash
How does cross-Region replication in Aurora Global Database ensure low RPO and RTO?
Open an interactive chat with Bash
How does Aurora Global Database differ from binlog replication?
Open an interactive chat with Bash
AWS Certified Solutions Architect Professional SAP-C02
Design for New Solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
IT & Cybersecurity Package Join Premium for Full Access