Databricks Certified Data Engineer Professional — Question 195

The data architect has mandated that all tables in the Lakehouse should be configured as external (also known as "unmanaged") Delta Lake tables.

Which approach will ensure that this requirement is met?

Answer options

• A. When 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. When data is saved to a table, make sure that a full file path is specified alongside the USING DELTA clause.
• 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 is C because specifying a full file path with the USING DELTA clause when saving data ensures the table is treated as an external Delta Lake table. Option A is incorrect because the LOCATION keyword alone does not guarantee external configuration without additional context. Option B does not directly define the table type, and option D is incorrect as there is no UNMANAGED keyword in the standard CREATE TABLE syntax for Delta Lake.