You use Microsoft SQL Server 2012 to write code for a transaction that contains several
statements.
There is high contention between readers and writers on several tables used by your
transaction.
You need to minimize the use of the tempdb space. You also need to prevent reading
queries from blocking writing queries.
Which isolation level should you use?
A.
SERIALIZABLE
B.
SNAPSHOT
C.
READ COMMITTED SNAPSHOT
D.
REPEATABLE READ
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms173763.aspx