Answer-first summary for fast verification
Answer: Read Table3.
The SQL endpoint in a Fabric lakehouse operates in a read-only mode. Therefore, updating data in tables (Options B and D) is not possible through the SQL endpoint. Additionally, external tables created using Spark (Table2) are not accessible via the SQL endpoint, making Option C incorrect. Therefore, the correct answer is A, as you can read data from a managed table (Table3) using the SQL endpoint.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As the administrator of a Fabric workspace containing a specific lakehouse named Lakehouse1, you should know the structure and types of tables within it. Lakehouse1 consists of the following tables:
Your goal is to connect to Lakehouse1 using its SQL endpoint. After establishing this connection, what capabilities will you have in terms of interactions with the data in Lakehouse1?
A
Read Table3.
B
Update the data in Table3.
C
Read Table2.
D
Update the data in Table1.
No comments yet.