DP-700 Question #36: Real Exam Question with Answer & Explanation

Question

You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures. You discover that the daily data load takes longer than expected. You need to monitor Warehouse1 to identify the names of users that are actively running queries. Which view should you use?

Options

• Asys.dm_exec_connections
• Bsys.dm_exec_requests
• Cqueryinsights.long_running_queries
• Dqueryinsights.frequently_run_queries
• Esys.dm_exec_sessions

Explanation

To identify users actively running queries in a Fabric Warehouse, you should use a dynamic management view that provides details about current user sessions.

Common mistakes.

• A. sys.dm_exec_connections provides information about connections but does not directly provide the user context for actively running queries in the same comprehensive way as sys.dm_exec_sessions.
• B. sys.dm_exec_requests provides details about currently executing requests but requires joining with sys.dm_exec_sessions to directly link requests to specific users efficiently.
• C. queryinsights.long_running_queries is a historical view that shows past long-running queries, not current active users or their live queries.
• D. queryinsights.frequently_run_queries is a historical view that shows queries run often, not current active users or their live queries.

Concept tested. Monitoring Fabric Warehouse active sessions and users

Reference. https://learn.microsoft.com/en-us/fabric/data-warehouse/monitor-warehouse#query-activity

No community discussion yet for this question.