Exam 70-764 topic 1 question 322 discussion

Actual exam question from Microsoft's 70-764

Question #: 322
Topic #: 1

Your company stored customer data, including credit card numbers, in a Microsoft SQL Server database. The CreditCardNum column is configured as a varchar
(16). When viewing the CreditCardNum column, only the last four digits of the card number should be displayed.
You have the following Transact-SQL statement. (Line numbers are included for reference only.)

You need to implement dynamic data masking for the CreditCardNum column.
Which Transact-SQL segment should you insert at line 05?

A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: C
Example:

Using "partial" function -
ALTER TABLE Ari_Users_Tbl ALTER COLUMN [CreditCard]
ADD MASKED WITH (FUNCTION = 'partial(0,"XXXX-XXXX-XXXX-",4)')
References: https://social.technet.microsoft.com/wiki/contents/articles/35003.sql-server-exposing-masked- data.aspx#Goal_2_Find_the_CreditCard_number_for_UserID_1

by TheSwedishGuy at Feb. 4, 2020, 1:25 p.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 5 months ago

0,xxxxxxxxxxxx,4 means that 0 chars will be shown in the beginning, followed by X's, then showing the last 4 actual characters.

upvoted 4 times

...