Microsoft · DP-300
Compliance controls for sensitive data
DP-300 · Lesson 10 of 22 · 1:20:41
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-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: Data Discovery and Classification, auditing to storage, Log Analytics, or Event Hubs, change tracking and change data capture, dynamic data masking, row-level security with filter and block predicates, and ledger tables with digests stored outside the database. Includes three original practice questions.
Preview the topics
- Contoso’s security team wants to know which users ran queries that returned columns labeled Highly Confidential over the last month, and to query that history with KQL. What should it configure?
- Contoso’s store managers query a shared Sales table, and each must see only their own store’s rows, with no change to the reporting app. What should the team implement?
- Contoso must prove that nobody, not even a DBA, silently altered past prescriptions, while pharmacists can still correct mistakes. What fits?