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. .aXXX@XXXX.com.Example 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”
29
0
random (1,100)
partial(3,”XXXXXXX”,0)
email()
34
0
I think we can use random only with INT datatype not with money
1
6
The email masking method exposes the first letter of an email address and the constant suffix “.com” in the form of an email address (aXXX@XXXX.com).
the requirement is to mask the value exept the first letter, the @ symbol and the top domain account, so the last 3 or 4 letters (.ps, .com). i think this question is misplaced. if you set the top domain with .com when my email is .fr your are masking also the top domain. by the way i would choose email() and i would give a feedback for the question.
0
0