Microsoft · DP-600
Direct Lake and incremental refresh
DP-600 · Lesson 15 of 15 · 1:30:52
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-600 exam (Microsoft Certified: Fabric Analytics Engineer Associate). In this lesson: Direct Lake on SQL and Direct Lake on OneLake, fallback to DirectQuery and the DirectLakeBehavior setting, framing and keeping data up to date, and incremental refresh with a real-time DirectQuery partition. Includes three original practice questions.
Preview the topics
- During development, a Direct Lake on SQL model must show an error whenever a query would fall back to DirectQuery, so the team can fix the cause. Which DirectLakeBehavior value fits?
- A nightly load writes Delta tables in several steps, and reports must never show half-loaded data. The model uses Direct Lake. What should the team do?
- A Sales table must keep five years of history, but each refresh should reload only the last ten days. What must the Power Query table use first?