Exam 70-762 topic 1 question 54 discussion

Actual exam question from Microsoft's 70-762

Question #: 54
Topic #: 1

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:

Show Suggested Answer

Suggested Answer:

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
References:
https://msdn.microsoft.com/en-us/library/mt130841.aspx

by eric0117 at Jan. 7, 2020, 4:47 a.m.

Comments

Submit Cancel

eric0117

Highly Voted 5 years, 5 months ago

correct answer for BOX1 should be MASKED WITH (FUNCTION='RANDOM(1,100)')

upvoted 35 times

dp123

5 years, 4 months ago

Agree. https://www.sqlservercentral.com/steps/datatypes-and-the-default-mask-with-dynamic-data-masking

upvoted 1 times

...

SzalonyZielonyRobak

Highly Voted 5 years, 3 months ago

1) random 2) OK 3) OK

upvoted 9 times

...

TheDUdeu

Most Recent 4 years, 7 months ago

Now the first one can be random or default. The problem with default is that the data type can be figured out because a number will show 0. So random is a better option.

upvoted 1 times

BabyBee

4 years, 5 months ago

Random is the only option because of the request. It is requesting a number between 1-100, so only way to provide is getting a random (1,100), otherwise it will only provide 0's for a numeric field.

upvoted 1 times

...

strikersree

4 years, 12 months ago

Random, Partial, Email

upvoted 6 times

...