Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
Which property of a transactional workload guarantees that each (DP-900)
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
A. atomicity
B. isolation
C. durability
D. consistency
Solution
Correct answer: A. atomicity.
Atomicity is the property of a transactional workload that guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely.
The key characteristics of atomicity are:
A. Atomicity: This property ensures that a transaction is treated as a single, indivisible unit of work. Either the entire transaction succeeds, or the entire transaction fails. There is no partial execution of a transaction.
B. Isolation: This property ensures that the execution of a transaction is independent of and invisible to other concurrent transactions.
C. Durability: This property ensures that the effects of a committed transaction are permanent and survive system failures, crashes, or restarts.
D. Consistency: This property ensures that a transaction takes the database from one valid state to another valid state, preserving data integrity.
Therefore, the property that guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely is atomicity.
Category: Core Data Concepts