Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You manage a Microsoft Fabric warehouse that contains a table named Employees with a column called SocialSecurityNumber that stores U.S. SSNs. Business analysts already have SELECT permission on the table so they can create reports, but only members of the PayrollAdmin security group are allowed to see the real SSN values. All other users must receive obfuscated values when they query the column. You must meet the requirement without creating additional copies of the data. Which Microsoft Fabric security feature should you configure?

  • Create a row-level security policy that filters rows based on user membership in the PayrollAdmin group.

  • Use T-SQL to deny SELECT permission on the SocialSecurityNumber column for all users except the PayrollAdmin group.

  • Apply a highly confidential sensitivity label to the Employees table to conceal the SocialSecurityNumber values.

  • Configure dynamic data masking on the SocialSecurityNumber column and grant UNMASK permission only to the PayrollAdmin group.

Microsoft Fabric Data Engineer Associate DP-700
Implement and manage an analytics solution
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot