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._

Simulated

SELECT * FROM global.finance.sales_data; Benefits include hierarchical organization and granular access control.*_

94.4%

SELECT * FROM finance.global.sales_data; Benefits include flat organization and broad access control.*_

2.8%

SELECT * FROM sales_data; Benefits include simplicity and ease of use.*_

1.1%

SELECT * FROM global_finance_sales_data; Benefits include consolidated naming and simplified access.*_

1.8%

Databricks Certified Data Engineer - Associate