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 2 months, 3 weeks ago
default() Partial() are correct. verified. you can try it in azure sql too
upvoted 8 times
...
PJLB
Highly Voted 2 months, 3 weeks ago
BirthDate: default() <- each datatype has a default EmailAddress: partial()
upvoted 6 times
...
smanzana
Most Recent 2 weeks, 2 days ago
Default Partial
upvoted 1 times
...
DarioReymago
1 month ago
default and partial
upvoted 2 times
...
bettermakeme
1 month, 2 weeks ago
BirthDate: 'default()' EmailAddress: 'partial(1,"@",5)'
upvoted 2 times
...
Nilakhi
2 months, 1 week 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 months, 1 week ago
sorry, 2nd one should be partial()
upvoted 2 times
...
...
zxc01
2 months, 3 weeks 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
2 months, 3 weeks 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