Exam 70-762 topic 1 question 144 discussion

Actual exam question from Microsoft's 70-762

Question #: 144
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: 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. . [email protected].
References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking

by neko at Jan. 4, 2020, 3:08 p.m.

Comments

Submit Cancel

gtc108

Highly Voted 5 years, 2 months ago

The answers are correct: Here is a very explanation on Dynamic Data Masking: https://www.tech-recipes.com/rx/69378/beginners-guide-to-dynamic-data-masking-in-sql-server/

upvoted 6 times

...

neko

Most Recent 5 years, 5 months ago

I think this is the exactly same question to #54 and answer is default() for money type as the best practice: 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

upvoted 3 times

New_user

5 years, 4 months ago

What do you think about "value between 1 and 100" condition?

upvoted 3 times

RobKozak

5 years, 4 months ago

masking the money datatype with default() will mask all data with 0.00 by using random(0,100) you will get a random number value between 0-100 which seems to meet the requirements in the question.

upvoted 12 times

Zikato

5 years, 4 months ago

But the correct random option has a wrong syntax - an extra apostrophe.

upvoted 1 times

JohnFan

5 years, 2 months ago

when someone without the UNMASK database right views this data, it will make the FirstName column value look like the default for string types which is ‘XXXX’, and the date value will appear to all be ‘1900-01-01’. Note that care should be taken that when you use a default that the default value isn’t used for calculations.

upvoted 1 times

...

Load full discussion...

...