How to Identify Fabric Warehouse Throttling
You have a Fabric tenant that contains a warehouse. Several times a day, the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse. What should you use to identify whether throttling is occurring?
Community Votes
100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
The question tests the ability to identify throttling in Fabric, where the common trap is assuming dynamic management views (DMVs) can be queried during throttling, despite DMVs being rejected themselves.
When Microsoft Fabric warehouse query performance degrades due to suspected compute throttling, administrators must use the correct monitoring tool to confirm throttling events. This page establishes that the Microsoft Fabric Capacity Metrics app is the required tool to track rejected operations and identify throttling.
Choosing dynamic management views (DMVs) because they are typically used for performance monitoring, but DMVs are classified as background operations and cannot be queried when the capacity is throttled.
Community Discussion (6 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
The Microsoft Fabric Capacity Metrics app provides a specific drilldown that allows capacity admins to see operations that were rejected during a throttling event. When a warehouse experiences performance degradation due to throttling, this app is the designated tool to confirm that throttling is occurring and to analyze its impact. It specifically tracks resource utilization and rejected operations, making it the definitive source for identifying throttling.Why the Other Options Are Wrong
The Capacity settings only allow you to configure capacity sizes and limits, not to monitor real-time throttling events or rejected queries. The Monitoring hub provides high-level visibility into the status of items and refreshes but lacks the specific drilldowns for capacity throttling and rejected operations. Dynamic management views (DMVs) are classified as background operations and are covered by the "Background Rejection" policy; therefore, they cannot be queried when capacity is throttled, rendering them useless in this exact scenario.Community Comment Notes
Commenters highlighted that DMVs are unavailable during throttling because they are rejected as background operations, as noted by AndreaRosho1. Another user, stilferx, pointed out that the Metrics app drilldown "allows admins to see operations that were rejected during a throttling event," which directly addresses the requirement to identify throttling.Official Reference
Exam Strategy
When dealing with Fabric performance degradation and throttling, remember that standard query monitoring tools like DMVs may themselves be rejected. Always look for the Microsoft Fabric Capacity Metrics app when asked to identify or track throttling and rejected operations.
Related Analysis
Practice All DP-600 Questions
Access 115 questions with complete answers and detailed explanations.
View Full DP-600 Practice Test →