Home » Microsoft » 70-762 » 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.
Hot Area:
Correct Answer:
Explanation/Reference:
Box 1: MASKED WITH (FUNCTION =’default()’)
TheDefualt masking method provides full masking according to the data types of the designated fields.
Example column definition syntax: Phone# varchar(12) MASKED WITH (FUNCTION = ‘default()’) NULL
Box 2: MASKED WITH (FUNCTION =’partial(3,"XXXXXX",0)’)
The Custom String Masking method exposes the first and last letters and adds a custom padding string in the middle. prefix,[padding],suffix examples:
Phone Number varchar(10) MASKED WITH (FUNCTION = ‘partial(5,"XXXXXXX",0)’)
Box 3: MASKED WITH (FUNCTION =’email()’)
The Email 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].
Example definition syntax: Email varchar(100) MASKEDWITH (FUNCTION = ’email()’) NULL
https://msdn.microsoft.com/en-us/library/mt130841.aspx