DP-900 · Question #196
DP-900 Question #196: Real Exam Question with Answer & Explanation
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 data
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
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.
Community Discussion
No community discussion yet for this question.