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?
Certified Data Engineer Professional Exam QuestionsBrowse all questions from this exam
Certified Data Engineer Professional Exam - Question 120
Show AnswerHide Answer
Correct Answer: BC
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
6 commentsIsio05Option: C
Jun 14, 2024It's managed table, so data will be also removed
hpkrOption: C
Jun 13, 2024C is correct
MDWPartnersOption: C
May 30, 2024Seems C, it's a managed table
FreyrOption: C
Jun 1, 2024Correct 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.
imatheushenriqueOption: C
Jun 5, 2024C because its a managed table
hpkrOption: C
Jun 12, 2024Option C