Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You manage a Microsoft Fabric Warehouse named SalesDW in a workspace. The Orders table contains a SensitiveAmount column that must be completely hidden from all analysts except members of the Azure AD group FinanceLeads. Analysts still need to query every other column in the table. Which approach meets this requirement with minimal ongoing administration?

  • Create a row-level security policy that filters SensitiveAmount for non-FinanceLeads users.

  • Hide SensitiveAmount with object-level security in a semantic model and have analysts query through that model only.

  • Apply dynamic data masking to SensitiveAmount and grant SELECT on Orders to all analysts.

  • Create a database role for regular analysts, DENY SELECT on SensitiveAmount to that role, and GRANT SELECT on Orders to FinanceLeads.

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