How to Identify Fabric Warehouse Throttling

DP-600 Last updated

Optimize enterprise-scale semantic models

Short answer

D Use the Microsoft Fabric Capacity Metrics app to identify whether throttling is occurring and track rejected operations.

Question

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?

  1. the Capacity settings
  2. the Monitoring hub
  3. dynamic management views (DMVs)
  4. the Microsoft Fabric Capacity Metrics app Correct Answer

Key Takeaways

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.

Common mistake: 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.

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.

Community Votes

D
100%

100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 6 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded.

From public community threads 6

  1. XiltroX 👍 13 Answered D
    From MS Learn: The Microsoft Capacity Metrics app, also known as the metrics app, serves as a monitoring tool within the Microsoft Power BI service. It offers functionalities to track and analyze the resource utilization
  2. AndreaRosho1 👍 3 Answered D
    https://learn.microsoft.com/en-us/fabric/data-warehouse/compute-capacity-smoothing-throttling "Just like most Warehouse operations, dynamic management views (DMVs) are also classified as background and covered by the "Background Rejection" policy. As a result, DMVs cannot be queried when capacity is throttled. Even though DMVs are not available, capacity admins can go to Microsoft Fabric Capacity Metrics app to understand the root cause."
  3. Momoanwar 👍 2 Answered D
    Microsoft Fabric Capacity Metrics app for trottling
  4. stilferx 👍 1 Answered D
    IMHO, "D" Because: Track rejected operations The Microsoft Fabric Capacity Metrics app drilldown allows admins to see operations that were rejected during a throttling event. Here: https://learn.microsoft.com/en-us/fabric/enterprise/throttling#track-rejected-operations
  5. prabhjot 👍 1
    yes Ans D - https://learn.microsoft.com/en-us/fabric/enterprise/metrics-app
Show 1 more comment
  1. Rakesh16 👍 1 Answered D
    the Microsoft Fabric Capacity Metrics app

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Fabric Deployment Pipeline Folder Structure Behavior

S-Grade

Accessing OneLake Shortcuts in Fabric Notebooks

S-Grade

Direct Lake Fallback to DirectQuery with Row-Level Security

S-Grade

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide