Microsoft Azure Data Fundamentals — Question 153

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?

Answer options

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

Correct answer: C

Explanation

This scenario exemplifies atomicity, as it ensures that a set of operations is treated as a single unit, which either fully completes or fails together. Consistency ensures that a database remains in a valid state, durability guarantees that completed transactions are persistent, and isolation ensures that transactions do not interfere with one another, but these do not specifically relate to the requirement that both actions must either succeed or fail together.