單項選擇題

You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）

A.Replace the named query with an SQL view.
B.Set the transaction isolation level to serializable in the named query.
C.Set the source database to use snapshot isolation.
D.Set the transaction isolation level to repeatable read in the named query.

你可能感興趣的試題

單項選擇題

You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）

A.Custom event handlers
B.Data flow error output
C.SSIS log provider for SQL Server
D.Execute SQL tasks with failure precedence constraints

單項選擇題

You need to meet the fraud detection requirements. What should you do?（）

A.Use Percentage Sampling in SSIS.
B.Use a Neural Network Data mining algorithm.
C.Create an SSAS Key Performance Indicator for each account.
D.Monitor transactions by using SQL Server Profiler.