PrepAway - Latest Free Exam Questions & Answers

What data collection process should you implement?

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply