70-464 | You need to modify usp_GetOrdersAndItems…

Following is 70-464 | You need to modify usp_GetOrdersAndItems… from latest Microsoft practice test.

Question: 23

You need to modify usp_GetOrdersAndItems to ensure that an order is NOT retrieved by usp_GetOrdersAndItems while the order is being updated. What should you add to usp_GetOrdersAndItems?

A. Add SET TRANSACTION ISOLATION LEVEL SERIALIZABLE to line 03.
B. Add SET TRANSACTION ISOLATION LEVEL SNAPSHOT to line 03.
C. Add (UPDLOCK) to the end of line 06.
D. Add (READPAST) to the end of line 06.

Answer: D