Q: 13
HOTSPOT You have a Fabric workspace that contains a warehouse named Warehouse!. Warehousel contains a table named DimCustomers. DimCustomers contains the following columns: • CustomerName • CustomerlD • BirthDate • Email You need to configure security to meet the following requirements: • BirthDate in DimCustomer must be masked and display 1900-01-01. • Email 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. 
Your Answer
Discussion
'default()' for BirthDate works since that's how Microsoft masks dates to 1900-01-01. For Email, 'partial(1, "@", 5)' lets you show the first character and last five as asked. Pretty sure that's what the question wants, but open if I missed a trick.
Honestly, Microsoft really doesn't make this straightforward. default() for BirthDate since it outputs 1900-01-01 as needed, partial(1, "@", 5) for Email.
default() for BirthDate and partial(1, "@", 5) for Email. Saw something similar in the official practice set and doc examples.
Be respectful. No spam.