Answer-first summary for fast verification
Answer: SELECT * FROM global.finance.sales_data; Benefits include hierarchical organization and granular access control.
The correct SQL query structure is SELECT * FROM global.finance.sales_data. The three-layer namespace provides a hierarchical organization that simplifies data management and enables granular access control, making it easier to manage permissions and locate specific data sets.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Consider a scenario where you need to query a three-layer namespace in Databricks. The namespace consists of catalogs, databases, and tables. Describe how you would structure your SQL query to access a specific table named 'sales_data' located in the 'finance' database within the 'global' catalog. Additionally, explain the benefits of using a three-layer namespace in terms of organization and access control.
A
SELECT * FROM global.finance.sales_data; Benefits include hierarchical organization and granular access control.
B
SELECT * FROM finance.global.sales_data; Benefits include flat organization and broad access control.
C
SELECT * FROM sales_data; Benefits include simplicity and ease of use.
D
SELECT * FROM global_finance_sales_data; Benefits include consolidated naming and simplified access.