Microsoft
70-432 · Question #91
You are the administrator of multiple SQL Server 2008 instances. You are designing a consolidated repository of performance data. You need to ensure that the following requirements are met: 1. The…
The correct answer is C. Configure a management data warehouse process on each instance to store and delete. See the full explanation below for the reasoning.
Question
You are the administrator of multiple SQL Server 2008 instances. You are designing a consolidated repository of performance data. You need to ensure that the following requirements are met: 1. The data collector is used to gather performance information. 2. A single database stores performance information for all instances. 3. Performance information that is older than 14 days is deleted. 4. Administrative effort to manage performance data is minimized. What should you do?
Options
- ACreate and schedule a single Microsoft SQL Service Integration Services (SSIS) package
- BCreate a SQL Agent job process on each instance to store and delete performance data in
- CConfigure a management data warehouse process on each instance to store and delete
- DConfigure an automated server-side trace process on each instance to store and delete
How the community answered
(32 responses)- A9% (3)
- C84% (27)
- D6% (2)
Community Discussion
No community discussion yet for this question.