DP-700 Monitor and Optimize an Analytics Solution Practice Question
A Microsoft Fabric tenant is experiencing frequent throttling of background operations during the early morning hours. You have been tasked with identifying which specific items are consuming the most capacity units (CU) to determine if a workload needs to be rescheduled. Which tool should you use to get the most granular view of item-level CU consumption over a 14-day period?
⚠ Common exam trap
Candidates often suggest checking the 'Fabric Admin Portal' or 'Azure Monitor'. While these have global data, they do not offer the granular, item-specific CU consumption breakdown found in the dedicated app.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The Microsoft Fabric Capacity Metrics app.
Monitoring Fabric capacity usage is essential for maintaining cost-effectiveness and ensuring that background and interactive operations do not lead to throttling. The Fabric Capacity Metrics app provides granular visibility into CU consumption by specific items, allowing engineers to identify 'top talkers' that might be exhausting the allocated SKU limits. Understanding these metrics helps in deciding whether to scale up or optimize high-impact workloads.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The Microsoft 365 Admin Center usage reports.
Why it's wrong here
These reports provide high-level overview metrics regarding user activity and license assignment across the entire Microsoft 365 ecosystem. They lack the specific granularity required to track individual Fabric item Compute Unit usage or differentiate between interactive and background processing tasks occurring within a specific Fabric capacity environment.
- ✓
The Microsoft Fabric Capacity Metrics app.
Why this is correct
This application provides detailed visual insights into how individual items like notebooks, pipelines, and semantic models consume capacity over time. It allows data engineers to drill down into specific time intervals to see the impact of background versus interactive operations and identify specific items responsible for capacity exhaustion.
- ✗
Azure Monitor Log Analytics workspace queries.
Why it's wrong here
While Log Analytics can store diagnostic logs from Fabric, it requires manual configuration of diagnostic settings and complex KQL query authoring to replicate the built-in visualizations of the metrics app. It is not the most direct or efficient tool for viewing item-level CU consumption for immediate troubleshooting.
- ✗
The Workspace settings 'Usage Metrics' tab.
Why it's wrong here
Usage metrics within a workspace settings focus primarily on report views, user access patterns, and performance from an end-user perspective for Power BI content. They do not provide the technical Compute Unit consumption data necessary to diagnose capacity-level throttling or the performance of background engine operations.
About these practice questions
Courseiva writes every DP-700 question from scratch — 152 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This DP-700 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-700 exam.