A Power BI report uses a Direct Lake semantic model. The report has a slicer on 'Date' and a table visual showing 'Sales Amount' by 'Product'. The table visual takes 5 seconds to load. The administrator notices that the DAX query generated by the visual is scanning the entire fact table. What should they do to improve query performance?

Enable the 'Reduce data by using a filter' option on the visual.

Use a DAX measure that filters the data more efficiently, such as using CALCULATE with a specific date range.

Add an index on the 'Date' column in the Lakehouse table.

Change the visual to use a 'Drill down' hierarchy instead of a flat table.

Microsoft Certified:Fabric Analytics Engineer Associate

Domain 3Objective 2

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

16questions here

4free pages

6concepts

25–30%of the exam

Questions 16–16

16application · medium
A Power BI report uses a Direct Lake semantic model. The report has a slicer on 'Date' and a table visual showing 'Sales Amount' by 'Product'. The table visual takes 5 seconds to load. The administrator notices that the DAX query generated by the visual is scanning the entire fact table. What should they do to improve query performance?
Select an answer first

Finished these 1 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.

Optimize Enterprise-Scale Semantic Models DP-600 Practice Questions (Page 4)

Questions 16–16

Keep studying — Implement and manage semantic models