nerdexam
Microsoft

DP-900 · Question #267

A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily…

The correct answer is A. durability. The ACID property of durability guarantees that committed transaction data persists even after a system failure. This ensures that completed transfers are not lost during outages.

Submitted by stefanr· Mar 30, 2026Describe core data concepts

Question

A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable. Of which ACID semantic is this an example?

Options

  • Adurability
  • Bisolation
  • Catomicity
  • Dconsistency

How the community answered

(50 responses)
  • A
    74% (37)
  • B
    14% (7)
  • C
    8% (4)
  • D
    4% (2)

Why each option

The ACID property of durability guarantees that committed transaction data persists even after a system failure. This ensures that completed transfers are not lost during outages.

AdurabilityCorrect

Durability is the ACID property that guarantees once a transaction is committed, the changes are permanently stored and survive system failures, crashes, or temporary unavailability. In this scenario, the committed balance updates must persist regardless of what happens to the database system afterward. This is typically implemented through write-ahead logging or similar recovery mechanisms.

Bisolation

Isolation ensures concurrent transactions do not interfere with each other, not that committed data survives system failures.

Catomicity

Atomicity ensures all operations in a transaction complete or none do, addressing completeness rather than post-commit persistence.

Dconsistency

Consistency ensures a transaction brings the database from one valid state to another valid state, not that committed data survives downtime.

Concept tested: ACID durability property in database transactions

Source: https://learn.microsoft.com/en-us/azure/cosmos-db/database-transactions-optimistic-concurrency

Topics

#ACID properties#durability#transactions#database reliability

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice