ACID Atomicity in Database Transactions
A bank processes a fund transfer transaction. The system debits $100 from Account A and then credits $100 to Account B. If the system crashes after debiting Account A but before crediting Account B, the database automatically reverts the debit. Which ACID property ensures this behavior?
Quick Answer
The answer is atomicity. This ACID property ensures that a database transaction is treated as a single, indivisible unit of work, meaning it must either execute completely or not at all. In the bank transfer scenario, atomicity guarantees that if the system crashes after debiting Account A but before crediting Account B, the entire transaction is rolled back, reverting the partial debit to maintain data consistency. On the Microsoft Azure Data Fundamentals DP-900 exam, this concept tests your understanding of how Azure SQL Database or Cosmos DB handles transaction integrity, often appearing in scenario-based questions about fund transfers or inventory updates. A common trap is confusing atomicity with consistency—remember that atomicity focuses on the all-or-nothing execution of the transaction steps, not the validity of the data itself. For a quick memory tip, think of atomicity as "atom-sized": a transaction cannot be split into smaller parts; it either happens as one whole piece or gets erased entirely.
⚠ Common exam trap
It's easy for candidates to confuse atomicity with consistency, thinking that 'keeping the database in a valid state' is what triggers the rollback, but it is actually atomicity that enforces the all-or-nothing rule for the transaction itself.
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 ensures that a transaction is treated as a single, indivisible unit of work. If any part of the transaction fails (e.g., a crash after debiting Account A but before crediting Account B), the entire transaction is rolled back, reverting any partial changes like the debit. This all-or-nothing behavior is the core of atomicity in database systems.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Atomicity
Why this is correct
Correct - Atomicity guarantees that the transaction is all-or-nothing. The rollback of the debit upon crash is a direct result of atomicity enforcement.
- ✗
Consistency
Why it's wrong here
Incorrect - Consistency ensures that a transaction brings the database from one valid state to another, but it does not dictate that partial changes are rolled back on failure.
- ✗
Isolation
Why it's wrong here
Incorrect - Isolation ensures that concurrent transactions do not interfere with each other. It does not handle rollback of incomplete transactions.
- ✗
Durability
Why it's wrong here
Incorrect - Durability guarantees that committed changes persist even after a system failure. It does not apply to uncommitted transactions.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DP-900 question from scratch — 820 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on DP-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A bank processes a fund transfer that involves deducting money from one account and crediting it to another. The system ensures that both operations succeed together or, if any part fails, the entire transaction is rolled back, leaving both accounts unchanged. Which ACID property does this scenario primarily guarantee?
medium- A.Consistency
- B.Isolation
- C.Durability
- ✓ D.Atomicity
Why D: Atomicity ensures that a transaction is treated as a single, indivisible unit of work. In this fund transfer scenario, both the debit and credit operations must complete successfully, or the entire transaction is rolled back, leaving the accounts unchanged. This all-or-nothing behavior is the defining characteristic of atomicity in ACID transactions.
Variation 2. A bank processes online fund transfers. Each transaction must ensure that either both the debit from the sender's account and the credit to the receiver's account occur, or if any part fails, the entire transaction is rolled back. Which ACID property does this guarantee?
easy- ✓ A.Atomicity
- B.Consistency
- C.Isolation
- D.Durability
Why A: Atomicity ensures that a transaction is treated as a single, indivisible unit of work. In this fund transfer scenario, atomicity guarantees that both the debit and credit operations either complete successfully together or are fully rolled back if any part fails, preventing partial updates that could leave the system in an inconsistent state.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 practice question is part of Courseiva's free Microsoft 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 DP-900 exam.