Exam Certified Data Engineer Professional topic 1 question 79 discussion

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

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.

Folks note: While creating a table - Use of External keyword - Non Mandatory. Mentioning Location and providing a path - Mandatory. In option C, it is not mentioned explicitly that Location keyword is used. But since the path is provided.. implies the use of Location keyword indirectly. The devil is in the details. :)

'create external table' statement is using in HIVE, so C is correct.

C is correct.

C is correct

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'

possible answer is C

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.

provide path (LOCATION)

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