MCTS 70-442考試題庫由KillTest認證題庫網資深IT認證講師和MCTS產品專家結合PROMETRIC或VUE的真實70-442考試環境最新原題傾心打造。題庫覆蓋了當前最新的真實考題，並且全部附有正確答案，我們承諾題庫對MCTS 70-442(Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 is in development)考試原題完整覆蓋。70-442題庫助您輕鬆通過認證考試，一次不過全額退款。
MCTS 70-442(Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 is in development)考題由我們的資深IT認證講師和MCTS產品專家精心打造，包括了當前最新的真實70-442考題，全部附有正確答案。所有購買KillTest 70-442 題庫的客戶都將得到60天的免費升級服務，保證了客戶的一次通過率。KillTest IT認證題庫網助您一次通過MCTS 70-442考試。
1.You need to design the data access strategy for the Tailspin Toys online store search
requirement. Which strategy should you use?
A.System.Xml.XmlReader
B.System.Data.SqlClient.SqlDataReader
C.System.Data.DataSet
D.CLR userdefined type
Correct:C
2.You are troubleshooting concurrency problems with the code that was originally developed on
the SQL Server 2000 database. You discover that there are excessive read locks on important
tables. You need to resolve the problem. What should you do?
A.Set the transaction isolation level to REPEATABLE READ.
B.Set the transaction isolation level to SERIALIZABLE.
C.Set the ALLOW_SNAPSHOT_ISOLATION database option to ON.
D.Set the READ_COMMITTED_SNAPSHOT database option to ON.
Correct:D