The answer is the requirement for a flexible schema with document data, along with the need for ACID transactions across multiple rows and the expected access pattern (key-value lookups versus complex queries). When choosing between DynamoDB and RDS, the schema flexibility of DynamoDB—where each item can have different attributes—makes it ideal for document-style workloads that evolve rapidly, while RDS enforces a rigid, predefined relational schema. On the AWS Certified Database Specialty exam, this question tests your ability to map workload characteristics to the right service: DynamoDB excels at high-scale, low-latency key-value and document access, whereas RDS is the go-to for complex joins, ad-hoc queries, and strict multi-row ACID compliance. A common trap is assuming DynamoDB cannot handle transactions at all—it can, but it is optimized for single-item or limited multi-item operations, not the complex multi-row transactions RDS handles natively. Memory tip: think “Flexible, Fast, Key-Value” for DynamoDB, and “Relational, Rigid, ACID” for RDS.
DBS-C01 Management and Operations Practice Question
This DBS-C01 practice question tests your understanding of management and operations. 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 THREE factors should be considered when choosing between Amazon DynamoDB and Amazon RDS for a new application? (Choose three.)
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Need for ACID transactions across multiple rows
Option A is correct because Amazon RDS supports ACID transactions across multiple rows using traditional SQL databases like MySQL or PostgreSQL, which is essential for applications requiring strict consistency (e.g., financial systems). Amazon DynamoDB, while supporting ACID transactions via the TransactGetItems and TransactWriteItems APIs, is optimized for single-item or limited multi-item operations and may not perform as well for complex multi-row transactional workloads. The need for ACID across multiple rows is a key differentiator favoring RDS.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✓
Need for ACID transactions across multiple rows
Why this is correct
RDS supports full ACID; DynamoDB supports transactional APIs but limited.
Related concept
Read the scenario before looking for a memorised answer.
✓
Need for complex join queries across multiple tables
Why this is correct
RDS supports joins; DynamoDB does not.
Related concept
Read the scenario before looking for a memorised answer.
✗
Need for automatic failover in multiple AWS Regions
Why it's wrong here
Both can be configured for multi-region.
✓
Requirement for flexible schema with document data
Why this is correct
DynamoDB is schema-less; RDS requires defined schema.
Related concept
Read the scenario before looking for a memorised answer.
✗
Data size exceeding 10 TB
Why it's wrong here
Both can handle large data sizes.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates assume automatic failover across multiple Regions is unique to one service, but both DynamoDB (global tables) and RDS (cross-Region read replicas with manual promotion) can achieve this, making it a non-differentiating factor.
Detailed technical explanation
How to think about this question
DynamoDB uses a leaderless, eventually consistent replication model for global tables, while RDS Multi-AZ provides synchronous replication to a standby in a different Availability Zone for automatic failover. For ACID transactions, RDS relies on traditional SQL isolation levels (e.g., Serializable) and two-phase commit, whereas DynamoDB's transactional APIs are limited to up to 25 items or 4 MB per transaction, making it less suitable for complex multi-row operations. The schema flexibility of DynamoDB (document data with attributes like Map and List) contrasts with RDS's fixed schema, which requires migrations for changes.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
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
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Management and Operations — This question tests Management and Operations — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Need for ACID transactions across multiple rows — Option A is correct because Amazon RDS supports ACID transactions across multiple rows using traditional SQL databases like MySQL or PostgreSQL, which is essential for applications requiring strict consistency (e.g., financial systems). Amazon DynamoDB, while supporting ACID transactions via the TransactGetItems and TransactWriteItems APIs, is optimized for single-item or limited multi-item operations and may not perform as well for complex multi-row transactional workloads. The need for ACID across multiple rows is a key differentiator favoring RDS.
What should I do if I get this DBS-C01 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
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 →
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.
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.