Databricks-DE-Assoc Governance and Security Practice Question
A data engineer stores a Delta table in Unity Catalog at the managed location of the schema 'sales'. The table is later dropped using DROP TABLE. What happens to the underlying data files?
⚠ Common exam trap
The trap here is assuming that dropping a managed table behaves like dropping an external table, where data files persist in the external location.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The data files are deleted from the managed storage location.
In Unity Catalog, managed tables have their data lifecycle controlled by the metastore. When you drop a managed table, the system deletes the data files from the managed storage location. This contrasts with external tables, where the data remains in the external location. Understanding this behavior is critical for data retention and cost management, as dropping a managed table permanently removes the data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The data files remain in the managed storage location and can be re-registered later.
Why it's wrong here
For Unity Catalog managed tables, dropping the table also removes the underlying data files from the managed storage location. The files are not retained for later re-registration. This option confuses managed tables with external tables, where data persists after dropping the table. Re-registering would require the files to still exist, which is not the case here.
- ✗
The data files are deleted after the default retention period of 30 days.
Why it's wrong here
Unity Catalog managed tables do not have a 30-day retention period for dropped table data. When a managed table is dropped, the data is removed according to the managed storage lifecycle, which typically deletes files promptly but does not guarantee a fixed retention window. This option misstates the retention behavior and could lead to incorrect assumptions about data recoverability.
- ✓
The data files are deleted from the managed storage location.
Why this is correct
Dropping a Unity Catalog managed table removes both the metadata and the underlying data files from the managed storage location. This is a key distinction from external tables, where only metadata is removed. The deletion is part of the managed lifecycle and happens automatically, so the data is no longer accessible via the table or directly in storage.
- ✗
The data files are moved to a recycle bin and can be restored by an account admin.
Why it's wrong here
Unity Catalog does not provide a recycle bin or a restore mechanism for dropped managed tables. Account admins cannot recover the data through a built-in feature. While some cloud storage services have versioning or soft-delete, those are not part of Unity Catalog's managed table behavior and would require separate configuration, which is not assumed here.
About these practice questions
Courseiva writes every Databricks-DE-Assoc question from scratch — 276 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Databricks exam blueprint
This Databricks-DE-Assoc practice question is part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Databricks-DE-Assoc exam.