Microsoft · DP-750
Transform and load data
DP-750 · Lesson 13 of 19 · 1:36:08
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-750 exam (Microsoft Certified: Azure Databricks Data Engineer Associate). In this lesson: inner, outer, semi, and anti joins, UNION, INTERSECT, and EXCEPT, denormalizing, PIVOT, and UNPIVOT, and loading with INSERT INTO, INSERT OVERWRITE, REPLACE WHERE, REPLACE USING, and MERGE INTO. Includes three original practice questions.
Preview the topics
- The team must list every meter in the readings table that has no matching customer in the customers table. Which operation fits?
- A partner sends a wide file, with one column for each month’s consumption, and the analysis needs one row per meter and month. Which operation reshapes it?
- Each day’s customer changes include new customers and existing ones. The silver customers table must update the existing rows and add the new ones, without duplicates. Which operation fits?