nerdexam
Microsoft

DP-700 · Question #23

QUESTION 25 You have a Fabric workspace named Workspace1 that contains a warehouse named DW1 and a data pipeline named Pipeline1. You plan to add a user named User3 to Workspace1. You need to ensure…

The correct answer is D. Contributor. To allow a user to view all items in a Fabric workspace and update tables in a warehouse within that workspace, the Contributor role is the least privileged option.

Manage data governance and security

Question

QUESTION 25 You have a Fabric workspace named Workspace1 that contains a warehouse named DW1 and a data pipeline named Pipeline1. You plan to add a user named User3 to Workspace1. You need to ensure that User3 can perform the following actions:
  • View all the items in Workspace1.
  • Update the tables in DW1.
The solution must follow the principle of least privilege. Which workspace role should you assign to User3?

Options

  • AAdmin
  • BMember
  • CViewer
  • DContributor

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    14% (4)
  • D
    79% (22)

Why each option

To allow a user to view all items in a Fabric workspace and update tables in a warehouse within that workspace, the Contributor role is the least privileged option.

AAdmin

The Admin role provides full control over the workspace, including managing permissions, which is more privilege than required for simply viewing items and updating tables.

BMember

The Member role generally provides similar permissions to Contributor but can also share items, which is not explicitly required and slightly more privilege than just updating tables.

CViewer

The Viewer role only allows users to view content and data, but explicitly prevents them from making any changes, including updating tables in a warehouse.

DContributorCorrect

The Contributor role in a Fabric workspace allows a user to view all items, create new content, edit existing content, and delete content. This includes the ability to update tables within a warehouse item, satisfying the requirement while adhering to the principle of least privilege compared to an Admin.

Concept tested: Fabric Workspace roles and permissions

Source: https://learn.microsoft.com/en-us/fabric/get-started/roles-workspaces

Topics

#Fabric workspace roles#Least privilege#Access control#Data warehouse security

Community Discussion

No community discussion yet for this question.

Full DP-700 Practice