HOTSPOT
A company has a Microsoft Azure SQL Database instance that uses dynamic data masking.
You observe that numeric fields contain whole integers as masked data.
You need to display a zero value for numeric fields.
What is the current masking function and which masking function should you use? To answer, select the appropriate options in the answer area.
NOTE; Each correct selection is worth one point.
Answer:
Explanation:
Box 1: Random
A random masking function for use on any numeric type to mask the original value with a random value within a specified range.
Box 2: Default
Full masking according to the data types of the designated fields. For numeric data types use a zero value.
References: https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-2017