Answer-first summary for fast verification
Answer: Both the table's metadata and the associated data files will be permanently deleted.
When you execute `DROP TABLE` in Delta Lake, it performs a complete deletion of both the table's metadata (schema, partitions, etc.) from the Delta Lake transaction log and the underlying data files from the storage location. This behavior ensures that all traces of the table are removed from the Delta Lake ecosystem. It's important to note that Delta Lake tables are independent entities, and dropping a table does not depend on whether it was created as a clone of another table. Always proceed with caution when dropping tables in production environments to avoid unintended data loss.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineering team has created a Delta Lake table named customers_clone using the query CREATE TABLE customers_clone AS SELECT * FROM customers. If a data engineer attempts to drop this table with the command DROP TABLE customers_clone, what will be the outcome?
A
An error will occur because the table is a deep clone of the customers table.
B
Only the table's metadata will be removed from the catalog, leaving the data files intact in storage.
C
Both the table's metadata and the associated data files will be permanently deleted.
D
The table will remain until a VACUUM command is executed.
E
An error will occur because the table is a shallow clone of the customers table.
No comments yet.