Microsoft DP-700 Exam - 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

Aretha

4 months ago

A is just viewer access, not enough for analysts.

upvoted 0 times

...

Alexia

4 months ago

Wait, why not just go with D? That sounds powerful!

upvoted 0 times

...

Annmarie

4 months ago

I’m not so sure about C, seems too limited.

upvoted 0 times

...

Markus

4 months ago

I agree, B gives the right permissions!

upvoted 0 times

...

Ryan

4 months ago

Option B seems like the best choice for access.

upvoted 0 times

...

Lucy

5 months ago

I feel like option D might be overkill; I don't recall needing Apache Spark permissions just for accessing data.

upvoted 0 times

...

Jerilyn

5 months ago

Option C seems like it could be the right choice since it directly mentions SQL Endpoint data, which is crucial for data analysis.

upvoted 0 times

...

Wilson

5 months ago

I'm not entirely sure, but I remember something about the Viewer role in option A being too limited for data analysts.

upvoted 0 times

...

Herman

5 months ago

I think option B sounds familiar because it mentions sharing and granting specific permissions, which we practiced in a similar question.

upvoted 0 times

...

Veta

5 months ago

I'm confident that option D is the correct answer here. Sharing the lakehouse with the DataAnalysts group and granting them the "Read all Apache Spark" permission should give them the access they need to the gold layer.

upvoted 0 times

...

Ayesha

5 months ago

Okay, let me think this through. The question is asking how to ensure the data analysts can access the gold layer lakehouse, so I'm thinking option C might be the best choice - sharing the lakehouse and granting the "Read all SQL Endpoint data" permission.

upvoted 0 times

...

Fletcher

5 months ago

I'm a bit unsure about this one. Do I need to grant any additional permissions beyond just sharing the lakehouse with the DataAnalysts group? I'm not sure if option B is enough.

upvoted 0 times

...

Erasmo

5 months ago

Hmm, this seems straightforward. I think I'll go with option B - sharing the lakehouse with the DataAnalysts group and granting them the "Build reports on the default semantic model" permission.

upvoted 0 times

...

Justine

1 year 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

12 months ago

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

upvoted 0 times

...

Jess

12 months ago

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

upvoted 0 times

...

Kimberely

12 months 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 year ago

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

upvoted 0 times

...

Earlean

1 year 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

1 year 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

...