nerdexam
Microsoft

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.

Submitted by lars.no· Mar 5, 2026Design and implement database solutions for SQL Server

Question

You need to recommend a disk monitoring solution that meets the business requirements. What should you include in the recommendation?

Options

  • Aa SQL Server Agent alert
  • Ba dynamic management view
  • Ca maintenance plan
  • Dan audit

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    88% (30)
  • C
    6% (2)
  • D
    3% (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.

Aa SQL Server Agent alert

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.

Ba dynamic management viewCorrect

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.

Ca maintenance plan

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.

Dan audit

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

#disk monitoring#DMVs#performance monitoring#I/O performance

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice