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
B is correct.
0
0
B is not correct because it does not minimize the use of tempdb space. A and D will result in reading queries blocking writing queries. The best possible answer is C.
0
0
@’Mr Meat’: It looks like you are right:
[…]It consumes less tempdb space than snapshot isolation.[…]
Source: https://msdn.microsoft.com/en-us/library/ms188277.aspx
Please read the source-link for more information, especially about write/update conflicts in conjunction with (committed) snapshots.
0
0
Besides, part of the new 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0