DP-600 Maintain a Data Analytics Solution Practice Question
You are using the Tabular Model Definition Language (TMDL) to maintain a complex semantic model in Microsoft Fabric. You need to make a bulk change to the descriptions of 50 different measures. What is the most efficient way to perform this maintenance task?
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
✓
Edit the individual .tmdl files in a code editor and sync the changes via Git.
TMDL is a human-readable format for defining semantic models, making it ideal for bulk maintenance and version control. By editing TMDL files in a text editor or using scripts, engineers can apply changes much faster than using a GUI. This approach is highly recommended for large-scale models where manual updates are time-consuming and prone to inconsistencies across different measures.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Edit the individual .tmdl files in a code editor and sync the changes via Git.
Why this is correct
TMDL files represent the model's structure in a clear, text-based format. By opening the repository in an editor like Visual Studio Code, you can use find-and-replace or multi-cursor editing to update all measure descriptions simultaneously. This method is efficient, supports version history through Git, and avoids the overhead of opening the model in a GUI.
- ✗
Manually update each description in the Power BI Desktop 'Model View' properties pane.
Why it's wrong here
While this is the standard way for small changes, manually updating 50 measures is inefficient and tedious. It increases the risk of human error, such as typos or missing a measure entirely. This approach does not leverage the benefits of TMDL or modern DevOps workflows that Fabric supports for more advanced model maintenance scenarios.
- ✗
Use a Power Automate flow to iterate through the measures and update them via the UI.
Why it's wrong here
Power Automate is not designed for direct manipulation of tabular model metadata at the measure level. While it can trigger refreshes or move files, it lacks the native integration required to edit DAX expressions or measure descriptions within a semantic model. TMDL or the Tabular Object Model (TOM) are the appropriate tools for these tasks.
- ✗
Delete the measures and recreate them using a SQL script in the Lakehouse endpoint.
Why it's wrong here
Measures are part of the semantic model's metadata and are not stored as physical columns in a Lakehouse table. Therefore, they cannot be managed or updated using SQL scripts in the Lakehouse endpoint. Deleting and recreating measures would also break any existing reports that depend on those measure IDs and their specific calculation logic.
About these practice questions
Courseiva writes every DP-600 question from scratch — 12 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-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.