Microsoft Exam DP-700 Topic 2 Question 6 Discussion

Actual exam question for Microsoft's DP-700 exam

Question #: 6
Topic #: 2

[All DP-700 Questions]

You need to ensure that the data analysts can access the gold layer lakehouse.

What should you do?

AAdd the DataAnalyst group to the Viewer role for WorkspaceA.

BShare the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.

CShare the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission.

DShare the lakehouse with the DataAnalysts group and grant the Read all Apache Spark permission.

Show Suggested Answer

Suggested Answer: C

Data Analysts' Access Requirements must only have read access to the Delta tables in the gold layer and not have access to the bronze and silver layers.

The gold layer data is typically queried via SQL Endpoints. Granting the Read all SQL Endpoint data permission allows data analysts to query the data using familiar SQL-based tools while restricting access to the underlying files.

by Noble at Jan 13, 2025, 02:12 PM

Limited Time Offer

25%

Off

Get Premium DP-700 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Justine

2 months ago

I wonder if the data analysts have a secret handshake or secret decoder ring that they use to access the lakehouse. Gotta keep that data secure, you know!

upvoted 0 times

Burma

20 days ago

D) Share the lakehouse with the DataAnalysts group and grant the Read all Apache Spark permission.

upvoted 0 times

...

Jess

22 days ago

C) Share the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission.

upvoted 0 times

...

Kimberely

24 days ago

B) Share the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.

upvoted 0 times

...

Dalene

1 months ago

A) Add the DataAnalyst group to the Viewer role for WorkspaceA.

upvoted 0 times

...

Earlean

2 months ago

C) is an interesting option, but I think B) is the best choice. The data analysts need to be able to build reports, not just read the raw data.

upvoted 0 times

...

Leonora

2 months ago

You know, I bet the data analysts are just itching to get their hands on that gold layer lakehouse. I hope they don't accidentally delete it all while they're 'building reports'.

upvoted 0 times

...