Implementing Analytics Solutions Using Microsoft Fabric — Question 58

You have a Fabric tenant that 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 dynamic management view (DMV) should you use?

Answer options

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

Correct answer: A

Explanation

The correct answer is A, sys.dm_exec_requests, as it provides information about the currently executing requests, which is essential for diagnosing long-running queries. Options B and C are not suitable because they deal with sessions and connections rather than active requests. Option D pertains to a specific execution context in parallel data warehouses, which may not apply to the current scenario.