Microsoft
70-432 · Question #92
You are the administrator of 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…
The correct answer is A. Create a cached data collection. See the full explanation below for the reasoning.
Question
You are the administrator of 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?
Options
- ACreate a cached data collection.
- BCreate a scheduled non-cached data collection.
- CCreate an on-demand non-cached data collection.
- DCreate two different SQL Agent jobs that are scheduled at the same time.
How the community answered
(29 responses)- A83% (24)
- B10% (3)
- C3% (1)
- D3% (1)
Community Discussion
No community discussion yet for this question.