Microsoft
70-432 · Question #38
You are the administrator 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…
The correct answer is A. You should create a cached data collection. See the full explanation below for the reasoning.
Question
You are the administrator 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. Which process should you implement?
Options
- AYou should create a cached data collection
- BYou should create an on-demand non-cached data collection
- CYou should create a scheduled non-cached data collection
- DYou should create two different SQL Agent jobs that are scheduled stimultaneously
How the community answered
(46 responses)- A83% (38)
- B9% (4)
- C2% (1)
- D7% (3)
Community Discussion
No community discussion yet for this question.