Databricks Data Engineer Associate Question 503
Select 4You are tasked with creating a Databricks SQL Warehouse for a team of analysts who need to query data frequently. Which of the following steps should you take to successfully create and configure the SQL Warehouse?
- A
Navigate to the SQL persona in the Databricks workspace and click 'SQL Warehouses'.
- B
Click on 'Create SQL Warehouse', provide a name, and configure the cluster size based on workload requirements.
- C
Ensure the SQL Warehouse is attached to a Unity Catalog-enabled catalog for data governance and access control.
- D
Set up a Databricks cluster and manually configure it to act as a SQL Warehouse.
- E
Enable auto-stop to save costs during periods of inactivity.
Show answer and explanation
Correct answers: A, B, C, E
Explanation
Creating a Databricks SQL Warehouse involves navigating to the SQL persona, configuring the warehouse with appropriate settings (such as name, cluster size, and auto-stop), and optionally attaching it to a Unity Catalog for better data governance. Manually configuring a cluster is not required, as SQL Warehouses are a distinct feature designed for SQL operations.
- A. Correct.
Correct: Accessing the SQL persona and navigating to 'SQL Warehouses' is the initial step to create a SQL Warehouse in Databricks.
- B. Correct.
Correct: Providing a name and configuring the cluster size are necessary steps during the creation of a SQL Warehouse.
- C. Correct.
Correct: Attaching the SQL Warehouse to a Unity Catalog-enabled catalog ensures proper data governance and access control, which is a recommended best practice.
- D. Incorrect.
Incorrect: A Databricks SQL Warehouse is not created by manually configuring a cluster; it is a separate feature designed specifically for SQL workloads.
- E. Correct.
Correct: Enabling auto-stop is a cost-saving option available during SQL Warehouse configuration to pause the warehouse during inactivity.