An organization wants to minimize the administrative overhead of managing compute for SQL analytics. They want to run SQL queries without provisioning or scaling clusters manually. Which SQL Warehouse configuration best meets this need?

An interactive cluster with autoscaling

A Pro SQL Warehouse with autoscaling

A Classic SQL Warehouse with a fixed size

A team of data analysts needs to run ad-hoc SQL queries on a shared Delta table. They do not need to develop or run Python or Scala code. Which compute option is most appropriate?

A job cluster configured for SQL tasks

An interactive cluster with Databricks Runtime for Machine Learning

A classic interactive cluster with autoscaling

Which of the following best describes the architecture of a SQL Warehouse?

A virtual network that connects to external databases

A managed compute cluster that separates compute from storage

A storage service that holds all tables and files

A serverless function that executes SQL on demand

An administrator needs to ensure that a SQL Warehouse can handle a sudden increase in query load without manual intervention. Which configuration should they set?

Set a fixed cluster size that is large enough for peak load.

Enable Photon to speed up queries.

Increase the query timeout to allow more time for execution.

Enable autoscaling with a minimum and maximum cluster size.

How is compute provisioned for a SQL Warehouse in Databricks?

It uses a fixed set of physical servers that are always running

It uses a cluster of virtual machines that are automatically started and stopped based on demand

It uses the same compute as the data lake storage layer

It uses a single large VM that is shared across all queries

DatabricksCertified Data Analyst Associate

Domain 4Objective 2

Explain the Role a SQL Warehouse Plays in Query Execution. DATA-ANALYST-ASSOCIATE Practice Questions (Page 3)

Part of the Section 4: Executing queries using Databricks SQL and Databricks SQL Warehouses domain, which makes up ~22% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–13 in this domain), expect 1–1 from this objective — we provide 23 practice questions to prepare you well beyond it. (estimate)

23questions here

5free pages

6concepts

Questions 11–15

11application · medium
An organization wants to minimize the administrative overhead of managing compute for SQL analytics. They want to run SQL queries without provisioning or scaling clusters manually. Which SQL Warehouse configuration best meets this need?
Select an answer first
12application · medium
A team of data analysts needs to run ad-hoc SQL queries on a shared Delta table. They do not need to develop or run Python or Scala code. Which compute option is most appropriate?
Select an answer first
13foundation · easy
Which of the following best describes the architecture of a SQL Warehouse?
Select an answer first
14application · medium
An administrator needs to ensure that a SQL Warehouse can handle a sudden increase in query load without manual intervention. Which configuration should they set?
Select an answer first
15foundation · easy
How is compute provisioned for a SQL Warehouse in Databricks?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ANALYST-ASSOCIATE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ANALYST-ASSOCIATE” is a trademark of its owner, used for identification only.