Answer-first summary for fast verification
Answer: The table is external
External (unmanaged) tables store data in an external storage path specified by a `LOCATION` clause. Dropping such a table only removes its metadata, not the underlying data files. Reference: [Databricks Documentation on Unmanaged Tables](https://docs.databricks.com/lakehouse/data-objects.html#what-is-an-unmanaged-table)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Why does dropping a Delta table only delete the table's metadata, leaving the data files intact in storage?
A
The table is deep cloned
B
Delta prevents deleting files less than retention threshold, ensuring no long-running operations reference files to be deleted
C
The user running the command lacks permission to delete the data files
D
The table is external
E
The table is managed
No comments yet.