You use Microsoft SQL Server 2016 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 writin
g queries.
Which isolation level should you use?
A. SERIALIZABLE
B. SNAPSHOT
C. READ COMMITTED SNAPSHOT
D. REPEATABLE READ
For most applications, read committed isolation using row versioning is recommended over snapshot isolation for the foll
owing reasons:
It consumes less tempdb space than snapshot isolation.
Etc.
References: https://msdn.microsoft.com/en-us/library/ms188277.aspx