Explanation:
The correct SQL query structure is SELECT * FROM enterprise.sales.customer_info. 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.
You are tasked with querying a three-layer namespace in Databricks to retrieve data from a specific table. The namespace consists of catalogs, databases, and tables. Describe the SQL query you would use to access a table named 'customer_info' located in the 'sales' database within the 'enterprise' catalog. Additionally, explain the benefits of using a three-layer namespace in terms of data organization and access control.
A
SELECT * FROM enterprise.sales.customer_info; Benefits include hierarchical organization and granular access control.
B
SELECT * FROM sales.enterprise.customer_info; Benefits include flat organization and broad access control.
C
SELECT * FROM customer_info; Benefits include simplicity and ease of use.
D
SELECT * FROM enterprise_sales_customer_info; Benefits include consolidated naming and simplified access.