Learn how to assign the various types of data masks to fields in an Azure SQL Database. This important task will provide an additional layer of protection to your data.
Successfully complete this lab by achieving the following learning objectives:
- Create and Configure a SQL Database
Create a Standard edition SQL Database with 10 DTUs. You will need to create a SQL Server as well. Use any unique name desired and create in the Central US region. Enable the sample database and update the firewall rules for access.
- Apply Data Mask Rules
Create an email mask for all customer emails. Create a masking scheme that masks all but the first letter of clients last names. Finally, create a complete mask for customer phone.
Once masking rules are complete create a test user login and confirm proper function.