Learn what types of tables you can read from and write to when connecting to a lakehouse via the SQL endpoint in an Azure Synapse Analytics workspace. Understand the differences between Delta tables, external tables, and managed tables.
Table of Contents
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?
A. Read Table3.
B. Update the data Table3.
C. Read Table2.
D. Update the data in Table1.
Answer
A. Read Table3.
Explanation
When connecting to a lakehouse (Lakehouse1) using the SQL endpoint in an Azure Synapse Analytics workspace, you will be able to:
A. Read Table3 – Correct
Table3 is a managed table. Managed tables are fully accessible and queryable through the SQL endpoint. You can read data from managed tables.
B. Update the data in Table3 – Incorrect
While you can read data in managed tables through the SQL endpoint, you cannot write to or update data in managed tables. Managed tables are read-only when accessed via SQL endpoint.
C. Read Table2 – Incorrect
Table2 is an external table created using Spark. External Spark tables are not accessible through the SQL endpoint. You can only access them through Spark pools.
D. Update the data in Table1 – Incorrect
Table1 is a Delta table created using a shortcut. Delta tables are accessible through the SQL endpoint for read purposes only. You cannot write to or update data in Delta tables via the SQL endpoint.
In summary, when connecting to a lakehouse using the SQL endpoint, you can only read data from managed tables and Delta tables. You cannot write to or update any tables. External Spark tables are not accessible at all through the SQL endpoint.
Microsoft DP-600 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft DP-600 exam and earn Microsoft DP-600 certification.