Microsoft
70-450 · Question #116
You administer a SQL Server 2008 infrastructure. You want to monitor information on disk space growth of all the databases in every instance on a daily basis. You plan to design a monitoring process…
The correct answer is D. - Configure the management data warehouse (MDW) for all instances to populate the same. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 infrastructure. You want to monitor information on disk space growth of all the databases in every instance on a daily basis. You plan to design a monitoring process that performs the following tasks:
You need to implement the monitoring process by using the least amount of administrative effort. What should you do?
Options
- A
- Create a stored procedure to collect and remove disk space statistics for each instance.
- B
- Configure the management data warehouse (MDW) for all instances to populate the same
- C
- Create a Microsoft Windows PowerShell script to collect and remove disk space statistics
- D
- Configure the management data warehouse (MDW) for all instances to populate the same
How the community answered
(53 responses)- A6% (3)
- B11% (6)
- C4% (2)
- D79% (42)
Community Discussion
No community discussion yet for this question.