Databricks Certified Data Engineer Professional — Question 34

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 configuring an external data warehouse for all table storage, leverage Databricks for all ELT.
• C. Whenever a table is being created, make sure that the LOCATION keyword is used.
• 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

The correct answer is C because specifying the LOCATION keyword during table creation is essential for setting up external Delta Lake tables. Options A and D are incorrect as they refer to the database and table creation processes respectively but do not directly fulfill the requirement for tables. Option B talks about ELT processes, which is not relevant to table configuration, and option E addresses workspace setup rather than table creation.