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.
Lab info
Lab author
Challenge
Create a Sample Database
Create a database with sample data to demonstrate dynamic data masking.
Challenge
Create an SQL User Account
You will create an SQL user account and login to demonstrate the access capabilities.
Challenge
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.
Challenge
Mask String Values with a Custom Format
Mask string values with your preferred format.
Challenge
Grant Access to Users to View Masked Data
Remove masking from a column and grant access to users to view masked data.
Challenge
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.
Guided walkthrough
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.
Recommended prerequisites
- Download and install Azure Data Studio