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-SQLsegments in the answer area.
Hot Area:
Answer: 
Explanation:
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] definition syntax: Email varchar(100) MASKEDWITH (FUNCTION = ’email()’) NULL
https://msdn.microsoft.com/en-us/library/mt130841.aspx
As the link: Box1 is Masked with( function=Random(1,100)) answer, because question requested “The entire field masked with a value between 1 and 100”
random (1,100)
partial(3,”XXXXXXX”,0)
email()