Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You manage a Microsoft Fabric workspace that contains a Lakehouse with a SQL analytics endpoint. The Sales table includes a column named CostPrice that only Finance users should be able to read. Members of the SalesReaders security group must be able to run SELECT queries against the Sales table but must be prevented from viewing or discovering the CostPrice column. Which approach should you implement?

  • Define a row-level security filter on the Sales table to exclude the CostPrice column from query results

  • Grant SELECT on the Sales table to SalesReaders and then explicitly DENY SELECT on the CostPrice column for the same group

  • Apply a Confidential sensitivity label to the CostPrice column and enable automatic encryption

  • Create a dynamic data masking rule that fully masks the CostPrice column for SalesReaders

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