What should you include in the recommendation?

You need to recommend a database reporting solution that meets the business requirements.

What should you include in the recommendation?
A . Data collection
B . Performance Monitor
C . A maintenance plan
D . A dynamic management view

View Answer

Answer: A

Explanation:

* Scenario: System administrators must be able to run real-time reports on disk usage.

* The data collector provides an historical report for each of the System Data collection sets. Each of the following reports use data that is stored in the management data warehouse:

Disk Usage Summary

Query Statistics History

Server Activity History

You can use these reports to obtain information for monitoring system capacity and troubleshooting system performance.