單項(xiàng)選擇題

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 management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.
What process should you implement？（）

A.You should create a cached data collection
B.You should create an on-demand non-cached data collection
C.You should create a scheduled non-cached data collection
D.You should create two different SQL Agent jobs that are scheduled stimultaneously

你可能感興趣的試題

單項(xiàng)選擇題

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. You have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default trace is contained in the subdirectory.You have to backup the subdirectory.
Which SQL Server database engine subdirectory should be backed up？（）

A.DATA
B.INSTALL
C.LOG
D.BINN

單項(xiàng)選擇題

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 multiple Agent jobs. The jobs run each job on each day of the week by using seven shared schedules. You must make sure that a job named Job4 doesn'；t run Wednesday.
So what action should you perform to achieve this goal？（）

A.You should remove the schedule for Wednesday from Job5.
B.You should add a new Job5 schedule for Wednesday and disable it.
C.You should delete the schedule for Wednesday.
D.You should disable the schedule for Wednesday.