Answer-first summary for fast verification
Answer: To configure the Delta Lake tables as external tables.
The LOCATION keyword is used to configure Delta Lake tables as external (unmanaged) tables, where the data is stored in an external storage path. This is distinct from managed tables where the data is stored within the Databricks workspace. Reference: [Databricks Documentation on Unmanaged Tables](https://docs.databricks.com/lakehouse/data-objects.html#what-is-an-unmanaged-table).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When the data engineering team uses the LOCATION keyword for every new Delta Lake table in the Lakehouse, what is its primary purpose?
A
To configure the Delta Lake tables as managed tables.
B
To define the Delta Lake tables in a database over a JDBC connection.
C
To set a default schema and checkpoint location for the Delta Lake tables.
D
To configure the Delta Lake tables as external tables.
E
To define the Delta Lake tables in an external database.
No comments yet.