What data collection process should you implement?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance. A management data warehouse uses the data collector to collect performance data. You intend to maintain the management data warehouse. You have to implement a process that routinely gathers and uploads data in the management data warehouse on different schedules. What data collection process should you implement?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance. A management data warehouse uses the data collector to collect performance data. You intend to maintain the management data warehouse. You have to implement a process that routinely gathers and uploads data in the management data warehouse on different schedules. What data collection process should you implement?

A.
You should create a cached data collection.

B.
You should create a scheduled non-cached data collection.

C.
You should create an on-demand non-cached data collection.

D.
You should create two different SQL Agent jobs that are scheduled at the same time. One job creates a data collection and the other job uploads the data



Leave a Reply 0

Your email address will not be published. Required fields are marked *