Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Databricks Certified Data Engineer Associate Exam - Topic 2 Question 57 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Associate exam
Question #: 57
Topic #: 2
[All Databricks Certified Data Engineer Associate Questions]

A data engineer is attempting to drop a Spark SQL table my_table. The data engineer 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?

Show Suggested Answer Hide Answer
Suggested Answer: C

An external table is a table that is defined in the metastore and points to an existing location in the storage system. When you drop an external table, only the metadata is deleted from the metastore, but the data files are not deleted from the storage system. This is because external tables are meant to be shared by multiple applications and users, and dropping them should not affect the data availability. On the other hand, a managed table is a table that is defined in the metastore and also managed by the metastore. When you drop a managed table, both the metadata and the data files are deleted from the metastore and the storage system, respectively. This is because managed tables are meant to be exclusive to the application or user that created them, and dropping them should free up the storage space. Therefore, the correct answer is C, because the table was external and only the metadata was deleted when the table was dropped.Reference:Databricks Documentation - Managed and External Tables,Databricks Documentation - Drop Table


by Hester at Nov 21, 2025, 10:24 AM

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Engineer Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Jolanda
2 months ago
Yeah, size doesn't affect whether files are deleted or not. C is the best choice!
upvoted 0 times
...
Carlton
2 months ago
I feel like B) The table's data was smaller than 10 GB doesn't matter here.
upvoted 0 times
...
Rebbeca
2 months ago
But if it was managed, why are files still there? C seems right.
upvoted 0 times
...
Lonna
2 months ago
I lean towards E) The table was managed. Managed tables should delete data.
upvoted 0 times
...
Basilia
2 months ago
Agreed! External tables keep data files intact.
upvoted 0 times
...
Mohammad
3 months ago
I think it's C) The table was external. That makes sense.
upvoted 0 times
...
Kyoko
3 months ago
Wait, so if it was managed, the data should be gone too?
upvoted 0 times
...
Mireya
3 months ago
Definitely C, external tables keep the data.
upvoted 0 times
...
Francene
4 months ago
I thought managed tables would delete everything, right?
upvoted 0 times
...
Kris
4 months ago
Haha, looks like the data engineer forgot to specify the location for the table. Classic mistake!
upvoted 0 times
...
Lashaun
4 months ago
D) The table did not have a location
upvoted 0 times
...
Earnestine
4 months ago
Ah, I see! The data files still exist because the table was external, meaning the data was stored outside of the Spark SQL managed tables.
upvoted 0 times
...
Billye
4 months ago
C) The table was external
upvoted 0 times
...
Beckie
4 months ago
I vaguely recall something about the size of the data affecting the drop command, but I can’t remember the specifics. It might not be related to the size at all.
upvoted 0 times
...
Myra
5 months ago
I practiced a similar question where the data files remained because the table was external. I think that’s definitely the case here, so I’ll go with C.
upvoted 0 times
...
Cathrine
5 months ago
I’m not entirely sure, but I feel like if the table was managed, the data should have been deleted too. Maybe it’s option E?
upvoted 0 times
...
Page
5 months ago
I'm leaning towards option C as well. The fact that the data files still exist after dropping the table implies it was an external table, not a managed table.
upvoted 0 times
...
Chana
5 months ago
I remember something about external tables keeping their data even after dropping them, so I think option C might be right.
upvoted 0 times
...
Lizbeth
5 months ago
The table was external, that's why the data files are still there.
upvoted 0 times
...
Carey
5 months ago
Okay, let me think this through. The key piece of information is that the data files still exist, even though the table no longer appears in SHOW TABLES. That suggests the table was external, so I'm going with option C.
upvoted 0 times
...
Denny
6 months ago
Yeah, I agree with C. External tables are tricky like that!
upvoted 0 times
...
Adelle
6 months ago
Hmm, my initial thought was that the table was smaller than 10 GB, so option B might be correct. But the question doesn't mention anything about the table size, so I'm not sure that's the right answer.
upvoted 0 times
...
Yuette
6 months ago
I'm a bit confused on this one. If the table was managed, wouldn't the data files have been deleted? I'm not sure why the metadata would be deleted but the data files would remain.
upvoted 0 times
...
Angelyn
6 months ago
I think the answer is C - the table was external. The question says the data files still exist, which suggests the table was not managed by Spark.
upvoted 0 times
Emmett
26 days ago
C is definitely the right choice here. Good catch!
upvoted 0 times
...
Cherrie
1 month ago
Exactly! External tables are meant to keep data intact.
upvoted 0 times
...
Melodie
1 month ago
I thought about E, but managed tables should remove everything.
upvoted 0 times
...
Kasandra
1 month ago
Yeah, if it was managed, the files would be deleted too.
upvoted 0 times
...
Ahmed
2 months ago
I agree, C makes sense. External tables keep data outside Spark.
upvoted 0 times
...
...

Save Cancel