单项选择题
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.
相关考题
-
单项选择题
YouneedtorecordpackageandtaskoutcomeintheETLAudittable.WhichcomponentsofSSISshouldyouuse?（）
A.Custom event handlers
B.Data flow error output
C.SSIS log provider for SQL Server
D.Execute SQL tasks with failure precedence constraints -
单项选择题
Youneedtomeetthefrauddetectionrequirements.Whatshouldyoudo?（）
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. -
单项选择题
Youneedtodeliverthethreereportsthatdetailthepreviousdaystransactionactivity.Whatshouldyoudo?（）
A.Create a new report that has three embedded subreports. Create one standard subscription.
B.Create three new reports based on the same dataset. Create one data-driven subscription.
C.Create three data-driven subscriptions on a single shared schedule. Ensure that the e-mail recipient list is identical across all three subscriptions.
D.Create three standard subscriptions on a single shared schedule. Ensure that the mail recipient list and subject are identical across all three subscriptions.
