
Ultimate access to all questions.
A data engineer attempted to drop a table named orders in Databricks by executing the query DROP TABLE orders. Subsequently, the query SHOW TABLES confirmed the table's absence from the listing. However, the data files associated with the table remained in DBFS. The engineer's goal was to delete both the metadata and the data for this table. What is the most plausible explanation for this outcome?
A
The table orders was a managed table
B
The table orders was not dropped properly
C
The table orders was an external table
D
The table orders was partially dropped
E
The table orders should be truncated first before dropping