Microsoft · DP-600
Clean and enrich data
DP-600 · Lesson 7 of 15 · 42:07
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: removing duplicates, handling missing values and data types, filters and join kinds, and enriching data with new columns, in Dataflow Gen2, PySpark, and T-SQL. Includes three original practice questions.
Preview the topics
- After Remove duplicates on the Customer column, Contoso and CONTOSO still appear as two rows. What should the analyst do first?
- The team must list every order whose customer ID does not exist in the customer table. Which join kind returns exactly those orders?
- Reports need a Size column that says Large when an order is over $1,000, and Small otherwise, with no code. What should the analyst add?