Microsoft Azure Data Fundamentals — Question 146

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?

Answer options

• A. durability
• B. isolation
• C. atomicity
• D. consistency

Correct answer: A

Explanation

The correct answer is durability because it ensures that once a transaction has been committed, it will remain in the system even in the event of failure. Isolation refers to transactions being executed independently, atomicity ensures transactions are all-or-nothing, and consistency ensures that a transaction brings the database from one valid state to another. However, none of these directly relate to preserving data after a failure like durability does.