Answer-first summary for fast verification
Answer: Drops table from metastore, but keeps metadata (delta log, history) and data in storage
When you drop an external DELTA table using the SQL command `DROP TABLE table_name`, the table's definition is removed from the metastore, meaning it's no longer registered in the system. However, since it's an external table, the actual data files and Delta Lake metadata (delta log, history) remain in the external storage (like S3, ADLS, or GCS). The `DROP TABLE` command does not delete these files, so both the data and its associated delta logs stay in the storage location.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What happens to the metadata (delta log, history) and the data stored in the storage when you drop an external DELTA table using the SQL command DROP TABLE table_name?
A
Drops table from metastore, metadata (delta log, history), and data in storage
B
Drops table from metastore, data but keeps metadata (delta log, history) in storage
C
Drops table from metastore, metadata (delta log, history) but keeps the data in storage
D
Drops table from metastore, but keeps metadata (delta log, history) and data in storage
E
Drops table from metastore and data in storage but keeps metadata (delta log, history)
No comments yet.