BenchMark Quizzes by MDFT Pro

Identify the correct Dynamic Management View

You have been asked by MDFT Pro, a well-known training agency, to improve the performance of their Fabric warehouse. A user discovers that a report that usually takes two minutes to render has been running for 45 minutes and has still not rendered. You need to identify what is preventing the report query from completing.

Which warehouse Dynamic Management View (DMV) should you query?

Choose the correct answer from the options below.

Explanations for each answer:

sys.dm_exec_requests is correct. This DMV provides detailed information about currently executing requests, including their status, wait types, blocking information, and resource usage. This is exactly what you need to diagnose why a query is not completing.
sys.dm_exec_sessions is incorrect. This DMV shows information about all active sessions, but doesn't provide detailed information about currently executing requests and their status.
sys.dm_exec_connections is incorrect. This DMV shows information about connections to the database, but doesn't provide information about the status of executing queries.
sys.dm_pdw_exec_requests is incorrect. This DMV is specific to Azure Synapse Analytics (formerly SQL Data Warehouse) and is not available in Fabric warehouses.

Learn more about sys.dm_exec_requests:

sys.dm_exec_requests

Practice Exam

Identify the correct Dynamic Management View

Discuss this question on social media: