DP-600 Maintain a Data Analytics Solution Practice Question
You plan to change the data type of a column in a gold-layer Lakehouse table. You need to use the 'Impact Analysis' feature to identify the potential consequences. Which THREE types of downstream items will be identified by this feature?
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
✓
Semantic models
Impact Analysis is a critical governance tool for maintaining data integrity across a Fabric tenant. It allows engineers to see how changes to a data source propagate through the environment. By identifying affected items before making changes, you can proactively notify stakeholders and update dependent logic, preventing broken reports and ensuring a reliable 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.
- ✓
Semantic models
Why this is correct
Semantic models sit directly on top of Lakehouse tables and are highly sensitive to schema changes. If a data type changes, measures or relationships within the model may break. Impact analysis identifies these models so developers can update the metadata and DAX calculations to align with the new schema.
- ✓
Reports
Why this is correct
Reports rely on the underlying semantic models to display data. If the model is affected by a change, the visuals in the report may fail to render or show incorrect information. Identifying these reports allows for thorough testing and validation of the end-user experience after the backend change is implemented.
- ✓
Dashboards
Why this is correct
Dashboards often contain pinned tiles from multiple reports. Because they are part of the downstream consumption layer, they are tracked in the impact analysis. Ensuring dashboards remain functional is essential for executive reporting, where reliability and consistency are paramount for decision-making and maintaining trust in the data.
- ✗
Data Pipelines
Why it's wrong here
Data pipelines are typically considered upstream or lateral processes that move data into the Lakehouse. While they are part of the lineage, impact analysis specifically focuses on the downstream consumers that would be 'broken' by a change. Pipelines would need to be checked separately for logic compatibility.
- ✗
Gateway connections
Why it's wrong here
Gateway connections are infrastructure components used to reach on-premises data sources. They are not data items themselves and do not appear in the impact analysis of a Lakehouse table. Changing a table schema in the cloud does not impact the configuration or status of an on-premises gateway.
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.