70-465 | You need to implement changes to the system to reduce…

Following is 70-465 | You need to implement changes to the system to reduce… from latest Microsoft practice test.

Question: 18

You need to implement changes to the system to reduce contention and improve performance of the SalesOrderDetail table. Which three actions should you perform? Each correct answer presents part of the solution. Choose three.

A. Use (SNAPSHOT] hints in the report queries
B. ALTER DATABASE [ProdDB] SET READ_COMMITTED_SNAPSHOT ON
C. ALTER DATABASE [ProdDB] SET READ_COMMITTED_SNAPSHOT OFF
D. SET TRANSACTION ISOLATION LEVEL SNAPSHOT
E. Use (TABLOCK) hints in the report queries
F. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
G. ALTER DATABASE [ProdDB] SET ALLOW.SNAPSHOT ISOLATION ON
H. Use (SNAPSHOT] hints in the update statements

Answer: A,B,F