Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You administer a Microsoft Fabric workspace that contains a lakehouse with several Delta tables used by multiple analytics teams. You must ensure that data analysts can query the SalesOrders table but must never see rows where the column TerritoryID equals 60. Business analysts should have unrestricted access. You need to configure this requirement in the most granular and performant way without duplicating data or creating additional views. Which approach should you implement in the lakehouse?

  • Publish a Power BI semantic model on top of SalesOrders and use that model's row-level security instead of configuring security in the lakehouse.

  • Create a row-level security policy on the SalesOrders Delta table that filters out rows with TerritoryID = 60 for the data-analysts security group.

  • Move SalesOrders to a separate folder secured with OneLake folder permissions that exclude the data-analysts group.

  • Grant the data-analysts group the Viewer role on the lakehouse and deny them access to the TerritoryID column by defining column-level security.

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