
Ultimate access to all questions.
In the context of managing a Spark SQL table named my_table, a data engineer wants to completely remove the table along with all its associated metadata and data. They use the command DROP TABLE IF EXISTS my_table. Although the table is no longer listed when they execute SHOW TABLES, they notice that the data files still persist. What is the reason that the data files remain in place while the metadata files were deleted?
A
The table’s data was larger than 10 GB
B
The table’s data was smaller than 10 GB
C
The table was external
D
The table did not have a location
E
The table was managed