Which DMV would you query to view currently running requests in a Fabric data environment?

Which DMV would you query to view currently running requests in a Fabric data environment?

• A. sys.dm_exec_requests
• B. sys.dm_exec_query_stats
• C. sys.dm_exec_connections
• D. sys.dm_exec_sessions

Answer: (A)

This question tests identifying where active, in-flight work is reported. The DMV that shows currently executing requests provides a row for every request that is actively running, including details like session_id, status, command, and wait information. This makes it the right tool to see what work is happening right now, which sessions are running, and whether any are waiting or blocked. You can also join to the text of the running statement to view the exact SQL being executed. For context, other DMVs serve different purposes: one lists network connections, another lists user sessions, and another provides cached query performance statistics. Those don’t reflect real-time running requests the same way. If you need to see the exact query text of the active requests, you can use the sql_handle from the active row and cross apply to retrieve the text. So, to view currently running requests, query the DMV that reports in-progress work.

This question tests identifying where active, in-flight work is reported. The DMV that shows currently executing requests provides a row for every request that is actively running, including details like session_id, status, command, and wait information. This makes it the right tool to see what work is happening right now, which sessions are running, and whether any are waiting or blocked. You can also join to the text of the running statement to view the exact SQL being executed.

For context, other DMVs serve different purposes: one lists network connections, another lists user sessions, and another provides cached query performance statistics. Those don’t reflect real-time running requests the same way. If you need to see the exact query text of the active requests, you can use the sql_handle from the active row and cross apply to retrieve the text.

So, to view currently running requests, query the DMV that reports in-progress work.