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:
1. “There is high contention between readers and writers”
SNAPSHOT and RED COMMITTED SNAPSHOT will not apply share locks so minimize the
contention.
https://msdn.microsoft.com/en-us/library/ms173763.aspx
2. “need to minimize the use of the tempdb space”
RED COMMITTED SNAPSHOT uses less tempdb space.
https://msdn.microsoft.com/en-us/library/ms378149(v=sql.110).aspx
So the answer is RED COMMITTED SNAPSHOT