Certified Data Engineer Professional Exam

Exam Certified Data Engineer Professional All QuestionsBrowse all questions from this exam

Question 79

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?

When a database is being created, make sure that the LOCATION keyword is used.

When configuring an external data warehouse for all table storage, leverage Databricks for all ELT.

When data is saved to a table, make sure that a full file path is specified alongside the Delta format.

When tables are created, make sure that the EXTERNAL keyword is used in the CREATE TABLE statement.

When the workspace is being configured, make sure that external cloud object storage has been mounted.

Correct Answer: C

To ensure that tables in the Lakehouse are configured as external (unmanaged) Delta Lake tables, it is necessary to specify the full file path when saving data to a table. This step ensures that the data is stored in the location specified by the user, rather than the default directory managed by Delta Lake. By doing so, the table will be considered external since the data resides outside the managed storage, fulfilling the requirement set by the data architect.

Discussion

sturcuOption: A

Non of the provided. It should be: When a table is created, make sure LOCATION is provided

vctrhugoOption: C

In Delta Lake, an external (or unmanaged) table is a table created outside of the data lake but is still accessible from the data lake. The data for external tables is stored in a location specified by the user, not in the default directory of the data lake. When you save data to an external table, you need to specify the full file path where the data will be stored. This makes the table “external” because the data itself is not managed by Delta Lake, only the metadata is. This is why specifying a full file path alongside the Delta format when saving data to a table will ensure that the table is configured as an external Delta Lake table.

aragorn_bregoOption: C

Here's why the other options may not ensure the requirement is met: D. Delta Lake does not use the EXTERNAL keyword in the same way as some other SQL-based systems. In Delta Lake, whether a table is external is determined by where the data files are stored, not by a keyword in the CREATE TABLE statement. %sql CREATE TABLE f1_demo.results_external USING DELTA LOCATION '/mnt/formula1dl/demo/results_external'

jkhan2405Option: C

C is correct.

JamesWrightOption: C

C is correct

DileepvikramOption: C

possible answer is C

Laraujo2022Option: A

I think it should be A because when a database is created using a location all tables within this database are automatically assign as unmanaged tables.

60ties

Not quite. Test & see. The tables are 'managed' though database creation has 'LOCATION' keyword. C is best.

sturcuOption: C

provide path (LOCATION)

mouad_attaqiOption: C

C is plausible answer, as in this case we are writing the data to an external location