DP-750 Certification Practice Question #2

Question

You manage Databricks SQL for the analytics team at Litware. A team of business analysts connects Power BI and the Databricks SQL editor to Unity Catalog tables. Their usage is highly variable: long idle gaps between meetings, followed by short bursts where 20+ concurrent queries arrive at once and must return quickly. The region supports serverless SQL warehouses and the workspace meets all serverless requirements.

You must choose a SQL warehouse type that:

- Starts in a few seconds after an idle period so analysts are not blocked.
- Automatically and rapidly scales out to absorb sudden query concurrency, then scales back down to minimize cost.
- Supports Photon, Predictive I/O, and Intelligent Workload Management.

Which SQL warehouse type should you choose?

Accepted Answer

Only the serverless SQL warehouse supports all three required performance features — Photon, Predictive I/O, and Intelligent Workload Management — and its IWM autoscaler rapidly provisions additional clusters to drain query queues during bursts, then scales down to control cost. Pro and classic warehouses do not support IWM and typically take about four minutes to start, which would block analysts after idle periods. All-purpose and jobs compute are not SQL warehouses and are not the recommended compute for interactive BI/SQL analytics.

More DP-750 practice questions