Microsoft · DP-700
Loading patterns
DP-700 · Lesson 5 of 11 · 30:35
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-700 exam (Microsoft Certified: Fabric Data Engineer Associate). In this lesson: full and incremental loads with Copy job and high watermarks, change data capture versus watermark columns, star schemas, surrogate keys and slowly changing dimensions (types 1, 2, and 3), inferred members, and streaming loads with eventstreams and Spark Structured Streaming checkpoints. Includes three original practice questions.
Preview the topics
- A source database has change data capture enabled, and the lakehouse must reflect inserts, updates, and deletes. Which incremental approach fits?
- Analysts must see each sale under the region the customer belonged to at the time of the sale, even after the customer moves. Which approach fits?
- A Spark Structured Streaming job writes to a Delta table, and must resume exactly where it stopped after a failure. What must it use?