Home / Data Engineer Associate / Objective 7.1

Domain 7: Governance and Security · 15% of the exam · Full exam outline

7.1 Differentiate between managed and external tables in Unity Catalog and perform basic operations (create, modify, delete, and convert between managed and external tables) on them.

Practice questions

Question 1easy

A data engineer runs DROP TABLE on a Unity Catalog external table whose files sit in a storage path the team chose. What happens to the underlying data files?

Included in Sample: sample every domain.See plans

Choose an answer to check it. Afterward, select any option to review its explanation.

Dropping a table never relocates its files; moving data to managed storage is what a managed conversion does.

That is what happens when a managed table is dropped, because Unity Catalog controls its file lifecycle. This table is external.

VACUUM removes unreferenced files of an existing table; it is not what governs files after an external table is dropped.

For an external table, Unity Catalog governs the metadata but you own the file lifecycle, so dropping it removes only the metadata and leaves the files where they are.

Question 2easy

A partner delivers JSON files to a storage path the team controls, and tools outside Databricks read those files from that same path. The team wants to query the files as a Unity Catalog table without moving or converting them. Which table type fits?

Included in Master: master every domain.See plans