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

Questions 1–5

1. 1foundation · easy

   What is the default refresh behavior for a Direct Lake semantic model in Fabric?

   • AThe model requires a scheduled refresh to update its data
   • BThe model automatically refreshes when the underlying OneLake data changes
   • CThe model must be manually refreshed after every data change
   • DThe model is refreshed only when a user opens a report
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A Power BI report uses a Direct Lake semantic model. The report has a page with a slicer on 'Year' and a line chart showing 'Sales Amount' by 'Month'. The line chart takes 3 seconds to load. The administrator wants to improve the visual performance. What should they do?

   • AChange the line chart to a bar chart, which is faster to render.
   • BRemove the slicer and use a page-level filter instead.
   • CEnable the 'Show items with no data' option on the line chart.
   • DUse a measure that calculates the sales amount for the selected year only, reducing the data scanned.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which scenario is best suited for Direct Lake on OneLake?

   • AMigrating an existing SQL Server data warehouse to Fabric
   • BRunning ad-hoc T-SQL queries against the data
   • CBuilding a semantic model that uses data from multiple OneLake tables
   • DCreating a real-time dashboard with streaming data
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which DAX pattern is recommended to improve performance when a measure is used repeatedly in a report?

   • ADuplicating the measure logic in each visual's filter
   • BWriting the measure as a complex nested expression
   • CStoring the measure result in a variable within the DAX expression
   • DUsing a calculated column to store the measure result
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A company has a Fabric semantic model with a fact table that grows by 1 million rows per day. The current refresh strategy is a full refresh every night, which takes 6 hours. The company wants to reduce the refresh time and ensure that the most recent data is available as soon as possible. What should they do?

   • AImplement incremental refresh with a daily refresh of the last 1 day and a monthly archive of 2 years.
   • BPerform a full refresh every week instead of every night, and accept that data may be up to 7 days old.
   • CUse a SQL analytics endpoint to pre-aggregate the data and then load the aggregated data into the semantic model.
   • DSwitch to Direct Lake mode, which eliminates the need for refresh entirely.
   Reveal Solution Discussion Select an answer first