Manage Sensitive Data with Dynamic Data Masking and Data Encryption
In this lab, you’ll manage sensitive data with Azure SQL Database through dynamic data masking and data encryption. When you’re finished with this lab, you’ll have experience setting up dynamic data masking and data encryption in the Azure portal.
Terms and conditions apply.
Create a Sample Database
Create a database with sample data to demonstrate dynamic data masking.
Create an SQL User Account
You will create an SQL user account and login to demonstrate the access capabilities.
Set up Dynamic Data Masking from the Azure Portal
You will add masks to the necessary columns in your database and add masking rules to columns.
Mask String Values with a Custom Format
Mask string values with your preferred format.
Grant Access to Users to View Masked Data
Remove masking from a column and grant access to users to view masked data.
Manage Transparent Data Encryption in Azure Portal
Locate and enable or disable data encryption.
Provided environment for hands-on practice
We will provide the credentials and environment necessary for you to practice right within your browser.
Follow along with the author’s guided walkthrough and build something new in your provided environment!
Did you know?
On average, you retain 75% more of your learning if you get time for practice.
- Download and install Azure Data Studio