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 64
Show AnswerHide Answer
Correct Answer: CD
In Delta Lake, when a DROP TABLE command is executed on a managed table, it will remove both the metadata entry for the table from the catalog and the data in storage associated with that table. This means that both the table definition and the data itself are deleted. Therefore, the correct answer is that the table will be removed from the catalog and the data will be deleted.
Discussion
13 commentsaragorn_bregoOption: C
Nov 21, 2023In Delta Lake, when a DROP TABLE command is executed, it removes both the metadata entry for the table from the catalog and the data in storage associated with that table. Workspace administrators typically have the necessary permissions to drop tables, and unless there are additional protections or retention policies in place, the data is not recoverable through normal operations after the table is dropped.
hal2401meOption: C
Mar 7, 2024According to the exam courses answer is C, for a managed table dropped. But, as after Nov'23, UNDROP is introduced and I have test it working with UC managed tables. https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html However, I don't see any official doc says UNDROP related to 'time travel'. So, be aware of the above info; in exam, watch the question carefully if it is updated.
60tiesOption: C
Nov 14, 2023I meant C is correct, not D
alexvnoOption: C
Dec 18, 2023C : AS SELECT - Managed table Will remove table and data
Er5Option: C
Apr 8, 2024C. is only correct statement. Though the table can be UNDROP in 7 days https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-syntax-ddl-undrop-table E. Time Travel can retrieve versioned records but not tables. https://www.databricks.com/blog/2019/02/04/introducing-delta-time-travel-for-large-scale-data-lakes.html
jyothsna12496Option: C
Oct 20, 2023Drop will usually delete the table structure and data if its managed, hence c
sturcuOption: C
Oct 24, 2023it is a managed table. So both table def and data will be deleted
lokvamsiOption: A
Oct 31, 2023its a as it is managed table
lokvamsiOption: C
Oct 31, 2023it is a managed table
DileepvikramOption: C
Nov 9, 2023Answer is C as it is a managed table
60tiesOption: D
Nov 14, 2023D is most correct
Luv4dataOption: E
Dec 27, 2023E. Since the table is still recoverable from transaction logs.
Curious76Option: E
Feb 26, 2024I think E is better answer