Databricks Certified Data Analyst Associate Exam - Topic 3 Question 48 Discussion

Actual exam question for Databricks's Databricks Certified Data Analyst Associate exam

Question #: 48
Topic #: 3

[All Databricks Certified Data Analyst Associate Questions]

A data analyst is attempting to drop a table my_table. The analyst wants to delete all table metadata and data.

They run the following command:

DROP TABLE IF EXISTS my_table;

While the object no longer appears when they run SHOW TABLES, the data files still exist.

Which of the following describes why the data files still exist and the metadata files were deleted?

AThe table's data was larger than 10 GB

BThe table did not have a location

CThe table was external

DThe table's data was smaller than 10 GB

EThe table was managed
An external table is a table that is defined in the metastore, but its data is stored outside of the Databricks environment, such as in S3, ADLS, or GCS. When an external table is dropped, only the metadata is deleted from the metastore, but the data files are not affected. This is different from a managed table, which is a table whose data is stored in the Databricks environment, and whose data files are deleted when the table is dropped. To delete the data files of an external table, the analyst needs to specify the PURGE option in the DROP TABLE command, or manually delete the files from the storage system.Reference:DROP TABLE,Drop Delta table features,Best practices for dropping a managed Delta Lake table

Show Suggested Answer

Suggested Answer: C

by Christa at Mar 02, 2026, 09:58 PM

Limited Time Offer

25%

2 months ago

I remember that external tables keep their data outside the database, so that might explain why the files are still there after dropping the table.

upvoted 0 times

...