单项选择题

You need to select the appropriate edition of SQL Server 2005 for the portable computers that are used in the Mortgage Data Cleansing project. Which edition should you use?（）

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

点击查看答案

上一题目录下一题

相关考题

单项选择题

You need to resolve the double counting of transactions issue in the existing reports. What should you do?（）

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.

单项选择题

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