After connecting to Lakehouse1 via its SQL endpoint, what will you be able to read?

Prepare for the DP-600 Fabric Analytics Engineer Exam. Study with flashcards and multiple choice questions, each offering hints and detailed explanations. Enhance your chances of success on the exam!

Multiple Choice

After connecting to Lakehouse1 via its SQL endpoint, what will you be able to read?

Explanation:
A SQL endpoint exposes the data accessible to the credentials you use, treating the catalog as a read surface for all objects you’re allowed to query. Once you’re connected to Lakehouse1 through that endpoint, you’re not limited to just one table—any table in the catalog that your permissions cover can be read with queries. So you can read Table1, Table2, and Table3, effectively all tables the endpoint is authorized to access. If permissions were more restrictive, you’d see only a subset, but in this scenario the endpoint gives access to all tables.

A SQL endpoint exposes the data accessible to the credentials you use, treating the catalog as a read surface for all objects you’re allowed to query. Once you’re connected to Lakehouse1 through that endpoint, you’re not limited to just one table—any table in the catalog that your permissions cover can be read with queries. So you can read Table1, Table2, and Table3, effectively all tables the endpoint is authorized to access. If permissions were more restrictive, you’d see only a subset, but in this scenario the endpoint gives access to all tables.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy