DBS-C01 Workload-Specific Database Design Practice Question
Which TWO design patterns help meet ACID compliance requirements in a distributed database environment while maintaining high availability?
⚠ Common exam trap
The DBS-C01 exam often tests the distinction between ACID-compliant distributed transactions and patterns that provide only eventual consistency or compensation-based semantics, leading candidates to select the saga pattern or eventually consistent models as valid ACID solutions.
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
✓
Implement Amazon Aurora Global Database for cross-Region ACID transactions.
Amazon Aurora Global Database is designed to support cross-Region ACID transactions by using a primary cluster in one AWS Region and up to five secondary read-only clusters in other Regions. It replicates data asynchronously from the primary to the secondary Regions, but each secondary cluster can be promoted to a primary in under a minute, ensuring high availability while maintaining ACID compliance for transactions that span multiple Regions.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use an eventually consistent read model to improve performance.
Why it's wrong here
Eventual consistency does not provide ACID.
- ✓
Implement Amazon Aurora Global Database for cross-Region ACID transactions.
Why this is correct
Aurora Global Database provides ACID within each region.
- ✗
Adopt a saga pattern to manage distributed transactions.
Why it's wrong here
Saga pattern is for eventual consistency.
- ✓
Use Amazon DynamoDB Transactions for multi-item ACID operations.
Why this is correct
DynamoDB Transactions provide ACID.
- ✗
Implement DynamoDB Streams to capture changes for audit.
Why it's wrong here
Streams are for change data capture, not ACID.
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.