Design and build semantic models
10 practice questions under this official exam objective (DP-600) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Prevent Automatic Table Sync to Default Semantic Model in Fabric
To prevent new tables from automatically syncing to the default semantic model in a Microsoft Fabric lakehouse, you must configure the SQL analytics e
What Implements Calculation Groups for Direct Lake Semantic Models?
Contoso's Research division semantic models must run in Direct Lake mode, so calculation groups must be authored with an XMLA modeling tool rather tha
How to Implement a Date Dimension in a Fabric Lakehouse?
In Microsoft Fabric, a date dimension can be implemented either by populating a table with a dataflow or by creating a T-SQL view in a lakehouse. This
How to Prevent Implicit Measures in Power BI
Discover the two tools capable of preventing report creators from using implicit measures in a Microsoft Fabric semantic model. This guide confirms Po
Power BI Desktop View for Semantic Model Diagrams
To create a diagram of a semantic model containing only a specific table and its related tables in Power BI Desktop, you must use the Model view. This
Identify Surrogate Key Summarization in Power BI
Identifying surrogate key columns with incorrect Summarize By properties in a Power BI semantic model requires an automated scanning tool to minimize
Type 2 SCD Required Columns in Star Schema
Designing a star schema with a Type 2 slowly changing dimension (SCD) requires adding specific columns to track historical changes accurately. This gu
Programmatically Change Semantic Model Columns
Identify the correct tool for programmatically modifying semantic model columns in a Fabric tenant. This page establishes Tabular Editor as the best c
Which Columns to Include in DimProduct for a Star Schema
When designing a star schema in Microsoft Fabric, dimension tables must contain only descriptive attributes related to the entity. This page confirms
Automatically Add Lakehouse Tables to Default Semantic Model
To automatically add new tables from a Fabric lakehouse to the default semantic model, you must enable the sync setting. This page explains why enabli