Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You manage a Microsoft Fabric Warehouse named SalesDW that has a Customer table with an EmailAddress column. Support analysts querying the SQL endpoint must see masked email addresses, but members of the Azure AD group DW_MarketingManagers must view real values. You will map the group to a database role named MarketingManagers. Which actions should you perform to satisfy these requirements?

  • Create a row-level security predicate that returns NULL for EmailAddress when the current user is not in the MarketingManagers role; do not configure any masking.

  • Apply a Confidential sensitivity label to Customer.EmailAddress and configure the MarketingManagers role to override label-based encryption for that column.

  • Enable Transparent Data Encryption (TDE) on SalesDW and add the MarketingManagers role to the db_datareader fixed database role.

  • Add a dynamic data mask to Customer.EmailAddress using MASKED WITH (FUNCTION = 'email()'); then grant the UNMASK permission on the database to the MarketingManagers role.

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