
Answer-first summary for fast verification
Answer: Data Explorer
To upgrade a schema or multiple tables to Unity Catalog, the Data Explorer upgrade wizard is used. This process involves copying schemas (databases) and external tables from the default Hive metastore to the Unity Catalog metastore. Requirements include having a storage credential with service principal authorization, an external location referencing the storage credential and data path, and CREATE EXTERNAL TABLE permission on the external locations. The upgrade process is initiated through the Data Explorer by selecting the schema to upgrade, choosing tables for upgrade, setting destination catalog and schema, reviewing configurations, and running the generated SQL query. Fine-grained access control is then defined, and workloads are modified to use the new table. Thus, the correct answer is Data Explorer.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer needs to upgrade a schema named 'retail' from the default Hive metastore to the Unity Catalog metastore using the Databricks Lakehouse Platform UI. Which option should they use?
A
Repos
B
Compute
C
Data Explorer
D
Workflows
E
Workspace