Answer-first summary for fast verification
Answer: External tables are the default method for creating tables in Unity Catalog. These tables are stored in the configured root storage location upon metastore creation and utilize the Delta table format.
Unity Catalog features include centralized data access policy management, a standards-compliant security model based on ANSI SQL, built-in auditing with user-level audit logs, and runtime data lineage capture. Managed tables, not external tables, are the default in Unity Catalog, stored in the configured root storage location and using the Delta table format. Therefore, the incorrect statement is regarding external tables being the default.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which statement about the Unity Catalog in Databricks is incorrect?
A
Unity Catalog provides a centralized platform for managing data access policies across all workspaces and personas.
B
The security model of Unity Catalog is built on standard ANSI SQL, enabling administrators to assign permissions in their data lake using familiar syntax at various levels such as catalogs, databases, tables, and views.
C
Unity Catalog automatically generates user-level audit logs that track data access.
D
External tables are the default method for creating tables in Unity Catalog. These tables are stored in the configured root storage location upon metastore creation and utilize the Delta table format.
E
Unity Catalog captures runtime data lineage for queries executed in any language on a Databricks cluster or SQL warehouse, including detailed column-level lineage and related notebooks, workflows, and dashboards.
No comments yet.