Implementing Data Masking

Data masking is a technique used in SQL technologies to hide sensitive data in SQL query results from non-privileged users. In a Synapse SQL customer table, for example, credit card info might be masked as XXXX-XXXX-XXXX-1234 rather than displaying the complete number. The data itself is not changed in the tables, but the queries and views modify the data dynamically to mask sensitive information.

Note

This section primarily focuses on the Implement data masking concept of the DP-203: Data Engineering on Microsoft Azure exam.

The data masking feature helps enforce the following two requirements of Imaginary Airport Cabs (IAC):

• Not everyone should have access to all the data; it should be on a need-to-know basis.
• Customer privacy must be maintained at all costs.
• Older data should be safely deleted after a period of time, that is, from the time the data is created or becomes obsolete.

You can easily create a data mask in Azure...