You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the effects of setting IsolationLevel transaction property of a Data Flow task to Chaos.
Which of the following suitably describes the effect?
A.
It prevents pending changes from more highly isolated transactions from being overwritten.
B.
It prevents shared locks from being issued and exclusive locks from being honored.
C.
It prevents other users from updating the data.
D.
It reduces blocking by storing a version of data that one application can read while another is
modifying the same data.
Explanation: