DA0-002 Data Concepts and Environments Practice Question
An organization is implementing a data warehouse to support business intelligence reporting. The data warehouse must ensure that transactions are processed reliably. Which property guarantees that each transaction is treated as a single, indivisible unit?
⚠ Common exam trap
It's easy for candidates to confuse atomicity with consistency, thinking that 'indivisible unit' means the data must be consistent, but consistency is a separate property that ensures data integrity rules are met, not that the transaction is all-or-nothing.
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
✓
Atomicity
Atomicity (option C) is the correct property because it ensures that a transaction is treated as a single, indivisible unit of work. In the context of a data warehouse, this means that either all operations within the transaction are committed successfully, or none are applied, preventing partial updates that could corrupt the data. This is a core component of the ACID (Atomicity, Consistency, Isolation, Durability) model, which is fundamental to reliable transaction processing in databases like SQL Server, Oracle, or PostgreSQL.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Consistency
Why it's wrong here
Consistency ensures data integrity constraints are maintained.
- ✗
Isolation
Why it's wrong here
Isolation ensures concurrent transactions don't interfere.
- ✓
Atomicity
Why this is correct
Atomicity ensures a transaction is completed fully or not at all.
- ✗
Durability
Why it's wrong here
Durability ensures committed changes persist.
Go deeper
Related to this question
About these practice questions
One of 986 original DA0-002 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA 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 DA0-002 exam.