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 query the data in QUIZHOUSE?

Choose the correct answer from the options below.

Explanations for each answer:

A KQL queryset is incorrect. KQL querysets are used for querying Kusto databases and logs in Azure. They cannot be used to query data in a Fabric lakehouse, even when Apache Spark permissions are granted.
OneLake File Explorer is correct.
Microsoft SQL Server Management Studio (SSMS) is incorrect. SSMS requires SQL endpoint access permissions, which are not granted in this scenario. The permissions show that 'Read all SQL endpoint data' is unchecked.
Azure Data Studio is incorrect. Azure Data Studio, like SSMS, requires SQL endpoint access permissions to query lakehouse data. Since 'Read all SQL endpoint data' is not granted, this tool cannot be used.
Azure Storage Explorer is incorrect. Azure Storage Explorer is designed for managing Azure Storage accounts and their contents. It cannot directly access Fabric lakehouse data through Apache Spark permissions, as the lakehouse uses a different authentication and access model.

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: