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 analytics endpoint.
What will you be able to do after connecting to Lakehouse1?
- A. Read Table3. Correct
- B. Update the data in Table3.
- C. Read Table2.
- D. Update the data in Table1.
Explanation
The SQL analytics endpoint gives read-only T-SQL access to the Delta tables in the lakehouse Tables area, so you can query the managed table Table3. It cannot insert, update or delete data, which rules out updating Table3 or Table1; data changes are made with Spark in the lakehouse. External tables created with Spark code are not visible to the SQL analytics endpoint, so Table2 cannot be read.
