Microsoft · DP-750
Privileges and fine-grained access
DP-750 · Lesson 5 of 19 · 37:04
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: securable objects and principals, USE CATALOG, USE SCHEMA, and SELECT, inherited privileges and SHOW GRANTS, row-level and column-level security, row filters and column masks, dynamic views, and attribute-based access control with governed tags and policies. Includes three original practice questions.
Preview the topics
- The analysts group must query every current and future table of the gold schema, and nothing else in the catalog. Which grants are needed?
- Only the billing team may see customers’ bank account numbers, while everyone else keeps querying the same customers table. What should the team configure?
- Hundreds of tables in the production catalog have email columns, new tables arrive every week, and emails must be masked for everyone except the compliance team. What scales best?