Which scenario would most likely require enabling large semantic model storage format?

A model that needs to store more than 1 million rows in a single table

A small model with only a few thousand rows

A model that uses DirectQuery to a SQL Server database

A model that requires row-level security

A university tracks student enrollments. A student can enroll in multiple courses, and a course can have many students. The fact table records enrollment events. You need to build a semantic model that correctly counts the number of unique students per course. What should you do?

Create a direct many-to-many relationship between the student and course dimensions

Use a single dimension table that contains both student and course attributes

Create a bridge table between the student dimension and the course dimension, and use it in the relationship path

Add a calculated column to the fact table that concatenates student and course IDs

In a semantic model, what is the purpose of a dynamic format string?

To automatically create relationships between tables

To apply different number formats to a measure based on conditions

To change the data type of a measure at runtime

To optimize query performance by pre-aggregating values

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 3Objective 1

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

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 16–20

16foundation · easy
When creating a relationship between a dimension table and a fact table in a semantic model, which cardinality is most common and recommended for a star schema?
Select an answer first
17foundation · easy
Which scenario would most likely require enabling large semantic model storage format?
Select an answer first
18application · medium
A university tracks student enrollments. A student can enroll in multiple courses, and a course can have many students. The fact table records enrollment events. You need to build a semantic model that correctly counts the number of unique students per course. What should you do?
Select an answer first
19foundation · easy
A Fabric semantic model must support near-real-time reporting with minimal latency, but the underlying source data is large and changes frequently. Which storage mode should be selected to balance query performance with data freshness?
Select an answer first
20foundation · easy
In a semantic model, what is the purpose of a dynamic format string?
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 4)

Questions 16–20

When creating a relationship between a dimension table and a fact table in a semantic model, which cardinality is most common and recommended for a star schema?

Which scenario would most likely require enabling large semantic model storage format?

A university tracks student enrollments. A student can enroll in multiple courses, and a course can have many students. The fact table records enrollment events. You need to build a semantic model that correctly counts the number of unique students per course. What should you do?

A Fabric semantic model must support near-real-time reporting with minimal latency, but the underlying source data is large and changes frequently. Which storage mode should be selected to balance query performance with data freshness?

In a semantic model, what is the purpose of a dynamic format string?

Keep studying — Implement and manage semantic models