CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #34: Real Exam Question with Answer & Explanation

Question

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?

Options

• AWhenever a database is being created, make sure that the location keyword is used
• BWhen configuring an external data warehouse for all table storage. leverage Databricks for all
• CWhenever a table is being created, make sure that the location keyword is used.
• DWhen tables are created, make sure that the external keyword is used in the create table
• EWhen the workspace is being configured, make sure that external cloud object storage has been

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.

No community discussion yet for this question.