In a semantic model, what is the purpose of a bridge table?

To store slowly changing dimension attributes

To connect two fact tables directly

To store aggregated measures for faster querying

To resolve many-to-many relationships between dimensions

What is the primary benefit of enabling large semantic model storage format in Fabric?

It reduces the number of tables allowed in the model.

It enables real-time data ingestion from streaming sources.

It automatically creates aggregations for faster queries.

It allows the model to exceed the default size limit by storing data in a more efficient format.

A company has a large fact table in a data warehouse that is too large to import into a semantic model. They also have a small lookup table in a different database that changes frequently. Users need to combine these in a single semantic model. What should you do?

Import both tables into the model

Use DirectQuery for both tables

Create a composite model with DirectQuery for the large fact table and Import for the small lookup table

Create two separate semantic models and combine them in a report

What is the primary benefit of designing a semantic model as a star schema?

It eliminates the need for DAX measures.

It reduces the number of tables required in the model.

It guarantees data consistency across all source systems.

It simplifies relationships and improves query performance.

A finance team uses a semantic model with measures like Total Sales and Total Cost. They want to view these measures as 'Year to Date', 'Quarter to Date', and 'Month to Date' without creating separate measures for each time period. They also want the format of the values to change automatically based on the selected time period (e.g., currency for YTD, plain number for MTD). What should you implement?

Use a calculation group for time calculations, but keep the format fixed

Use a single measure with a SWITCH function to select the time period

Create a calculation group with calculation items for YTD, QTD, and MTD, and use dynamic format strings

Create separate measures for each time period and use a slicer to switch between them

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 3Objective 1

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

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 1–5

1foundation · easy
In a semantic model, what is the purpose of a bridge table?
Select an answer first
2foundation · easy
What is the primary benefit of enabling large semantic model storage format in Fabric?
Select an answer first
3application · medium
A company has a large fact table in a data warehouse that is too large to import into a semantic model. They also have a small lookup table in a different database that changes frequently. Users need to combine these in a single semantic model. What should you do?
Select an answer first
4foundation · easy
What is the primary benefit of designing a semantic model as a star schema?
Select an answer first
5application · medium
A finance team uses a semantic model with measures like Total Sales and Total Cost. They want to view these measures as 'Year to Date', 'Quarter to Date', and 'Month to Date' without creating separate measures for each time period. They also want the format of the values to change automatically based on the selected time period (e.g., currency for YTD, plain number for MTD). What should you implement?
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.