DP-700 Monitor and Optimize an Analytics Solution Practice Question
A Power BI report using a semantic model in 'Direct Lake' mode is performing poorly. You want to determine if the queries are falling back to 'DirectQuery' mode due to memory constraints or unsupported DAX features. Which tool is best suited for this specific optimization task?
⚠ Common exam trap
Candidates frequently choose standard Power BI Service monitoring or generic workspace logs, missing the deep query tracing capabilities needed for Direct Lake analysis.
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
✓
DAX Studio
Direct Lake mode provides the performance of Import mode by reading Delta files directly from OneLake, but it can fall back to DirectQuery if certain conditions are not met. Using tools that can capture trace events and query execution plans is vital for identifying these fallbacks and ensuring the model remains in the high-performance Direct Lake state.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
DAX Studio
Why this is correct
DAX Studio can connect to the semantic model's XMLA endpoint and capture trace events. It allows you to see if a query was resolved using the Direct Lake fast path or if it fell back to DirectQuery mode, which is significantly slower and puts load on the SQL Analytics Endpoint.
- ✗
Spark UI
Why it's wrong here
The Spark UI is used to monitor the execution of Spark jobs and notebooks. While it is useful for data engineering tasks, it does not provide visibility into the Power BI semantic model's internal query routing or whether a DAX query is using Direct Lake or DirectQuery mode.
- ✗
SQL Server Management Studio (SSMS) Activity Monitor
Why it's wrong here
SSMS Activity Monitor is used to track active connections and resource usage on a SQL Server instance. While it can monitor the SQL Analytics Endpoint, it cannot tell you why a semantic model chose to use DirectQuery instead of Direct Lake for a specific visual's DAX query.
- ✗
OneLake Explorer
Why it's wrong here
OneLake Explorer is a tool for browsing files and folders within OneLake. It has no capabilities for tracing DAX query execution or monitoring the internal state and performance of Power BI semantic models during report interaction.
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.