PdfPrep.com

How should you complete the Transact SQL statement?

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. . aXXX@XXXX.com.

References:

https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking

Exit mobile version