Databricks Certified Data Engineer Professional — Question 52

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 configuring an external data warehouse for all table storage, leverage Databricks for all ELT.
• C. When data is saved to a table, make sure that a full file path is specified alongside the Delta format.
• D. When tables are created, make sure that the EXTERNAL keyword is used in the CREATE TABLE statement.
• E. When the workspace is being configured, make sure that external cloud object storage has been mounted.

Correct answer: C

Explanation

Option C is correct because specifying a full file path when saving data ensures that the Delta Lake tables are created as external. Option A does not ensure external configuration, option B focuses on ELT rather than table creation, option D requires the EXTERNAL keyword but doesn't address the file path, and option E pertains to workspace setup rather than table creation.