BenchMark Quizzes by MDFT Pro

Identify the correct Dynamic Management View

You work for MDFT Pro, a well-known training agency. Your Fabric tenant contains a 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.
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

Exam Preparation Quiz

Identify the correct Dynamic Management View