Microsoft Azure Data Fundamentals — Question 212

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

Answer options

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

Correct answer: A

Explanation

The correct answer is atomicity, as it ensures that transactions are all-or-nothing, meaning they either get executed fully or not at all. Isolation refers to the separation of transactions to prevent interference, durability ensures that once a transaction is committed, it remains so even in the event of a failure, and consistency ensures that a transaction takes the database from one valid state to another.