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

Question

You have a Fabric workspace that contains a warehouse named Warehouse1. While monitoring Warehouse1, you discover that query performance has degraded during the last 60 minutes. You need to isolate all the queries that were run in the last 60 minutes. The results must include the username of the users that submitted the queries and the query statements. What should you use?

Options

• Athe Microsoft Fabric Capacity Metrics app
• BViews from the queryinsights schema
• CThe sys.dm_exec_requests dynamic management view
• DThe sys.dm_exec_query_stats dynamic management view

Explanation

To isolate queries run in the last 60 minutes including username and statement for a degraded Warehouse, you should query the sys.dm_exec_requests dynamic management view.

Common mistakes.

• A. The Microsoft Fabric Capacity Metrics app provides high-level capacity usage metrics and doesn't offer detailed query statements or usernames.
• B. Views from the queryinsights schema are specifically designed for historical analysis of query performance in Fabric, which would be more comprehensive for 'all queries that were run'.
• D. The sys.dm_exec_query_stats dynamic management view provides aggregated performance statistics for query plans in the cache, not individual query statements or usernames for recent executions.

Concept tested. Fabric Warehouse query monitoring - sys.dm_exec_requests

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

No community discussion yet for this question.