Answer-first summary for fast verification
Answer: The data in the managed table were deleted, and the data in the unmanaged (external) table were left untouched.
In Databricks, managed tables (also called internal tables) store both metadata and data within the Databricks managed storage. When a managed table is dropped, both the metadata and the underlying data files are deleted. In contrast, unmanaged tables (external tables) store only the metadata in Databricks, while the actual data resides in an external storage location (like Azure Data Lake Storage, AWS S3, etc.). When an external table is dropped, only the metadata is removed from Databricks; the underlying data files remain intact in the external storage. The community discussion shows 100% consensus on option B, confirming this fundamental distinction between managed and external tables in Databricks.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A managed table and an external table were created in Databricks SQL, and data was loaded into each. After both tables were dropped, what happens to the underlying data for each table type?
A
The data in both tables were deleted.
B
The data in the managed table were deleted, and the data in the unmanaged (external) table were left untouched.
C
The data in the unmanaged (external) table were deleted and the data in the managed table were left untouched, for both tables the metadata was the same.
D
The data in both tables were left untouched.
No comments yet.