Microsoft · DP-750
Data modeling
DP-750 · Lesson 9 of 19 · 1:10:47
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: partitioning rules, data skipping, liquid clustering, Z-ordering, and deletion vectors, atomic and aggregate grain, slowly changing dimension types 0 to 3 and MERGE, the change data feed, time travel, and history tables. Includes three original practice questions.
Preview the topics
- The forty terabyte meter readings table is filtered by meter ID and by reading date, and the filters may change next year. Which layout should a new version of the table use?
- When a customer changes tariff plans, old invoices must still be analyzed with the plan that was in force when they were issued. Which slowly changing dimension type fits the tariff attribute?
- From now on, engineers want every insert, update, and delete applied to the bronze invoices table, row by row, to debug the loads. What should they enable?