Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-700 Exam - Topic 2 Question 6 Discussion

You need to ensure that the data analysts can access the gold layer lakehouse.What should you do?
C) Share the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission.
A) Add the DataAnalyst group to the Viewer role for WorkspaceA.
B) Share the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.
D) Share the lakehouse with the DataAnalysts group and grant the Read all Apache Spark permission.

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Aretha
9 months ago
A is just viewer access, not enough for analysts.
upvoted 0 times
...
Alexia
9 months ago
Wait, why not just go with D? That sounds powerful!
upvoted 0 times
...
Annmarie
10 months ago
I’m not so sure about C, seems too limited.
upvoted 0 times
...
Markus
10 months ago
I agree, B gives the right permissions!
upvoted 0 times
...
Ryan
10 months ago
Option B seems like the best choice for access.
upvoted 0 times
...
Lucy
10 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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
2 years 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
1 year ago
D) Share the lakehouse with the DataAnalysts group and grant the Read all Apache Spark permission.
upvoted 0 times
...
Jess
1 year ago
C) Share the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission.
upvoted 0 times
...
Kimberely
1 year ago
B) Share the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.
upvoted 0 times
...
Dalene
2 years ago
A) Add the DataAnalyst group to the Viewer role for WorkspaceA.
upvoted 0 times
...
...
Earlean
2 years 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 years 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
...
Vernell
2 years ago
B) seems like the obvious choice here. The data analysts need to be able to build reports on the semantic model, not just view the data.
upvoted 0 times
Boris
2 years ago
B) Share the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.
upvoted 0 times
...
Verdell
2 years ago
A) Add the DataAnalyst group to the Viewer role for WorkspaceA.
upvoted 0 times
...
Willodean
2 years ago
B) Share the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.
upvoted 0 times
...
Margurite
2 years ago
A) Add the DataAnalyst group to the Viewer role for WorkspaceA.
upvoted 0 times
...
...
Shawana
2 years ago
I'm not sure, maybe option C could also work.
upvoted 0 times
...
Carman
2 years ago
I agree with Merri, granting Build reports permission makes sense.
upvoted 0 times
...
Merri
2 years ago
I think we should go with option B.
upvoted 0 times
...

Save Cancel