Quick Answer
The answer is Amazon Aurora and Amazon RDS for MySQL, as both provide full ACID (Atomicity, Consistency, Isolation, Durability) transaction support for relational workloads. Aurora achieves this through a distributed, fault-tolerant storage subsystem that replicates data across three Availability Zones, ensuring that multi-statement transactions with commit and rollback are fully durable and consistent. On the AWS Certified Database Specialty DBS-C01 exam, this concept tests your ability to distinguish between transactional relational databases and eventually consistent NoSQL services like DynamoDB, which offers only single-item ACID guarantees unless using its transactional API. A common trap is assuming all managed databases support multi-statement ACID transactions—Amazon RDS for PostgreSQL and Oracle also qualify, but DynamoDB and ElastiCache do not. Remember the memory tip: “Aurora and RDS are ACID’s relational core; DynamoDB needs a transaction call for more.”
This DBS-C01 practice question tests your understanding of workload-specific database design. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. 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.
Which TWO database services are most suitable for workloads that require ACID transactions?
Amazon Neptune
Why wrong: Neptune supports ACID but is a graph database, not general-purpose.
Amazon Timestream
Why wrong: Timestream does not support ACID transactions.
Amazon Aurora
Aurora is a relational database with full ACID support.
Amazon RDS for MySQL
RDS MySQL supports ACID transactions.
Amazon DynamoDB
Why wrong: DynamoDB supports transactions but with limitations; not traditionally ACID for all operations.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Amazon Aurora
Amazon Aurora is correct because it is a MySQL- and PostgreSQL-compatible relational database engine that provides full ACID (Atomicity, Consistency, Isolation, Durability) transaction support, including multi-statement transactions with commit and rollback. Aurora uses a distributed, fault-tolerant storage subsystem that replicates data across three Availability Zones, ensuring durability and consistency for transactional workloads.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Amazon Neptune
Why it's wrong here
Neptune supports ACID but is a graph database, not general-purpose.
Amazon Timestream
Why it's wrong here
Timestream does not support ACID transactions.
Amazon Aurora
Why this is correct
Aurora is a relational database with full ACID support.
Related concept
Read the scenario before looking for a memorised answer.
Amazon RDS for MySQL
Why this is correct
RDS MySQL supports ACID transactions.
Related concept
Read the scenario before looking for a memorised answer.
Amazon DynamoDB
Why it's wrong here
DynamoDB supports transactions but with limitations; not traditionally ACID for all operations.
Common exam traps
The trap here is that candidates often assume DynamoDB supports full ACID transactions because of its 'DynamoDB Transactions' feature, but those transactions are limited to a maximum of 25 items or 4 MB per transaction and do not provide the same isolation guarantees as a relational database, making it unsuitable for workloads requiring strict ACID compliance across many rows or tables.
Detailed technical explanation
ACID transactions rely on mechanisms like write-ahead logging (WAL), two-phase commit (2PC), and strict isolation levels (e.g., Serializable or Repeatable Read). In Aurora, the storage layer uses a quorum-based replication model (6 copies across 3 AZs) and a distributed consensus protocol to ensure that committed transactions survive failures, while the database engine handles locking and MVCC (Multi-Version Concurrency Control) to enforce isolation. A real-world scenario is an e-commerce order system that must atomically deduct inventory, create an order record, and process payment—any failure must roll back all changes, which only a fully ACID-compliant database can guarantee.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.
What to study next
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
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
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise DBS-C01 questions linked to Workload-Specific Database Design.
Practise DBS-C01 questions linked to Deployment and Migration.
Practise DBS-C01 questions linked to Management and Operations.
Practise DBS-C01 questions linked to Monitoring and Troubleshooting.
Practise DBS-C01 questions linked to Database Security.
Practise DBS-C01 questions linked to DBS-C01 fundamentals.
Practise DBS-C01 questions linked to DBS-C01 scenario.
Practise DBS-C01 questions linked to DBS-C01 troubleshooting.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Workload-Specific Database Design — This question tests Workload-Specific Database Design — Read the scenario before looking for a memorised answer..
The correct answer is: Amazon Aurora — Amazon Aurora is correct because it is a MySQL- and PostgreSQL-compatible relational database engine that provides full ACID (Atomicity, Consistency, Isolation, Durability) transaction support, including multi-statement transactions with commit and rollback. Aurora uses a distributed, fault-tolerant storage subsystem that replicates data across three Availability Zones, ensuring durability and consistency for transactional workloads.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Read the scenario before looking for a memorised answer.
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 →
Last reviewed: Jun 24, 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.