Exam DP-700 Topic 2 Question 16 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 16
Topic #: 2
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?

Suggested Answer: D Vote an answer

To ensure User3 can view all items in Workspace1 and update the tables in DW1, the most appropriate workspace role to assign is the Contributor role. This role allows User3 to:
View all items in Workspace1: The Contributor role provides the ability to view all objects within the workspace, such as data pipelines, warehouses, and other resources.
Update the tables in DW1: The Contributor role allows User3 to modify or update resources within the workspace, including the tables in DW1, assuming that appropriate object-level permissions are set for the warehouse.
This role adheres to the principle of least privilege, as it provides the necessary permissions without granting broader administrative rights.

by Clifford at May 10, 2025, 07:50 PM

Limited Time Offer

15%

Off

Get Premium DP-700 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
Pavan
2026-07-05 05:46:43
D. Contributor
upvoted 1 times
...
jemmaliaymen1994
2026-04-13 05:20:58
✅ C. Viewer
Why this works:

Viewer lets User3 see all workspace items
Table updates are allowed because of DW1 object-level permissions
Workspace-level edit rights are not required and would violate least privilege
upvoted 1 times
...
kejig21518
2026-01-30 18:31:23
C
upvoted 1 times
...
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10