Implementing Analytics Solutions Using Microsoft Fabric — Question 2
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?
Answer options
- A. Read Table3.
- B. Update the data Table3.
- C. Read Table2.
- D. Update the data in Table1.
Correct answer: A
Explanation
After connecting to Lakehouse1 via its SQL endpoint, you can read from managed tables like Table3, which is accessible through SQL queries. However, you cannot update Table3 or Table1 using this endpoint, and although you can read Table2, the question specifically asks for what can be done, making A the correct choice.