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