DP-600 · Question #36
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. Wha
The correct answer is D. the Microsoft Fabric Capacity Metrics app. To identify if throttling is impacting warehouse query performance in Microsoft Fabric, you should use the Microsoft Fabric Capacity Metrics app.
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?
Options
- Athe Capacity settings
- Bthe Monitoring hub
- Cdynamic management views (DMVs)
- Dthe Microsoft Fabric Capacity Metrics app
How the community answered
(22 responses)- A5% (1)
- B9% (2)
- C14% (3)
- D73% (16)
Why each option
To identify if throttling is impacting warehouse query performance in Microsoft Fabric, you should use the Microsoft Fabric Capacity Metrics app.
Capacity settings allow configuration of capacity features but do not provide real-time monitoring or historical data on throttling events.
The Monitoring hub in Fabric offers an overview of items, activities, and data pipelines but lacks the granular capacity-specific metrics needed to diagnose throttling.
Dynamic management views (DMVs) provide insights into the internal state of a database engine, but the dedicated Fabric Capacity Metrics app is the primary tool for tenant-level capacity monitoring and throttling detection.
The Microsoft Fabric Capacity Metrics app provides detailed insights into capacity utilization, including CPU usage, throttling events, and overall capacity performance across different Fabric workloads like warehouses. It is designed specifically for monitoring and troubleshooting capacity-related issues at the tenant level.
Concept tested: Fabric capacity monitoring for throttling
Source: https://learn.microsoft.com/en-us/fabric/enterprise/monitoring-metrics-app
Topics
Community Discussion
No community discussion yet for this question.