A company is building a semantic model that will contain 300 GB of data. They plan to use Import mode. The Fabric capacity is sized for the expected memory usage. What should you configure to ensure the model can handle this large data size?

Use a composite model with DirectQuery for all tables

Enable large semantic model storage format

Use Direct Lake mode instead of Import

Increase the refresh frequency to reduce data size

A team is designing a semantic model for a real-time operational dashboard. The data source is a SQL Server table that is updated every minute. Users need to see the latest data without manual refresh. The table has 10 million rows. Which storage mode should they choose?

Import mode with frequent refresh

Composite model with DirectQuery for the fact table and Import for dimensions

A company's source database stores sales transactions with columns for product name, category, and supplier in the same table. The semantic model currently has one table with all these columns. Users report slow performance when filtering by category and supplier. You need to restructure the model to improve query performance. What should you do?

Create separate dimension tables for product and supplier, and connect them to the fact table with relationships

Create a single dimension table that includes product, category, and supplier attributes

Keep the single table but add indexes on the category and supplier columns

Use a bridge table to connect the fact table to the product table

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 3Objective 1

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

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 21–23

21application · medium
A company is building a semantic model that will contain 300 GB of data. They plan to use Import mode. The Fabric capacity is sized for the expected memory usage. What should you configure to ensure the model can handle this large data size?
Select an answer first
22application · medium
A team is designing a semantic model for a real-time operational dashboard. The data source is a SQL Server table that is updated every minute. Users need to see the latest data without manual refresh. The table has 10 million rows. Which storage mode should they choose?
Select an answer first
23application · medium
A company's source database stores sales transactions with columns for product name, category, and supplier in the same table. The semantic model currently has one table with all these columns. Users report slow performance when filtering by category and supplier. You need to restructure the model to improve query performance. What should you do?
Select an answer first

Finished these 3 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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 5)

Questions 21–23

A company is building a semantic model that will contain 300 GB of data. They plan to use Import mode. The Fabric capacity is sized for the expected memory usage. What should you configure to ensure the model can handle this large data size?

A team is designing a semantic model for a real-time operational dashboard. The data source is a SQL Server table that is updated every minute. Users need to see the latest data without manual refresh. The table has 10 million rows. Which storage mode should they choose?

Keep studying — Implement and manage semantic models