Microsoft Azure Data Fundamentals — Question 225

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

Answer options

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

Correct answer: A

Explanation

The correct answer, atomicity, ensures that transactions are all-or-nothing, meaning they either fully complete or are fully rolled back. Durability refers to ensuring that completed transactions remain so even in the face of failures, isolation prevents concurrent transactions from interfering with each other, and consistency ensures that a transaction brings the database from one valid state to another.