When a Unity Catalog managed table is dropped using `DROP TABLE`, what happens to the underlying data files?

AThe Unity Catalog metadata is removed, but the data files remain in the original storage location

BBoth the Unity Catalog metadata and the underlying data files are permanently deleted

CThe table is moved to a soft-delete recycle bin and can be restored within 30 days

DThe table is automatically converted to an external table pointing to its original storage location

Related Questions

Where does Unity Catalog automatically store column-level data lineage records that track read and w...

medium

A user needs to query the table `main.sales.orders` in Unity Catalog. An admin has granted `SELECT` ...

medium

A company migrates from a legacy Hive metastore to Unity Catalog. In the legacy setup, tables are or...

hard

In Unity Catalog, which object type is used to govern access to non-tabular files stored in cloud ob...

easy

A company wants to tag all columns containing PII data in Unity Catalog with a tag `pii_type = 'emai...

medium

View all Data Governance questions

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy

Discussion

Be the first to share your understanding of this concept

⚠️ Discussion is for concept clarification only. Do not share or request actual exam questions or answers.

When a Unity Catalog managed table is dropped using DROP TABLE, what happens to the underlying data files?

Related Questions

Discussion

When a Unity Catalog managed table is dropped using `DROP TABLE`, what happens to the underlying data files?