You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table. 
In the options below， which compression technology should you use？（）

单项选择题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key.  So what action should you perform to achieve this goal？（）

A.You should drop the XML index on the table. Modify the primary key. Recreate the XML index 
B.You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. 
C.You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. 
D.You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.

单项选择题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this， you save the package definition to a file. Now you have to reexecute the package from the command line.  In the options below， which utility should you choose to use？（）

A.bcp.exe 
B.dta.exe 
C.dtexec.exe 
D.sqlmaint.exe

单项选择题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes， making sure that you reduce the effect on database availability to the least.  In the ALTER INDEX statement， which option should be included？（）

A.Sort in tempdb 
B.Online 
C.Fill factor 
D.Pad index 

单项选择题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. For some reason, now the company wants to view the number of users who access the SQL Server instance. The company CIO assigns this task to you. You have to use Windows System Monitor to find out the concrete number. Which performance object should you capture?（）

A.SQLServer:Buffer Manager 
B.SQLServer:Access Methods 
C.SQLServer:General Statistics 
D.SQLServer:Exec Statistics

单项选择题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration.  Which Resource Governor component should you configure?（）

A.The workload group which is used by default 
B.The workload group which is used by the finance application 
C.The classifier function which identifies the finance application 
D.The workload group which is used by the manufacturing application