exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 3 question 5 discussion

Actual exam question from Microsoft's DP-200
Question #: 5
Topic #: 3
[All DP-200 Questions]

HOTSPOT -
You have an Azure SQL database that contains a table named Customer. Customer contains the columns shown in the following table.

You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the following requirements:
✑ The first six numerals of the customer phone numbers must be masked.
✑ The last four digits of the customer phone numbers must be visible.
✑ Hyphens must be preserved and displayed.
How should you configure the dynamic data mask? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Exposed Prefix: 0 -
The first six digits must be masked. There is thus no exposed prefix.

Padding String: XXX-XXX -
The first six digits must be masked and hyphens must be preserved.

Exposed Suffix: 5 -
The last 4 digits must be visible. There is not option for 4 but we can use 5 as it would include the hyphen before the last 4 digits.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Abouraa
4 years ago
the answer of padding string , must be : XXX-XXX or XXX-XXX- ?
upvoted 1 times
kaigalmane
4 years ago
Yeah I too have doubt.
upvoted 1 times
kaigalmane
4 years ago
Since we don't have 4 for 3rd option, it should be XXX-XXX
upvoted 5 times
...
...
Puffin
4 years ago
I think it should be xxx-xxx- as all hyphens must be preserved. It also says xxx-xxx- in the answer explanation, so I'm 95% sure.
upvoted 1 times
lgtiza
3 years, 11 months ago
No, because the last hyphen is preserved in any case because of the "5" in the exposed suffix. Thus you only need XXX-XXX, but I'm 95% sure also, so flip your coin!
upvoted 1 times
...
...
...
NamishBansal
4 years, 1 month ago
correct, nice question
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...