Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What happens to metadata, history, and the data stored in a managed table when you use the SQL syntax DROP TABLE table_name?
DROP TABLE table_name
A
Removes the table from the metastore, along with its metadata, history, and the data in storage.
B
Keeps the metadata and history in storage but removes the table from the metastore and the data from storage.
C
Retains the data in storage but removes the table from the metastore, along with its metadata and history.
D
Preserves the metadata, history, and data in storage but removes the table from the metastore.
E
Removes the table and its history from the metastore but keeps the metadata and data in storage.
