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.
Question
Options
- Adurability
- Bisolation
- Catomicity
- Dconsistency
How the community answered
(50 responses)- A74% (37)
- B14% (7)
- C8% (4)
- D4% (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.
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.
Isolation ensures concurrent transactions do not interfere with each other, not that committed data survives system failures.
Atomicity ensures all operations in a transaction complete or none do, addressing completeness rather than post-commit persistence.
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
Community Discussion
No community discussion yet for this question.