ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to Exam

Exam DP-700 topic 1 question 45 discussion

Actual exam question from Microsoft's DP-700
Question #: 45
Topic #: 1
[All DP-700 Questions]

HOTSPOT
-

You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains a table named DimCustomers. DimCustomers contains the following columns:

• CustomerName
• CustomerID
• BirthDate
• EmailAddress

You need to configure security to meet the following requirements:

• BirthDate in DimCustomer must be masked and display 1900-01-01.
• EmailAddress in DimCustomer must be masked and display only the first leading character and the last five characters.

How should you complete the statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by 5e89616 at April 8, 2025, 12:15 p.m.

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
Submit Cancel
Biju1
Highly Voted 1 month, 1 week ago
default() Partial() are correct. verified. you can try it in azure sql too
upvoted 5 times
...
PJLB
Highly Voted 1 month, 1 week ago
BirthDate: default() <- each datatype has a default EmailAddress: partial()
upvoted 5 times
...
Nilakhi
Most Recent 2 weeks, 6 days ago
1. default() - For date and time data types, use 1900-01-01 00:00:00.0000000 2. email() - Masking method that exposes the first letter of an email address and the constant suffix ".com", in the form of an email address. [email protected].
upvoted 1 times
Nilakhi
2 weeks, 6 days ago
sorry, 2nd one should be partial()
upvoted 2 times
...
...
zxc01
1 month, 1 week ago
the question is not very clear for datatype. However, DOB column should be date data type, then default() can match requirement which will be showed be '1900-01-01'
upvoted 3 times
...
tarmapas
1 month, 1 week ago
first answer is default() for two reason: random is only for numbers and default for a date is 1900-01-01
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago