Microsoft · DP-800
Protect the data
DP-800 · Lesson 9 of 20 · 1:05:39
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: transparent data encryption, Always Encrypted and column-level encryption, dynamic data masking and UNMASK, row-level security with filter and block predicates, and object-level permissions. Includes three original practice questions.
Preview the topics
- Support agents must see only the last four digits of each card number, while the fraud team sees full numbers, with no change to the application. What fits?
- Each store manager must see only the orders of their own store, and must be unable to insert an order for another store. What should the security policy contain?
- Analysts must read every current and future table of the Sales schema, but never the Payroll table, even if another role grants it. What fits?