From the course: Azure Database Administrator Associate (DP-300) Cert Prep: 1 The Azure Data Platform

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Dynamic data masking

Dynamic data masking

- [Instructor] Dynamic data masking provides another method of securing sensitive data. Unlike transparent data encryption, dynamic data masking applies to data when it's being viewed by authenticated users. Masking is enabled at a column level within the database. It is most useful for protecting sensitive information that's stored right alongside less sensitive data. For instance, in a customer table, you might store the names as plain text, but want to protect credit card numbers from being read by analysts that also access the table. Columns protected by dynamic data masking will not display the actual values stored in the table. Instead, placeholder values will be returned to the user. The default masking format will replace text with four x's, numbers with the number 0, and dates with January 1st, 1900. Additional masking formats can be custom configured though. Individual users can be granted permission to view unmasked data and administrators will always see unmasked values…

Contents