Exam DP-700 topic 1 question 22 discussion

Actual exam question from Microsoft's DP-700

Question #: 22
Topic #: 1

You have a Fabric capacity that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a data pipeline, a notebook, and several Microsoft Power BI reports.
A user named User1 wants to use SQL to analyze the data in Lakehouse1.
You need to configure access for User1. The solution must meet the following requirements:
Provide User1 with read access to the table data in Lakehouse1.
Prevent User1 from using Apache Spark to query the underlying files in Lakehouse1.
Prevent User1 from accessing other items in Workspace1.
What should you do?

A. Share Lakehouse1 with User1 directly and select Read all SQL endpoint data.
B. Assign User1 the Viewer role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.
C. Share Lakehouse1 with User1 directly and select Build reports on the default semantic model.
D. Assign User1 the Member role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.

Show Suggested Answer

Suggested Answer: A 🗳️

by IshtarSQL at Dec. 11, 2024, 10:21 p.m.

Comments

Submit Cancel

01ceacf

Highly Voted 4 months, 2 weeks ago

Selected Answer: A

Read Access to Table Data. B/D - Viewer/Member can access other items C - cannot access SQL DB

upvoted 6 times

...

IshtarSQL

Highly Voted 4 months, 2 weeks ago

Selected Answer: A

Assigning the Viewer role would grant User1 access to all items in the workspace, violating the requirement to restrict access to Lakehouse1 only.

upvoted 6 times

...

benni_ale

Most Recent 2 months ago

Selected Answer: A

Agree with other solutions

upvoted 3 times

...

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 22 discussion

Comments

01ceacf

IshtarSQL

benni_ale

SY0-701