Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

Your organization uses a Microsoft Fabric data warehouse named ContosoDW. Members of the EuropeanFinance security group must query data in the dbo.Sales table, but:

  • They should see only rows where Region = 'EU'.
  • They must not be able to read the UnitCost column, while all other columns remain visible.

You need to configure ContosoDW to meet both requirements by using built-in capabilities of Fabric.

Which approach should you implement?

  • Create a table-valued function that filters on Region = 'EU', add it to a row-level security (RLS) security policy for dbo.Sales, and grant SELECT on the allowed columns only, leaving UnitCost ungranted.

  • Create a view that selects all columns except UnitCost, and give EuropeanFinance SELECT permissions only on the view; do not configure any RLS because workspace roles will enforce the row filter automatically.

  • Move the UnitCost column to a separate table protected by workspace item permissions, and use pipeline parameters to pass the required Region value at query time.

  • Apply dynamic data masking to the UnitCost column and assign the EuropeanFinance group the Viewer role at the workspace level.

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