From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Implement dynamic data masking

Implement dynamic data masking

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Implement dynamic data masking

“

- Welcome back. This is lesson 6.4, Implement Dynamic Data Masking. Dynamic Data Masking is one of the many security features in SQL Server that provides a layer of security to its data. Dynamic Data Masking provides a critical security layer that limits exposure to sensitive data through data masking. Dynamic Data Masking works at the presentation layer by masking data and query results to non-privileged users. So masking data can greatly simplify the security design and code of your application. Dynamic Data Masking is based on policies which allows you to designate how much sensitive data should be revealed to your users. The key concept here with Dynamic Data Masking is that the underlying data isn't changed. A mask is simply applied at the presentation layer to help protect and obfuscate sensitive data. So let's take a look at how to implement Dynamic Data Masking in Azure SQL. In the Azure portal, once you have selected the appropriate SQL database, select the Dynamic Data…

Contents