Microsoft Fabric Data Engineer Associate DP-700 Practice Question

A Microsoft Fabric workspace contains several items, including a Lakehouse named FinanceLH that stores confidential payroll data. Only a group of external auditors must be able to run ad-hoc SQL queries against FinanceLH, and they must not see or modify any other items in the workspace. You need to grant the auditors the minimum access required to meet the requirement.

Which action should you take?

  • Assign the auditors the Viewer role for the workspace that contains FinanceLH.

  • Publish FinanceLH to a separate workspace by using a deployment pipeline and assign the auditors the Member role in that workspace.

  • Open Manage permissions for FinanceLH and grant the auditors Read permission on the Lakehouse.

  • Add the auditors to the Contributor role for the workspace and enable the Use SQL endpoint option on FinanceLH.

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.

Bash, the Crucial Exams Chat Bot
AI Bot