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:
http://msdn.microsoft.com/en-us/library/ms173763.aspx
C
C
If you check the link above (https://msdn.microsoft.com/en-us/library/ms173763.aspx) you will see that there is no such option READ COMMITTED SNAPSHOT.
So the correct answer must me B, I believe.
READ COMMITTED SNAPSHOT details available in below link :
https://msdn.microsoft.com/en-us/library/tcbchxcb(v=vs.110).aspx
Ok, It’s the question of terminology.
Agree that C is correct per this link: https://msdn.microsoft.com/en-us/library/ms188277.aspx