Home / DE Associate practice test / Databricks Intelligence Platform / Question

Databricks Data Engineer Associate · free practice question

Multiple analysts run frequent ad-hoc SQL against curated Delta tables throughout the day. Requirements: fast startup, high concurrency for many simultaneous…

Exam-style question on Databricks Intelligence Platform from the free DE Associate practice test, with the answer and a full explanation below.

Updated November 10, 2026

Databricks Intelligence Platform

Multiple analysts run frequent ad-hoc SQL against curated Delta tables throughout the day. Requirements: fast startup, high concurrency for many simultaneous users, automatic scaling to control cost, and no need to manage Spark cluster internals. Which compute option is the best fit?

  1. AA single-node all-purpose cluster, the cheapest compute, which serves many analysts running simultaneous interactive SQL queries through the day.
  2. BA serverless SQL warehouse, which starts in seconds, scales out for concurrent queries, and needs no Spark cluster configuration from the team.
  3. CA large fixed-size classic compute cluster with autoscaling turned off, which holds full capacity ready for the analysts throughout the working day.
  4. DA job cluster created fresh for each submitted statement, which isolates each analyst's query on dedicated compute and terminates when it finishes.
  5. EA single Structured Streaming job that receives the analysts' SQL statements as micro-batches and serves the interactive queries from one pipeline.
Answer & explanation

Correct answer: B

WHY B: A serverless SQL warehouse is purpose-built for interactive, high-concurrency SQL: near-instant startup, autoscaling across concurrent queries, and no cluster management, which matches every requirement.

WHY NOT A: A single-node cluster cannot serve many concurrent analysts and carries a slow, manual lifecycle.

WHY NOT D: Spinning up a job cluster per query adds minutes of startup latency and cost and is not how interactive SQL is served.

WHY NOT C: A fixed, always-on large cluster wastes money (no scaling to control cost) and still requires manual configuration and management.

WHY NOT E: Structured Streaming is for continuous pipelines, not ad-hoc interactive SQL.

Take the full DE Associate practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Engineer Associate practice test. Take it and get a section-by-section score.

Start the free test →