You manage a SQL Server 2008 instance. You plan to maintain a management data
warehouse that collects performance data by using the data collector.
You need 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.
Create a cached data collection.
B.
Create a scheduled non-cached data collection.
C.
Create an on-demand non-cached data collection.
D.
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 collection.
Explanation: