Databricks Certified Data Engineer Professional — Question 163

The data architect has mandated that all tables in the Lakehouse should be configured as external Delta Lake tables.

Which approach will ensure that this requirement is met?

Answer options

• A. Whenever a database is being created, make sure that the LOCATION keyword is used.
• B. When the workspace is being configured, make sure that external cloud object storage has been mounted.
• C. Whenever a table is being created, make sure that the LOCATION keyword is used.
• D. When tables are created, make sure that the UNMANAGED keyword is used in the CREATE TABLE statement.

Correct answer: C

Explanation

The correct answer, C, ensures that the LOCATION keyword is specified when creating a table, which is necessary for defining it as an external Delta Lake table. Option A refers to databases, not tables, while option B focuses on workspace setup rather than table creation. Option D is incorrect because using the UNMANAGED keyword does not ensure the table is external.