What is the current masking function and which masking function should you use?

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.

View Answer

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