Cross-Region Relational Database with Aurora Global Database
A company is designing a new application on AWS that requires a relational database with read replicas across multiple AWS Regions. The database must have automated failover and a recovery point objective (RPO) of less than 5 seconds. Which database solution should the company choose?
Quick Answer
The answer is Amazon Aurora Global Database because it is the only AWS relational database service that provides cross-region read replicas with automated failover and a recovery point objective (RPO) of less than 1 second, easily meeting the requirement of under 5 seconds. This is achieved through a dedicated, fast replication channel that writes data to secondary regions with minimal lag, enabling failover in under one minute without data loss. On the AWS Certified Solutions Architect Professional SAP-C02 exam, this scenario tests your understanding of disaster recovery patterns and the specific capabilities of Aurora Global Database versus services like RDS Multi-AZ or DynamoDB Global Tables, which either lack cross-region read replicas or are non-relational. A common trap is choosing RDS with cross-region read replicas, but those lack automated failover and have higher RPO due to asynchronous replication. Memory tip: think “Global Aurora, sub-second RPO, automated failover in a minute.”
⚠ Common exam trap
Many exam-takers confuse Multi-AZ failover (which is Region-bound) with cross-Region failover, or they assume that RDS cross-Region read replicas can achieve the same low RPO as Aurora Global Database, but RDS cross-Region replication is asynchronous and cannot guarantee sub-5-second RPO.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Amazon Aurora Global Database
Amazon Aurora Global Database is the correct choice because it is designed for cross-Region replication with a typical RPO of less than 1 second and automated failover from the primary Region to a secondary Region in under 1 minute. This meets the requirement for a relational database with read replicas across multiple Regions and an RPO of less than 5 seconds, as Aurora Global Database uses a dedicated, fast replication channel that minimizes lag.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Amazon Aurora Global Database
Why this is correct
Aurora Global Database provides RPO of 1 second and automated failover across Regions.
- ✗
Amazon RDS for MySQL with Multi-AZ and cross-Region read replicas
Why it's wrong here
Cross-Region read replicas for RDS MySQL do not support automatic failover.
- ✗
Amazon RDS for PostgreSQL with cross-Region read replicas and Multi-AZ
Why it's wrong here
Cross-Region read replicas for RDS PostgreSQL do not support automatic failover.
- ✗
Amazon DynamoDB Global Tables
Why it's wrong here
DynamoDB is NoSQL, not relational.
Go deeper
Related to this question
About these practice questions
This SAP-C02 question is part of Courseiva's 1,660-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on SAP-C02
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company is designing a disaster recovery solution for a web application hosted on AWS. The primary site is in us-east-1 and the DR site is in us-west-2. The application uses an Amazon RDS for MySQL database. They need to recover the database with a Recovery Point Objective (RPO) of 5 seconds and a Recovery Time Objective (RTO) of 1 hour. Which solution meets these requirements?
medium- A.Use RDS Multi-AZ in us-east-1 and failover to DR site.
- B.Use AWS DMS with ongoing replication to an RDS instance in us-west-2.
- ✓ C.Use RDS Cross-Region Read Replica and promote it.
- D.Use Amazon Aurora Global Database.
Why C: RDS Cross-Region Read Replicas for MySQL provide asynchronous replication with an RPO of typically seconds, and promoting the replica to a standalone instance can be done quickly (minutes), meeting the RTO of 1 hour. Option A is incorrect because Multi-AZ is single region. Option B is incorrect because while DMS can achieve low RPO, it is typically used for migrations and ongoing replication setups may have higher operational complexity and RTO. Option D is incorrect because Amazon Aurora Global Database is not available for RDS MySQL; it is for Aurora databases.
Variation 2. A financial services company is designing a multi-tier application that must achieve a Recovery Time Objective (RTO) of 1 hour and a Recovery Point Objective (RPO) of 15 minutes for a database tier. The application uses Amazon RDS for MySQL with Multi-AZ deployment. Which disaster recovery strategy meets these requirements at the LOWEST cost?
hard- A.Deploy the RDS instance in Multi-AZ configuration and take frequent snapshots to another Region.
- B.Use AWS Database Migration Service (DMS) for continuous replication to an RDS instance in another Region.
- C.Use Amazon Aurora Global Database, which provides global replication with typical RPO of 1 second.
- ✓ D.Create a cross-Region read replica of the RDS MySQL instance in another Region. In a disaster, promote the read replica to a standalone instance.
Why D: A cross-Region read replica for Amazon RDS MySQL provides asynchronous replication with an RPO typically under 15 minutes, and promoting it during a disaster can achieve an RTO of 1 hour. This approach incurs only the cost of the replica instance and cross-Region data transfer, making it the lowest-cost option that meets the stated RTO and RPO requirements.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SAP-C02 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SAP-C02 exam.