Posted by: Pdfprep
Post Date: October 28, 2020
HOTSPOT
You have a database named Sales.
You need to create a table named Customer that includes the columns described in the following table:
How should you complete the Transact SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.
Answer: 
Explanation:
Box 1: random Random is 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: partial
Box 3: email Email is a masking method which exposes the first letter of an email address and the constant suffix ".com", in the form of an email address. . [email protected].
References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking
Leave a Reply