- A
Amazon DynamoDB with Global Tables
Why wrong: 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.
- B
Amazon ElastiCache for Redis with global datastore
Why wrong: 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.
- C
Amazon RDS for MySQL with cross-Region read replicas
Why wrong: 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.
- D
Amazon Aurora with Aurora Global Database
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.
- E
Amazon Redshift with cross-Region snapshots
Why wrong: 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.
Choosing a Global Database for ACID Transactions and Complex Queries
This DBS-C01 practice question tests your understanding of workload-specific database design. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. A key principle to apply: aurora Global Database. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
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.)
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 with Aurora Global Database
Amazon Aurora with Aurora Global Database supports ACID transactions and complex queries with joins, and provides global-scale reads with low latency via read replicas in multiple regions. While it does not support multi-region writes (only one primary region for writes), it satisfies the key requirements of complex queries and ACID transactions. Amazon DynamoDB Global Tables, while excellent for multi-region writes and low latency, does not support complex joins, making it unsuitable for this requirement. The other options either lack ACID support, complex query capabilities, or global write functionality.
Key principle: Aurora Global Database
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 it's wrong here
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.
Related concept
Aurora Global Database
- ✗
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.
Common exam traps
Common exam trap: answer the scenario, not the keyword
Candidates often select DynamoDB Global Tables because it supports multi-region writes, but overlook the requirement for complex joins, which DynamoDB does not support. The correct choice for complex queries is Aurora Global Database, even though writes are limited to one region.
Detailed technical explanation
How to think about this question
Aurora Global Database leverages a dedicated replication infrastructure that bypasses the database engine's buffer cache, achieving sub-second replication lag even across continents. Under the hood, it uses a storage-based replication mechanism where only redo log records are shipped to secondary Regions, minimizing network overhead and ensuring consistency without impacting primary write performance. In a real-world scenario, a global e-commerce platform can use Aurora Global Database to handle write-intensive workloads in a primary Region while serving read traffic from secondary Regions, all while maintaining full ACID compliance and support for complex joins via the MySQL or PostgreSQL-compatible engine.
KKey Concepts to Remember
- Aurora Global Database
- Complex queries with joins
- Multi-region writes
TExam Day Tips
- Watch for words such as best, first, most likely and least administrative effort.
- Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Aurora Global Database
Real-world example
How this comes up in practice
An e-commerce site experiences heavy traffic on Black Friday and near-zero traffic during off-peak weeks. Rather than provisioning permanent large VMs, the team uses auto-scaling groups that add capacity automatically under load and reduce it overnight. Questions like this test whether you understand elasticity, availability zones, and cloud compute scaling patterns.
What to study next
Got this wrong? Here's your next step.
Review aurora Global Database, then practise related DBS-C01 questions on the same topic to reinforce the concept.
- →
Workload-Specific Database Design — study guide chapter
Learn the concepts, then practise the questions
- →
Workload-Specific Database Design practice questions
Targeted practice on this topic area only
- →
All DBS-C01 questions
1,730 questions across all exam domains
- →
AWS Certified Database Specialty DBS-C01 study guide
Full concept coverage aligned to exam objectives
- →
DBS-C01 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Related DBS-C01 practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Workload-Specific Database Design practice questions
Practise DBS-C01 questions linked to Workload-Specific Database Design.
Deployment and Migration practice questions
Practise DBS-C01 questions linked to Deployment and Migration.
Management and Operations practice questions
Practise DBS-C01 questions linked to Management and Operations.
Monitoring and Troubleshooting practice questions
Practise DBS-C01 questions linked to Monitoring and Troubleshooting.
Database Security practice questions
Practise DBS-C01 questions linked to Database Security.
DBS-C01 fundamentals practice questions
Practise DBS-C01 questions linked to DBS-C01 fundamentals.
DBS-C01 scenario practice questions
Practise DBS-C01 questions linked to DBS-C01 scenario.
DBS-C01 troubleshooting practice questions
Practise DBS-C01 questions linked to DBS-C01 troubleshooting.
Practice this exam
Start a free DBS-C01 practice session
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Questions learners often ask
What does this DBS-C01 question test?
Workload-Specific Database Design — This question tests Workload-Specific Database Design — Aurora Global Database.
What is the correct answer to this question?
The correct answer is: Amazon Aurora with Aurora Global Database — Amazon Aurora with Aurora Global Database supports ACID transactions and complex queries with joins, and provides global-scale reads with low latency via read replicas in multiple regions. While it does not support multi-region writes (only one primary region for writes), it satisfies the key requirements of complex queries and ACID transactions. Amazon DynamoDB Global Tables, while excellent for multi-region writes and low latency, does not support complex joins, making it unsuitable for this requirement. The other options either lack ACID support, complex query capabilities, or global write functionality.
What should I do if I get this DBS-C01 question wrong?
Review aurora Global Database, then practise related DBS-C01 questions on the same topic to reinforce the concept.
What is the key concept behind this question?
Aurora Global Database
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Keep practising
More DBS-C01 practice questions
- A company is deploying a new application on Amazon RDS for PostgreSQL. The security policy requires that all data be enc…
- Match each AWS service to its primary purpose.
- A financial services company runs a production Amazon Aurora MySQL database cluster (1 writer, 2 readers) in us-east-1.…
- A company is designing a database for a global e-commerce platform that requires low-latency reads and writes from multi…
- A security auditor reviews the output of a DynamoDB table description command as shown in the exhibit. Which statement a…
- A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database contains sensitive data tha…
Last reviewed: Jul 4, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.