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 a transaction moves the database from one valid state to another, respecting constraints; it does not make a transaction indivisible. Atomicity provides all-or-nothing execution. Consistency is tempting because it also describes transaction correctness, and it would be the correct choice if the stem concerned integrity rules or constraint violations.
- ✗
Isolation
Why it's wrong here
Isolation keeps concurrently executing transactions from interfering, typically via locking or snapshotting; it does not make a single transaction indivisible. Atomicity covers all-or-nothing execution. Isolation is tempting because it also governs transaction behaviour, and it would be correct if the stem asked about preventing dirty reads or lost updates between concurrent transactions.
- ✓
Atomicity
Why this is correct
Atomicity guarantees a transaction executes entirely or not at all, treating it as one indivisible unit. If any statement fails, the whole transaction rolls back, leaving no partial writes. Consistency, isolation and durability address different guarantees, so atomicity satisfies the stem's requirement.
- ✗
Durability
Why it's wrong here
Durability guarantees committed transactions survive system failure, not indivisibility. Atomicity is the property ensuring a transaction executes entirely or not at all. Durability is tempting because it also concerns transaction reliability, and it would be the correct answer if the stem asked whether committed data persists after a crash or power loss.
Go deeper
Related to this question
About these practice questions
One of 1,004 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.