BenchMark Quizzes by MDFT Pro

Select How A User Can Access Lakehouse Data

You work for MDFT Pro, a well-known training organization. You have a Fabric tenant that contains a workspace named WS1 and a user named Mark. Mark does not have access to the tenant.

WS1 contains a lakehouse named QUIZHOUSE, with the following permission settings:

Grant people access to: QUIZHOUSE
Shared with: Mark

Additional permissions:
[ ] Read all SQL endpoint data
[X] Read all Apache Spark
[ ] Build reports on the default semantic model

Based on these settings, what should Mark use to access the data in QUIZHOUSE?

Choose the correct answer from the options below.

Explanations for each answer:

The default semantic model is incorrect. The permissions shown explicitly do not grant permission to build reports on the default semantic model. This access method would not work for Mark.
The OneLake endpoint is correct.
The Tabular Data Stream (TDS) endpoint is incorrect. The TDS endpoint requires the 'Read all SQL endpoint data' permission, which is not granted to Mark.
DirectLake mode in Power BI is incorrect. DirectLake mode requires both Apache Spark and SQL endpoint permissions. While Mark has Apache Spark permissions, they lack the required SQL endpoint access.

Learn more about Fabric Lakehouse sharing:

Fabric Lakehouse Sharing

Practice Exam

Select How A User Can Access Lakehouse Data

Discuss this question on social media: