DP-600 Maintain a Data Analytics Solution Practice Question
You need to perform maintenance on a shared Lakehouse in Microsoft Fabric. Before making schema changes, you want to identify which downstream reports and semantic models will be affected. Which tool should you use?
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 Lineage view in the workspace to perform an impact analysis on the Lakehouse.
Lineage view and impact analysis are essential for maintaining data integrity in a complex Fabric ecosystem. They provide a visual map of dependencies, allowing engineers to understand the consequences of their changes. This proactive approach prevents breaking downstream assets and helps in communicating maintenance windows to the appropriate stakeholders who rely on the affected data.
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 Capacity Metrics app to check for active user sessions on the Lakehouse.
Why it's wrong here
The Capacity Metrics app focuses on resource consumption and performance monitoring rather than metadata dependencies. While it can tell you who is currently using the capacity, it cannot show the structural relationships between a Lakehouse and the reports or semantic models that are built upon it. It is a tool for performance, not impact analysis.
- ✗
The SQL analytics endpoint to query the system metadata tables for dependencies.
Why it's wrong here
While the SQL analytics endpoint allows for data querying, it does not natively provide a comprehensive view of Power BI report dependencies or cross-workspace lineage. Querying system tables might reveal some internal SQL dependencies, but it lacks the holistic visibility into the entire Fabric item ecosystem required for a full impact assessment of schema changes.
- ✗
The 'Monitor' hub to view the history of data refresh operations for all items.
Why it's wrong here
The Monitor hub tracks the execution and status of background tasks like refreshes and pipeline runs. It provides a historical log of activity but does not map the architectural connections between items. Knowing that a report refreshed successfully does not tell you if it depends on a specific Lakehouse table you intend to modify.
- ✓
The Lineage view in the workspace to perform an impact analysis on the Lakehouse.
Why this is correct
Lineage view provides a graphical representation of the relationships between all items in a workspace and across workspaces. By selecting the Lakehouse and viewing its impact analysis, you can see every downstream semantic model and report. This is the standard method in Fabric for identifying dependencies before performing maintenance or updates.
About these practice questions
One of 12 original DP-600 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-600 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-600 exam.