nerdexam
Microsoft

DP-600 · Question #37

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 iden

The correct answer is A. sys.dm_exec_requests. https://learn.microsoft.com/en-us/fabric/data-warehouse/monitor-using-dmv

Submitted by krish.m· Apr 18, 2026Maintain a data analytics solution

Question

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?

Options

  • Asys.dm_exec_requests
  • Bsys.dm_exec_sessions
  • Csys.dm_exec_connections
  • Dsys.dm_pdw_exec_requests

How the community answered

(36 responses)
  • A
    81% (29)
  • B
    11% (4)
  • C
    3% (1)
  • D
    6% (2)

Explanation

https://learn.microsoft.com/en-us/fabric/data-warehouse/monitor-using-dmv

Topics

#Fabric Warehouse#Query Monitoring#Performance Troubleshooting#DMVs

Community Discussion

No community discussion yet for this question.

Full DP-600 Practice