DP-700 Monitor and Optimize an Analytics Solution Practice Question
You are monitoring long-running Spark jobs in your Fabric workspace. You want to identify which specific stages of the job are consuming the most time. Which tool should you use?
⚠ Common exam trap
Candidates frequently confuse the Capacity Metrics app with the Spark UI, mistakenly believing that resource consumption monitoring tools can provide granular stage-level execution breakdowns for specific Spark jobs.
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
✓
Spark UI
The Spark UI (part of the Fabric monitoring tools) provides a granular view of job execution, including stage-by-stage breakdowns. This allows engineers to identify bottlenecks where specific stages might be skewing or taking longer than expected. Understanding the stage breakdown is essential for tuning Spark performance, as it highlights inefficient operations like excessive shuffling, data skew, or inefficient data partitioning that can delay the overall completion of complex data pipelines.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Fabric Capacity Metrics app
Why it's wrong here
The Capacity Metrics app is useful for monitoring overall resource consumption and smoothing, but it does not provide the fine-grained stage-level information required to debug individual Spark tasks. It is intended for administrators to manage capacity health, not for developers to debug specific Spark code performance.
- ✓
Spark UI
Why this is correct
The Spark UI provides an in-depth view of job execution, including DAG visualizations, stage durations, and task-level metrics. It is the primary tool for investigating performance bottlenecks within Spark jobs, allowing developers to drill down into why specific operations are taking longer than expected during execution.
- ✗
OneLake file explorer
Why it's wrong here
OneLake file explorer is designed for managing and viewing the physical storage of data in the Lakehouse. It does not provide any information regarding query performance, job execution times, or Spark stage metrics, making it an ineffective tool for troubleshooting the execution duration of Spark applications.
- ✗
Azure Monitor logs
Why it's wrong here
While Azure Monitor can capture high-level logs for resources, it does not ingest the detailed, low-level Spark execution metrics required to profile code performance. The Spark UI specifically captures the runtime metadata necessary for diagnosing efficiency issues during the actual execution of your data transformations and pipelines.
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.