WHICH TRANSACTION PROPERTY ENSURES CHANGES ARE STILL PRESENT FOLLO...

20. Which transaction property ensures changes are still present following a crash

or system failure?

A. Atomicity

B. Consistency

C. Isolation

D. Durability

The correct answer is D. Durability ensures all changes are written to the

transaction log before being acknowledged to the application. Once written

to the log, SQL Server guarantees durability of committed transactions.

Chapter 14: Implementing Objects