Databricks Data Engineer Associate Question 504
Select 4You are tasked with creating a DBSQL warehouse in Databricks for your organization's analytics workloads. Which of the following steps are necessary to successfully create and configure a DBSQL warehouse?
- A
Navigate to the SQL persona in Databricks and access the 'SQL Warehouses' tab.
- B
Specify the desired cluster size and configure auto-scaling options.
- C
Enable Delta Sharing to allow external data sharing with partners.
- D
Set the warehouse to auto-stop after a specified period of inactivity.
- E
Assign user and group permissions to the warehouse for controlled access.
Show answer and explanation
Correct answers: A, B, D, E
Explanation
Creating a DBSQL warehouse involves accessing the SQL persona, configuring the cluster size and scaling options, enabling cost-saving features like auto-stop, and setting access permissions. While Delta Sharing is a useful feature, it is not relevant to the process of creating or configuring a DBSQL warehouse.
- A. Correct.
Correct: Accessing the 'SQL Warehouses' tab under the SQL persona is the first step in creating a DBSQL warehouse.
- B. Correct.
Correct: Choosing the cluster size and enabling auto-scaling ensures the warehouse can handle varying workloads efficiently.
- C. Incorrect.
Incorrect: Delta Sharing is not required to create or configure a DBSQL warehouse; it is a separate feature for sharing data externally.
- D. Correct.
Correct: Setting the auto-stop feature prevents unnecessary costs by stopping the warehouse after inactivity.
- E. Correct.
Correct: Configuring user and group permissions ensures secure and controlled access to the warehouse.