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

The correct answer is D. atomicity. A.C.I.D. properties: Atomicity, Consistency, Isolation, and Durability Atomicity - each statement in a transaction (to read, write, update or delete data) is treated as a single unit. Either the entire statement is executed, or none of it is executed. This property prevents…

Submitted by kevin_r· Mar 30, 2026Identify considerations for relational data on Azure

Question

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

Options

Aisolation
Bdurability
Cconsistency
Datomicity

How the community answered

(28 responses)

A
7% (2)
C
4% (1)
D
89% (25)

Explanation

A.C.I.D. properties: Atomicity, Consistency, Isolation, and Durability Atomicity - each statement in a transaction (to read, write, update or delete data) is treated as a single unit. Either the entire statement is executed, or none of it is executed. This property prevents data loss and corruption from occurring if, for example, if your streaming data source fails mid-stream.

Topics

#ACID properties#atomicity#transactional workloads#database transactions

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice