Microsoft · DP-750
Tables, views, and foreign catalogs
DP-750 · Lesson 4 of 19 · 22:16
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: managed and external tables, constraints, ALTER TABLE, DROP and UNDROP, standard, dynamic, and materialized views, streaming tables, connections and foreign catalogs with Lakehouse Federation, and Genie Agents (formerly Genie spaces), knowledge stores, and instructions. Includes three original practice questions.
Preview the topics
- A morning dashboard aggregates three years of meter readings, takes several minutes to load, and is opened by two hundred users, who only need yesterday’s data. Which object should back the dashboard?
- Analysts need to join the CRM database in Azure SQL Database with the meter tables, governed by Unity Catalog, without building a pipeline to copy the data. What should the team set up?
- Business users ask Genie about their consumption, but the column is named kwh_qty, and Genie keeps choosing the wrong column. What should the team add first?