70-465 · Question #43
You need to recommend a disk monitoring solution that meets the business requirements. What should you include in the recommendation?
The correct answer is B. a dynamic management view. To monitor disk usage in SQL Server, Dynamic Management Views (DMVs) provide real-time insight into disk space, I/O statistics, and file usage without requiring additional configuration overhead.
Question
Options
- Aa SQL Server Agent alert
- Ba dynamic management view
- Ca maintenance plan
- Dan audit
How the community answered
(34 responses)- A3% (1)
- B88% (30)
- C6% (2)
- D3% (1)
Why each option
To monitor disk usage in SQL Server, Dynamic Management Views (DMVs) provide real-time insight into disk space, I/O statistics, and file usage without requiring additional configuration overhead.
SQL Server Agent alerts are event-driven notifications triggered by specific error conditions or performance thresholds, not a proactive disk monitoring solution that continuously tracks and reports disk usage metrics.
Dynamic Management Views (DMVs) such as sys.dm_os_volume_stats and sys.dm_io_virtual_file_stats allow administrators to query real-time disk usage, I/O performance, and available space directly from T-SQL. These views provide granular, on-demand monitoring data about disk and file-level activity, making them the ideal tool for a disk monitoring solution that needs to report current state and trends without additional tooling.
A maintenance plan is used to automate routine database tasks such as backups, index rebuilds, and integrity checks, and does not provide disk usage monitoring or reporting capabilities.
A SQL Server Audit is designed to track and log security-related events and access activity for compliance purposes, not to monitor disk space consumption or I/O performance.
Concept tested: Using DMVs for SQL Server disk monitoring
Source: https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-volume-stats-transact-sql
Topics
Community Discussion
No community discussion yet for this question.