Which component is required to implement incremental refresh in a Fabric semantic model?

A Power BI Gateway for data refresh

A SQL data warehouse as the data source

A date column in the fact table

A measure that calculates the last refresh date

What is a common method to improve the performance of report visuals that use large fact tables?

Converting the visual to a table to see all rows

Adding more columns to the visual to provide context

Using a page-level filter to restrict the data to the current user's department

Pre-aggregating data in the visual using a measure that sums at a higher grain

In a Fabric semantic model using Direct Lake, what is the purpose of the default fallback setting?

To automatically switch the model to Import mode if Direct Lake queries fail

To refresh the model's data from OneLake automatically

To change the storage mode of the model to a hybrid mode

To allow the model to use DirectQuery when Direct Lake cannot process a query

Which report visual optimization technique reduces the amount of data that must be transferred to the client?

Using a custom visual that loads all data locally

Applying a filter to limit the visual to the last 12 months

Disabling query reduction in the report settings

Increasing the number of data points displayed on a chart

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 3Objective 2

Optimize Enterprise-Scale 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 16 practice questions to prepare you well beyond it. (estimate)

16questions here

4free pages

6concepts

25–30%of the exam

Questions 6–10

6foundation · easy
Which component is required to implement incremental refresh in a Fabric semantic model?
Select an answer first
7foundation · easy
Which DAX function is generally more efficient for iterating over a table to compute a sum?
Select an answer first
8foundation · easy
What is a common method to improve the performance of report visuals that use large fact tables?
Select an answer first
9foundation · easy
In a Fabric semantic model using Direct Lake, what is the purpose of the default fallback setting?
Select an answer first
10foundation · easy
Which report visual optimization technique reduces the amount of data that must be transferred to the client?
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.