Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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...