Microsoft
DP-700 · Question #86
You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains a table named DimCustomers. DimCustomers contains the following columns: - CustomerName - CustomerID…
ALTER TABLE DimCustomer ALTER COLUMN BirthDate ADD MASKED WITH (FUNCTION = 'random(1900-01-01, 1900-01-01)'); ALTER TABLE DimCustomer ALTER COLUMN EmailAddress ADD MASKED WITH (FUNCTION = 'partial(1,"0@.",5)');
Manage data governance and security
Question
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.
Exhibit
Explanation
ALTER TABLE DimCustomer ALTER COLUMN BirthDate ADD MASKED WITH (FUNCTION = 'random(1900-01-01, 1900-01-01)'); ALTER TABLE DimCustomer ALTER COLUMN EmailAddress ADD MASKED WITH (FUNCTION = 'partial(1,"0@.",5)');
Topics
#Microsoft Fabric#Dynamic Data Masking#Data Warehouse Security#SQL Security
Community Discussion
No community discussion yet for this question.