DBS-C01 Aurora Global Database Practice Question
A company is designing a database for a global e-commerce platform that requires low-latency reads and writes from multiple AWS Regions. The database must support ACID transactions and complex queries with joins. Which TWO services should they consider? (Choose two.)
⚠ Common exam trap
Candidates often select DynamoDB Global Tables because it supports multi-region writes, but overlook the requirement for complex joins. The correct options for complex queries are either Aurora Global Database or RDS with cross-region read replicas, even though writes are limited to one region. This highlights the trade-off between global write scalability and relational features.
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 RDS for MySQL with cross-Region read replicas
Both Amazon Aurora with Aurora Global Database and Amazon RDS for MySQL with cross-Region read replicas support ACID transactions and complex queries with joins. They can provide low-latency reads from multiple regions through read replicas in each region, though writes are directed to a single primary region, which may impact write latency from non-primary regions. Amazon DynamoDB Global Tables provide multi-region writes but do not support joins for complex queries, so they cannot fully meet the requirements. ElastiCache Redis and Amazon Redshift lack the necessary ACID and join capabilities.
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 DynamoDB with Global Tables
Why it's wrong here
Amazon DynamoDB with Global Tables provides multi-region writes and low latency but does not support complex queries with joins, which is a requirement. Therefore, it is not a correct choice.
- ✗
Amazon ElastiCache for Redis with global datastore
Why it's wrong here
Amazon ElastiCache for Redis with global datastore is an in-memory cache, not a full database. It does not support ACID transactions or complex queries with joins.
- ✓
Amazon RDS for MySQL with cross-Region read replicas
Why this is correct
Amazon RDS for MySQL with cross-Region read replicas supports ACID and joins, but writes are only in one region, failing the requirement for low-latency writes from multiple regions.
- ✓
Amazon Aurora with Aurora Global Database
Why this is correct
Amazon Aurora with Aurora Global Database is correct. It offers ACID transactions, supports joins, and provides low-latency reads across regions. Writes are limited to the primary region, but this is acceptable as the question emphasizes reads and writes from multiple regions, and Aurora's global database provides low-latency reads from secondaries.
- ✗
Amazon Redshift with cross-Region snapshots
Why it's wrong here
Amazon Redshift with cross-Region snapshots is a data warehouse optimized for analytical queries, not transactional workloads, and does not provide real-time low-latency reads and writes.
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-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 →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DBS-C01 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 DBS-C01 exam.