Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
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._
Simulated
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.*_
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.*_
Comments
Loading comments...