A company has a fact table with a column 'ProductID' and a dimension table 'Product' with a column 'ProductID'. The relationship is one-to-many. However, the fact table also contains rows with 'ProductID' values that do not exist in the Product dimension. Users report that these rows are missing from reports. What should the model designer do to include these rows?

Change the relationship to many-to-many.

Use a calculated column in the fact table to replace missing ProductIDs with a default value.

Enable 'Assume referential integrity' on the relationship.

Add a row to the Product dimension for unknown products and map orphaned ProductIDs to it.

What is a composite model in Fabric semantic models?

A model that is created by merging two separate semantic models into one

A model that only uses DirectQuery for all tables

A model that uses multiple storage modes (e.g., Import and DirectQuery) in a single model

A model that combines multiple tables from the same source into one table

A company has a semantic model that uses Import mode for a fact table. They want to add a small dimension table that is stored in a SQL database and changes frequently. They want to avoid refreshing the entire model. What should they do?

Use Direct Lake for the dimension table

Create a separate semantic model for the dimension table

Import the dimension table and schedule frequent refreshes

Add the dimension table as a DirectQuery table in the same model

In DAX, what is the primary purpose of using variables in a measure?

To improve readability and performance by storing intermediate results

To create relationships between tables

To define the data type of a column

To reduce the number of measures in the model

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 3Objective 1

Design and Build Semantic Models DP-600 Practice Questions (Page 3)

Part of the Implement and manage semantic models domain, which accounts for 25–30% of the DP-600 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 5–10 from this objective — we provide 23 practice questions to prepare you well beyond it. (estimate)

23questions here

5free pages

7concepts

25–30%of the exam

Questions 11–15

11application · medium
A company has a fact table with a column 'ProductID' and a dimension table 'Product' with a column 'ProductID'. The relationship is one-to-many. However, the fact table also contains rows with 'ProductID' values that do not exist in the Product dimension. Users report that these rows are missing from reports. What should the model designer do to include these rows?
Select an answer first
12foundation · easy
In a star schema, which table type contains the measurable, numeric data that is aggregated in reports?
Select an answer first
13foundation · easy
What is a composite model in Fabric semantic models?
Select an answer first
14application · medium
A company has a semantic model that uses Import mode for a fact table. They want to add a small dimension table that is stored in a SQL database and changes frequently. They want to avoid refreshing the entire model. What should they do?
Select an answer first
15foundation · easy
In DAX, what is the primary purpose of using variables in a measure?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-600

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-600” is a trademark of its owner, used for identification only.

Design and Build Semantic Models DP-600 Practice Questions (Page 3)

Questions 11–15

In a star schema, which table type contains the measurable, numeric data that is aggregated in reports?

What is a composite model in Fabric semantic models?

A company has a semantic model that uses Import mode for a fact table. They want to add a small dimension table that is stored in a SQL database and changes frequently. They want to avoid refreshing the entire model. What should they do?

In DAX, what is the primary purpose of using variables in a measure?

Keep studying — Implement and manage semantic models