Which approach will ensure that this requirement is met?

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?
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.

View Answer

Answer: C

Explanation:

This is the correct answer because it ensures that this requirement is met. The requirement is that all tables in the Lakehouse should be configured as external Delta Lake tables. An external table is a table that is stored outside of the default warehouse directory and whose metadata is not managed by Databricks. An external table can be created by using the location keyword to specify the path to an existing directory in a cloud storage system, such as DBFS or S3. By creating external tables, the data engineering team can avoid losing data if they drop or overwrite the table, as well as leverage existing data without moving or copying it.

Verified Reference: [Databricks Certified Data Engineer Professional], under “Delta Lake” section; Databricks Documentation, under “Create an external table” section.