Implementing Data Engineering Solutions Using Microsoft Fabric — Question 13

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.
You already assigned the appropriate object-level permissions to DW1.
Which workspace role should you assign to User3?

Answer options

Correct answer: D

Explanation

The correct answer is D, Contributor, because this role allows User3 to view all items in Workspace1 and update the tables in DW1, which meets the requirements while adhering to the principle of least privilege. The Admin role (A) would provide excessive permissions, the Member role (B) may not allow the necessary updates, and the Viewer role (C) only allows viewing, which does not meet the update requirement.