From the course: Advanced Microsoft Fabric Implementation and Governance

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Challenge: Implement data masking

Challenge: Implement data masking

From the course: Advanced Microsoft Fabric Implementation and Governance

Start my 1-month free trial Buy for my team

Challenge: Implement data masking

“

(subtle electronic music) - [Instructor] In this Data Masking Challenge, we'll apply what we have learned about data masking to a field in your data lakehouse. This challenge should take about 15 minutes to complete. The challenge can be completed using either Fabric, SQL Server Management Studio, or Azure Data Studio. We'll be implementing a data mask of three Xs on the customer city. To complete this challenge, you need to create the SQL statements required to mass the data. To test it, you will need a user who has only read writes to the lakehouse. You must have more rights than read to be able to write the SQL required to add data masking. The SQL command requires an alter table and an alter column statement. After the change is complete, log into the database with another user ID to test it.

Contents