Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
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)
