Explanation:
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.
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.