DP-600 · Question #11
You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables: Table1: A Delta table created by using a shortcut Table2: An exter
The correct answer is A. Read Table3.. When connecting to a Fabric Lakehouse SQL endpoint, users are able to read managed tables within the lakehouse.
Question
You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables:
Table1: A Delta table created by using a shortcut Table2: An external table created by using Spark Table3: A managed table You plan to connect to Lakehouse1 by using its SQL endpoint. What will you be able to do after connecting to Lakehouse1?
Options
- ARead Table3.
- BUpdate the data Table3.
- CRead Table2.
- DUpdate the data in Table1.
How the community answered
(29 responses)- A90% (26)
- B3% (1)
- C7% (2)
Why each option
When connecting to a Fabric Lakehouse SQL endpoint, users are able to read managed tables within the lakehouse.
The SQL endpoint for a Fabric Lakehouse provides read-only access to managed tables, which are Delta tables created directly within the Lakehouse, allowing users to query data in Table3.
The SQL endpoint provides read-only access to Lakehouse tables and does not support DML operations like updating data in managed tables directly through this interface.
Concept tested: Fabric Lakehouse SQL endpoint capabilities
Source: https://learn.microsoft.com/en-us/fabric/data-warehouse/lakehouse-sql-endpoint
Topics
Community Discussion
No community discussion yet for this question.