A.ROLAP storageB.Lazy aggregationsC.Write Enabled prope……

单项选择题YouneedtoselecttheappropriateeditionofSQLServer2005fortheportablecomputersthatareusedintheMortgageDataCleansingproject.Whicheditionshouldyouuse?（）

A.Microsoft SQL Server 2005 Mobile Edition
B.Microsoft SQL Server 2005 Express Edition
C.Microsoft SQL Server 2005 Standard Edition
D.Microsoft SQL Server 2005 Workgroup Edition

单项选择题Youneedtoresolvethedoublecountingoftransactionsissueintheexistingreports.Whatshouldyoudo?（）

A.Apply a many-to-many relationship between the Transaction measure group and the Person dimension in the WoodgroveSSAS database.
B.Apply a Conditional Split transformation in the Transaction data in the SSIS package.
C.Delete the AccountHolder table in the WoodgroveDW database.
D.Apply a foreign key relationship between the Person table and the Transaction table in the WoodgroveDW database.

单项选择题YouneedtoresolvetheblockingissuethatisaffectingtheperformanceoftheCRMsystem.Whatshouldyoudo?（）

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.