nerdexam
Microsoft

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.

Submitted by sofia.br· Mar 30, 2026Describe core data concepts

Question

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 complete, the other action must fail. Of which ACID semantic is this an example?

Options

  • Aconsistency
  • Bdurability
  • Catomicity
  • Disolation

How the community answered

(29 responses)
  • A
    10% (3)
  • C
    83% (24)
  • D
    7% (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.

Aconsistency

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.

Bdurability

Durability ensures committed data persists after system failures, addressing post-commit persistence rather than all-or-nothing execution.

CatomicityCorrect

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.

Disolation

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

#ACID properties#atomicity#transactions#database reliability

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice