Databricks Certified Data Engineer Associate — Question 151

A data engineer needs to conduct Exploratory Analysis on data residing in a database that is within the company’s custom-defined network in the cloud. The data engineer is using SQL for this task.

Which type of SQL Warehouse will enable the data engineer to process large numbers of queries quickly and cost-effectively?

Answer options

• A. Serverless compute for notebooks
• B. Pro SQL Warehouse
• C. Classic SQL Warehouse
• D. Serverless SQL Warehouse

Correct answer: B

Explanation

The Pro SQL Warehouse is designed for high-performance query processing, making it suitable for handling a large number of queries efficiently. In contrast, Serverless compute for notebooks and Serverless SQL Warehouse may not provide the same level of performance for heavy workloads, and Classic SQL Warehouse lacks the enhancements found in the Pro version.