Answer-first summary for fast verification
Answer: Removes the table from the metastore, along with its metadata, history, and the data in storage.
For a managed table, the `DROP TABLE` command removes everything associated with the table from both the metastore and storage. This includes the table's metadata, history, and the actual data stored. Understanding the distinction between managed and external tables is crucial for data management in Databricks.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What happens to metadata, history, and the data stored in a managed table when you use the SQL syntax 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.
No comments yet.