
Ultimate access to all questions.
A data engineer attempts to delete a Spark SQL table named my_table, intending to remove both its metadata and data. They use the command: DROP TABLE IF EXISTS my_table;. After execution, my_table disappears from the table list, but the data files remain. Why do the data files persist despite the metadata deletion?