Certified Data Engineer Professional Exam

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

Go to Exam

Question 120

A Delta Lake table was created with the below query:

Consider the following query:

DROP TABLE prod.sales_by_store -

If this statement is executed by a workspace admin, which result will occur?

Data will be marked as deleted but still recoverable with Time Travel.

The table will be removed from the catalog but the data will remain in storage.

The table will be removed from the catalog and the data will be deleted.

An error will occur because Delta Lake prevents the deletion of production data.

Correct Answer: C

When the DROP TABLE statement is executed on a managed table in Delta Lake, both the table metadata and the physical data itself are deleted. The given query does not specify a location for the table, which implies it's a managed table. Therefore, dropping the table will result in the removal of both the table from the catalog and the data stored.

Discussion

Isio05Option: C

It's managed table, so data will be also removed

hpkrOption: C

C is correct

hpkrOption: C

Option C

imatheushenriqueOption: C

C because its a managed table

FreyrOption: C

Correct Answer: C No location provided in the table. So, it is a managed table. This will result in deleting the table meta data as well as table data.

MDWPartnersOption: C

Seems C, it's a managed table