Microsoft · DP-700
Batch transformation
DP-700 · Lesson 7 of 11 · 40:24
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: choosing between Dataflow Gen2, PySpark, T-SQL, and KQL, transforming DataFrames and writing Delta tables, denormalizing and aggregating, and handling duplicates, missing values, and late-arriving data. Includes three original practice questions.
Preview the topics
- Telemetry lands in an eventhouse, and engineers must compute five-minute averages per device, in the store’s native language. Which language fits?
- A report joins sales, products, and categories in every query, and it is slow. Which transformation helps most?
- The source system sometimes sends an order twice, with the same order ID and a later update time. How should the engineer keep one row per order?