Databricks Certified Data Engineer Associate — Question 140

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. Classic SQL Warehouse
• B. Serverless SQL Warehouse
• C. Pro SQL Warehouse
• D. All-purpose compute cluster

Correct answer: B

Explanation

The Serverless SQL Warehouse is designed to handle a large volume of queries efficiently and without the need for provisioning resources, making it cost-effective for exploratory analysis. In contrast, the Classic SQL Warehouse requires pre-provisioned resources, which can lead to higher costs and slower performance for ad-hoc queries. The Pro SQL Warehouse and All-purpose compute cluster are also not optimized for the specific needs of quick and cost-effective query processing in this context.