单项选择题

A.Custom event handlersB.Data flow error outputC.SSIS l……

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

<上一题目录下一题>

热门试题

单项选择题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.

单项选择题YouneedtodesignastoragemodefortheProductOrderStatusmeasuregroup.Whatshouldyoudo?（）

A.Use ROLAP for the Historical partition and MOLAP for the CurrentDay partition.
B.Use MOLAP for the Historical partition and ROLAP for the CurrentDay partition.
C.Use ROLAP for the Historical partition and Automatic MOLAP for the CurrentDay partition.
D.Use HOLAP for the Historical partition and Low-latency MOLAP for the CurrentDay partition.