Exam DP-200 topic 1 question 22 discussion

Actual exam question from Microsoft's DP-200

Question #: 22
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar(22).
You need to implement masking for the Customer_ID field to meet the following requirements:
✑ The first two prefix characters must be exposed.
✑ The last four suffix characters must be exposed.
✑ All other characters must be masked.
Solution: You implement data masking and use a credit card function mask.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
Must use Custom Text data masking, which exposes the first and last characters and adds a custom padding string in the middle.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dynamic-data-masking-get-started

by llt at June 11, 2020, 9:31 p.m.

Comments

Submit Cancel

memo43

4 years ago

answer is NO

upvoted 1 times

...

rajeshdp200

4 years, 11 months ago

Email Masking: Masking method, which exposes the first letter and replaces the domain with XXX.com using a constant string prefix in the form of an email address. [email protected] Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview

upvoted 3 times

naveen_nagavelly

4 years, 1 month ago

In the Question we have column "Customer_ID", I guess it is not related to Email also, the first two characters to show.

upvoted 1 times

...

llt

4 years, 12 months ago

Either Q22 or Q23 must have an option of 'last for SUFFIX characters must be exposed'. Now both options are the same. In real exam they have 'SUFFIX'. Anyhow, this option also makes the answer 'NO'.

upvoted 2 times

...