DP-600: Implement & Manage Semantic Models

Implement & Manage Semantic Models is one of the skill areas tested on the Fabric Analytics Engineer (DP-600) exam. Below are free DP-600 practice questions with worked answers and a concept diagram — each with a plain-language explanation. Practice the first 10 questions of DP-600 free, no signup.

The concept, in one picture

Concept flowHow Microsoft Fabric fits together
How Microsoft Fabric fits togetherOneLakeone copy of data for all enginesLakehousefiles + tables, Spark / SQLWarehouseT-SQL relational storeSemantic modelmeasures & relationshipsReport

2 free DP-600 Implement & Manage Semantic Models questions

Sample DP-600 question

In a Fabric tenant named Tenant1, a workspace named WS1 runs on a capacity named C1 and holds a dataset named DS1. To allow read-write connectivity to DS1 through the XMLA endpoint, which settings must you change first?

  • the Tenant1 settings
  • the C1 settings
  • the WS1 settings
  • the DS1 settings
Explanation

The XMLA Endpoint read-write option is configured per capacity in the Admin portal's Capacity settings. Turning it to Read Write on capacity C1 enables it for every workspace and semantic model on that capacity, so C1 must be modified first.

Sample DP-600 question

A Microsoft Fabric tenant includes a lakehouse named RetailLake. You want to stop tables that are newly created in RetailLake from being automatically included in the lakehouse's default semantic model. Where should you make this configuration change?

  • The SQL analytics endpoint settings
  • The default semantic model's settings
  • The workspace-level settings
  • The RetailLake item settings
Explanation

The automatic sync into the default semantic model is governed by the 'Sync the default Power BI semantic model' toggle found in the SQL analytics endpoint settings. Turning it off prevents new tables and views from being added to the default model automatically.

Practice DP-600 free

The first 10 questions of every exam are free. No signup, no email wall.

Start practicing →

Get a free DP-600 study plan by email

A short plan to work through DP-600 by skill area, plus a note when we add new questions. Optional — the practice above stays free. No spam, unsubscribe anytime.

More DP-600 skill areas