Microsoft · DP-800
Specialized tables
DP-800 · Lesson 3 of 20 · 16:11
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-800 exam (Microsoft Certified: SQL AI Developer Associate). In this lesson: memory-optimized tables and their durability, system-versioned temporal tables and FOR SYSTEM_TIME, external tables over a data lake, updatable and append-only ledger tables, and node and edge tables. Includes three original practice questions.
Preview the topics
- Finance must report each product’s price exactly as it was on any past date, with no change to the application’s update statements. What fits?
- Analysts must join five years of clickstream Parquet files, in a data lake, with the orders table, without copying the files into the database. What fits?
- A payment log must accept new rows only, and auditors must be able to prove that no administrator changed or deleted a payment. What fits?