70-465 Question #79: Real Exam Question with Answer & Explanation

Question

You need to address the requirements for disc usage monitoring for the SQL Servers. What should you do?

Options

• AYou should configure disc quotas.
• BYou should configure a Dynamic Management View.
• CYou should configure alerts sent by the SQL Server Agent.
• DYou should configure a SQL Server Maintenance Plan.

Explanation

To monitor disc usage for SQL Servers, Dynamic Management Views (DMVs) are the appropriate tool as they provide real-time performance and operational data directly from the server.

Common mistakes.

• A. Disc quotas are used to limit the amount of disk space a user or group can consume, acting as a preventative measure rather than a tool for monitoring ongoing disc usage.
• C. SQL Server Agent alerts notify administrators about predefined conditions or events related to disc usage, but they do not provide the detailed, ongoing metrics required for direct disc usage monitoring.
• D. SQL Server Maintenance Plans automate routine database maintenance tasks like backups and index rebuilds, but they are not designed for monitoring disc usage metrics.

Concept tested. SQL Server performance monitoring with DMVs

Reference. https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-io-virtual-file-stats-transact-sql

No community discussion yet for this question.