What is the primary purpose of a calculation group in a semantic model?

To group tables by their storage mode

To apply a set of calculation items to multiple measures without duplicating DAX

To define row-level security rules

To create relationships between tables

A company is building a semantic model that will contain a fact table with 300 million rows and several large dimension tables. The model will be used for enterprise reporting. The engineer wants to ensure the model can handle this size without hitting the default limit. What should the engineer do?

Use a composite model with DirectQuery for the large fact table.

Enable the large semantic model storage format in the model settings.

Partition the fact table by year and load each partition into a separate table.

Switch the model to Direct Lake mode so there is no row limit.

A retail company has a fact table of sales and a dimension table of products. Each product belongs to a category. Users want to filter sales by category. The relationship between the fact table and product table is one-to-many. What is the correct relationship configuration?

Create a bidirectional relationship between the product table and the fact table

Create a one-to-many relationship from the product table to the fact table, with the product table on the 'one' side

Create a many-to-one relationship from the fact table to the product table, with the fact table on the 'one' side

Create a many-to-many relationship between the product table and the fact table

What is a key advantage of using a composite model?

It eliminates the need for relationships between tables.

It allows you to combine data from multiple sources with different storage modes.

It automatically optimizes all queries for maximum performance.

It reduces the total number of tables in the model.

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 3Objective 1

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

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 6–10

6foundation · easy
What is the primary purpose of a calculation group in a semantic model?
Select an answer first
7application · medium
A company is building a semantic model that will contain a fact table with 300 million rows and several large dimension tables. The model will be used for enterprise reporting. The engineer wants to ensure the model can handle this size without hitting the default limit. What should the engineer do?
Select an answer first
8application · medium
A retail company has a fact table of sales and a dimension table of products. Each product belongs to a category. Users want to filter sales by category. The relationship between the fact table and product table is one-to-many. What is the correct relationship configuration?
Select an answer first
9foundation · easy
What is a key advantage of using a composite model?
Select an answer first
10foundation · easy
Which DAX function is an iterator that evaluates an expression for each row of a table and returns a single value?
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 2)

Questions 6–10

What is the primary purpose of a calculation group in a semantic model?

A retail company has a fact table of sales and a dimension table of products. Each product belongs to a category. Users want to filter sales by category. The relationship between the fact table and product table is one-to-many. What is the correct relationship configuration?

What is a key advantage of using a composite model?

Which DAX function is an iterator that evaluates an expression for each row of a table and returns a single value?

Keep studying — Implement and manage semantic models