A.bcp.exe B.dta.exe C.dtexec.exe D.sqlmaint.exeYou work……

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

单项选择题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 which contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time.  So in the options below, which dynamic management view should you choose to use?（）

A.sys.dm_os_wait_stats 
B.sys.dm_exec_requests 
C.sys.dm_exec_sessions 
D.sys.dm_exec_query_stats

单项选择题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 which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.  These features will be discontinued. What should you do？ （）

A.The SQL Server 2008 Upgrade Advisor should be used. 
B.The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used. 
C.A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used 
D.A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.