Exam DP-300 topic 2 question 4 discussion

The answer is correct (0,xxx-xx,5), and here is an example of it --Create table Create Table Customers (ID int Primary Key identity(1,1) Not Null, Phone Nvarchar(100)) GO --Load Data insert into Customers Values ('555-555-0173'),('555-505-3124'),('555-689-4321') --Create user CREATE USER TestUser WITHOUT LOGIN; GRANT SELECT ON Customers TO TestUser; -- Test the User in Select data EXECUTE AS USER = 'TestUser'; SELECT * FROM Customers; REVERT; ---Now add Masking ALTER TABLE Customers ALTER COLUMN Phone nvarchar(100) MASKED WITH (FUNCTION= 'partial(0,"xxx-xxx",5)'); --Select the data again using Testuser EXECUTE AS USER = 'TestUser'; SELECT * FROM Customers; REVERT;

Given Answer is correct, it can be partial(0,"XXX-XXX",5) or partial(0,"XXX-XXX-",4)

The correct answer is: Exposed Prefix: 0 Padding String: XXX-XXX- Exposed Suffix: 4

Answer is correct: I tried with 'partial(0,"XXX-XXX-",5)' and the result looks like this: XXX-XXX--9876 (With double hyphen)

I'm sure the answer is 0,"XXX-XXX-",5

You should set Exposed prefix value to 0, because you do not want any of the initial digits from the phone number displayed. Padding string should be: XXX-XXX- Exposed Suffix could be 5, also if you want to display 4 digits.

For example: FirstName varchar(100) MASKED WITH (FUNCTION = 'partial(1, "xxxxx", 1)') NULL so the first name :Roberto ->Rxxxxxo prefix and suffix are the number that need to be exposed.

Note that the answer shown in the picture is correct, but the explanation is incorrect because the masking is wrong in the explantion.

Padding string should be xxx-xxx - but looks to wrongly mentioned answer.