DP-700 Monitor and Optimize an Analytics Solution Practice Question
Your organization uses Power BI in Fabric. Users report that reports are slow to load. You want to identify which specific visuals are causing the performance bottleneck. Which tool should you use?
⚠ Common exam trap
Candidates often suggest using the Power BI Service 'Usage Metrics' report. While useful for views, it lacks the visual-level granularity required to diagnose specific DAX or rendering bottlenecks.
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
✓
Power BI Performance Analyzer
Performance Analyzer is the built-in tool in Power BI Desktop designed to capture the execution duration of every visual on a report page. It provides a breakdown of time spent on DAX queries, visual rendering, and other processes. This allows developers to isolate slow-performing visuals, optimize the underlying DAX expressions, or simplify the report page layout to enhance the end-user experience.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
SQL Server Profiler
Why it's wrong here
SQL Server Profiler is a legacy tool for tracing database events on traditional SQL Server instances. It is not suitable for capturing performance telemetry for modern Power BI report visuals or analyzing DAX query execution paths within the Fabric environment.
- ✓
Power BI Performance Analyzer
Why this is correct
Performance Analyzer allows developers to record and view performance information for report elements. It logs the exact time taken for query execution, visual display, and other operations, making it the definitive tool for pinpointing which visuals contribute to report load time latency.
- ✗
Fabric Monitoring Hub
Why it's wrong here
The Monitoring Hub provides high-level capacity and activity performance metrics but does not offer granular visual-level performance debugging. It is useful for platform-wide health monitoring but lacks the capability to analyze report-specific visual rendering times and individual DAX query performance.
- ✗
Power BI Service Audit Logs
Why it's wrong here
Audit logs track user activity and administrative events, such as who accessed a report and when. They do not contain technical performance telemetry like rendering times or query execution durations, which are necessary for identifying specific visuals that perform slowly during the loading process.
About these practice questions
One of 152 original DP-700 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.