
Ultimate access to all questions.
A data analyst is attempting to drop a table named my_table to delete both its metadata and data. They execute the following command:
DROP TABLE IF EXISTS my_table;
DROP TABLE IF EXISTS my_table;
After this command, the table no longer appears in the output of SHOW TABLES. However, the underlying data files still exist, while the metadata files have been deleted.
Why do the data files persist after the metadata files have been removed?
A
The table's data was larger than 10 GB
B
The table did not have a location
C
The table was external
D
The table's data was smaller than 10 GB
E
The table was managed