单项选择题

A.Replace the named query with an SQL view.B.Set the tr……

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.

单项选择题Youneedtoidentifythedataminingalgorithmthatmeetstherequirementsofthecreditdepartment.Whichalgorithmshouldyouuse?（）

A.Microsoft Clustering
B.Microsoft Decision Tree
C.Microsoft Nave Bayes
D.Microsoft Association

单项选择题YouneedtomaintainthepartitionsontheProductOrderStatusmeasuregroup.Whatshouldyoudo?（）

A.Create a Microsoft SQL Server 2005 Integration Services （SSIS） package that alters the partition queries and processes aggregated partitions every evening.
B.Enable proactive caching on the partitions. Set the cache to update periodically with a latency of 24 hours.
C.Set the rebuild interval of the partitions to 36 hours. Create a Microsoft SQL Server 2005 Integration Services （SSIS） package that processes aggregated partitions every evening.
D.Enable proactive caching on the ProductOrderStatus measure group. Set scheduled polling that re-processes the measure group whenever the system dates change.