Databricks Data Engineer Associate Question 505
Select 2You are tasked with creating a Databricks SQL (DBSQL) warehouse to support your team's analytics workloads. Which of the following configurations must you specify when creating the DBSQL warehouse?
- A
The size or cluster type of the SQL warehouse
- B
The workspace region where the SQL warehouse will run
- C
The name of the SQL warehouse
- D
The maximum number of concurrent queries allowed for the SQL warehouse
- E
The default catalog and schema to be used by the SQL warehouse
Show answer and explanation
Correct answers: A, C
Explanation
When creating a Databricks SQL warehouse, you must configure its size (to control performance and cost) and provide a name for identification. Other options, like setting a default catalog or maximum concurrent queries, are either optional or managed elsewhere in the Databricks environment.
- A. Correct.
Correct: When creating a DBSQL warehouse, you must specify the size or cluster type to determine the level of performance and cost for the warehouse.
- B. Incorrect.
Incorrect: The workspace region is determined by the Databricks workspace itself and does not need to be specified when creating a DBSQL warehouse.
- C. Correct.
Correct: Naming the SQL warehouse is a required step so that it can be identified and managed later.
- D. Incorrect.
Incorrect: The maximum number of concurrent queries is not a required configuration during creation; this is managed automatically based on the warehouse size.
- E. Incorrect.
Incorrect: Setting a default catalog and schema is optional and not part of the required configurations when creating a DBSQL warehouse.