DP-700 Monitor and Optimize an Analytics Solution Practice Question
Which THREE features are provided by the Fabric Capacity Metrics app for monitoring performance?
⚠ Common exam trap
Candidates assume the Capacity Metrics app tracks query semantic accuracy or data quality, rather than purely compute consumption, performance limits, and resource utilization.
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
✓
Identifying which users are consuming the most capacity.
The Fabric Capacity Metrics app is the standard tool for monitoring capacity health. It provides insights into when a capacity is overloaded, allowing you to identify which users or items are driving that consumption. By monitoring background operations and interactive queries, engineers can determine if they need to scale up their capacity or optimize existing workloads that consume too many compute resources.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Identifying which users are consuming the most capacity.
Why this is correct
The app tracks resource consumption by user, which helps administrators identify if specific users or departments are running inefficient reports or processes that lead to capacity throttling or high utilization, facilitating better resource management and potential user training on efficient query habits.
- ✗
Modifying the underlying SQL Server instance settings.
Why it's wrong here
Fabric is a SaaS platform where the underlying SQL infrastructure is managed by Microsoft. Users do not have access to modify the physical SQL Server settings, instance configurations, or hardware-level parameters, making this feature unavailable in the Capacity Metrics app.
- ✓
Monitoring interactive versus background operation usage.
Why this is correct
The app distinguishes between interactive operations, like Power BI report interactions, and background operations, like scheduled refreshes. This differentiation is critical for understanding where the primary demand on your capacity lies and how to schedule workloads to avoid peak times.
- ✓
Analyzing the consumption of specific Fabric items.
Why this is correct
You can drill down into individual items like Lakehouses, Data Warehouses, or Power BI semantic models to see how much capacity they consume. This allows you to identify 'noisy neighbors' or inefficient datasets that are disproportionately impacting your overall capacity performance.
- ✗
Automatically scaling the capacity SKU.
Why it's wrong here
The Capacity Metrics app provides monitoring and reporting, but it does not perform automated infrastructure scaling. Scaling the SKU must be performed manually through the Azure portal or the Fabric admin portal based on the insights provided by the application.
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.