Answer-first summary for fast verification
Answer: Data for a managed table does not reside in the `LOCATION` of the database it is registered to
A managed table in Databricks is one where Databricks manages both the metadata and the data. When you drop a managed table, both the metadata and the underlying data are deleted. Managed tables are the default when creating a table, and their data resides in the `LOCATION` of the database they are registered to. This managed relationship implies that moving a managed table to a new database requires rewriting all data to the new location. The incorrect statement is that the data does not reside in the `LOCATION` of the database it is registered to, making it the correct answer to this question.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which statement about a managed table in Databricks is incorrect?
A
Databricks manages both the metadata and the data for a managed table
B
Data for a managed table does not reside in the LOCATION of the database it is registered to
C
Managed tables are the default when creating a table in Databricks
D
Dropping a managed table will delete both the metadata and underlying data of that table
E
Managed relationship between the data location and the database means that in order to move a managed table to a new database, you must rewrite all data to the new location
No comments yet.