DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ44

VerifiedImplement and manage an analytics solution

You have a Fabric workspace named Workspace1 that includes a warehouse named DW1 and a data pipeline named Pipeline1.

You plan to add a user named User3 to Workspace1. You must ensure that User3 can perform these actions:

  • View every item in Workspace1.
  • Update the tables in DW1.

The solution must follow the principle of least privilege. You have already assigned the appropriate object-level permissions to DW1.

Which workspace role should you assign to User3?

Explanation

The Viewer role lets a user view workspace content and connect to the Warehouse, while granting only CONNECT and ReadData by default. Fabric supports granular object-level SQL permissions through GRANT, REVOKE, and DENY; therefore, the preassigned table-update permissions can provide the required write access without granting broad Contributor, Member, or Admin privileges.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!