Courseiva

DP-600 · topic practice

Implement and Manage Semantic Models practice questions

This domain covers building and tuning semantic models in Microsoft Fabric: table and column naming for Excel, currency conversion with dynamic format strings, incremental refresh policy configuration, and row-level security. Questions present a scenario and ask which setting, DAX expression, or policy JSON produces the required behavior for report authors and viewers.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Editorial oversight:Johnson Ajibi· MSc IT Security, IEEE Senior Member
20 questionsDomain: Implement and Manage Semantic Models

What the exam tests

What to know about Implement and Manage Semantic Models

Be able to configure a Fabric semantic model so report authors and viewers get correct names, currencies, refresh behavior, and security. The single most important thing: know which model-level setting or DAX expression controls the outcome, not the Power Query or report-layer equivalent.

Configuring model objects so Analyze in Excel exposes friendly table and column names

Implementing currency conversion using DAX and dynamic format strings on measures

Setting incremental refresh policy RangeStart and RangeEnd parameters to avoid reloading history

Applying row-level security roles and object-level security within a Fabric semantic model

Watch out for

Common Implement and Manage Semantic Models exam traps

  • ▸Assuming renaming a column in Power Query changes the name seen in Analyze in Excel; the model name is what matters
  • ▸Writing dynamic format strings that reference columns instead of measures, so formatting never applies
  • ▸Setting RangeStart and RangeEnd as static dates rather than parameters, so historical partitions reload every refresh

Practice set

Implement and Manage Semantic Models questions

20 questions · select your answer, then reveal the explanation

You are optimizing a semantic model that has a large number of tables and complex relationships. Which TWO practices should you follow to improve both performance and usability?

You have a semantic model with a 'Sales' table and a 'Date' table. There are two relationships between them: one based on 'OrderDate' (active) and one based on 'ShipDate' (inactive). You need to create a measure that calculates the 'Total Shipped Amount'. Which DAX function is required to use the inactive relationship?

A Microsoft Fabric tenant contains a massive Delta table in OneLake. You create a semantic model using Direct Lake mode to maximize performance. However, you notice that some queries are falling back to DirectQuery mode, significantly increasing latency. What is the most likely cause of this fallback behavior?

You are optimizing a complex semantic model in Microsoft Fabric that contains multiple many-to-many relationships and complex DAX measures. Which TWO tools should you use to identify performance bottlenecks in the query execution and the VertiPaq engine? (Choose two.)

You are managing a semantic model in a Microsoft Fabric workspace. You need to automate the deployment of changes from development to production using the Power BI REST API. Which THREE actions are supported through the API for managing semantic models? (Choose three.)

You are developing a semantic model in Microsoft Fabric. To improve the maintainability of time-based calculations like Year-to-Date (YTD) and Previous Year (PY) for multiple measures, you decide to use Calculation Groups. Which tool must you use to create and manage these groups?

You are designing a high-performance semantic model in Fabric. Which TWO practices should you follow to ensure the model remains optimized for the VertiPaq engine? (Choose two.)

You are creating a composite model that connects to an existing Power BI semantic model in a different workspace. You need to add a local Excel table to this model to perform 'what-if' analysis. What is a primary consideration when using this 'DirectQuery for Power BI datasets' approach?

You are managing a semantic model in Direct Lake mode. You have made significant updates to the underlying Delta table using a Spark notebook, including adding new columns and deleting old records. What must you do to ensure the semantic model reflects these changes?

You are troubleshooting a performance issue where a specific DAX measure is taking several seconds to calculate. You suspect that the 'Formula Engine' is being overloaded because the calculation cannot be pushed down to the 'Storage Engine'. Which DAX behavior most commonly causes this?

You need to enable Q&A for a semantic model. Which step is essential to ensure that the natural language engine correctly identifies relationships between tables?

You have a semantic model in Fabric. You need to enable automatic updates to the schema when the underlying data source changes. Which feature should you implement?

You are designing a semantic model for a sales department. The source data contains a Sales table with ten million rows and a Product table with five thousand rows. To optimize the model for performance and ease of use, you need to establish a relationship between these tables. Which relationship configuration is the best practice for this star schema?

A developer is writing a DAX measure to calculate total sales for the previous fiscal year. The measure must ignore any user-applied filters on the 'Date' table while keeping filters on other tables like 'Region'. Which DAX function is most appropriate for modifying the filter context in this specific way within a CALCULATE statement?

A semantic model in a Fabric Premium workspace is exceeding the memory limits during refresh. The model is currently 15 GB. You need to optimize the storage and memory footprint of this model. Which TWO actions should you take?

Refer to the exhibit. You are using the Power BI REST API to update the settings of a semantic model in a Fabric workspace. What is the primary purpose of setting the 'targetStorageMode' to 'PremiumFiles'?

Exhibit

PATCH https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}
{
  "targetStorageMode": "PremiumFiles"
}

You are managing a Direct Lake semantic model and want to improve performance for users who frequently query the same high-level summaries. You decide to use User-Defined Aggregations. Where must the aggregation tables be stored for a Direct Lake model to function correctly?

You are designing a semantic model in Microsoft Fabric that will be used by a large number of report consumers. The model contains a fact table with over 200 million rows and several dimension tables. You need to reduce the model size and improve query performance while ensuring that all existing DAX measures continue to work without modification. What should you do?

You are configuring a Direct Lake semantic model in Microsoft Fabric. You need to ensure that the model always reflects the latest data from the Lakehouse without manual intervention. What should you do?

You are building a semantic model in Microsoft Fabric. You have a 'Products' table with a column 'Category' and a 'Sales' table with a measure 'Total Sales'. You need to create a calculated column in the 'Products' table that ranks each product by 'Total Sales' within its category. Which DAX function should you use?

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Focused Implement and Manage Semantic Models sessions

Start a Implement and Manage Semantic Models only practice session

Every question in these sessions is drawn from the Implement and Manage Semantic Models domain — nothing else.

Related practice questions

Related DP-600 topic practice pages

Move into related areas when this topic feels solid.

Frequently asked questions

What does the DP-600 exam test about Implement and Manage Semantic Models?
Be able to configure a Fabric semantic model so report authors and viewers get correct names, currencies, refresh behavior, and security. The single most important thing: know which model-level setting or DAX expression controls the outcome, not the Power Query or report-layer equivalent.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Implement and Manage Semantic Models questions in a focused session?
Yes — the session launcher on this page draws every question from the Implement and Manage Semantic Models domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other DP-600 topics?
Use the topic links above to move to related areas, or go back to the DP-600 question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the DP-600 exam covers. They are not copied from any real exam or dump site.