DP-900 · Question #271
A bank needs to ensure that a transaction involving debiting funds from a source account and crediting the same funds to a destination account must complete both actions. If either action falls to…
The correct answer is C. atomicity. Atomicity is the ACID property that treats a group of operations as a single indivisible unit, requiring all operations to succeed or all to be rolled back. A debit-credit pair that must fully complete or fully fail is the classic example.
Question
Options
- Aconsistency
- Bdurability
- Catomicity
- Disolation
How the community answered
(29 responses)- A10% (3)
- C83% (24)
- D7% (2)
Why each option
Atomicity is the ACID property that treats a group of operations as a single indivisible unit, requiring all operations to succeed or all to be rolled back. A debit-credit pair that must fully complete or fully fail is the classic example.
Consistency ensures data moves from one valid state to another according to defined rules and constraints, but does not govern whether both operations must succeed or fail together.
Durability ensures committed data persists after system failures, addressing post-commit persistence rather than all-or-nothing execution.
Atomicity guarantees that a transaction is treated as a single atomic unit of work - either all operations within the transaction commit successfully, or none of them do. In this banking scenario, the debit from the source account and the credit to the destination account are wrapped in one atomic transaction, so a failure in either operation causes the entire transaction to roll back, preventing partial updates.
Isolation controls how concurrent transactions interact with each other's intermediate states, not whether the operations within a single transaction all succeed or fail together.
Concept tested: ACID atomicity property in database transactions
Source: https://learn.microsoft.com/en-us/azure/cosmos-db/database-transactions-optimistic-concurrency
Topics
Community Discussion
No community discussion yet for this question.