Which of the following suitably describes the effect?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *