Databricks Certified Data Analyst Associate Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - Correct answer : A — Increase the maximum cluster count so the warehouse can spin up additional clusters and distribute the concurrent queries across them A . Raising the maximum cluster count is correct because SQL warehouses handle high concurrency by adding clusters that share the incoming query load, rather than by making one cluster larger; more clusters means more queries can run in parallel instead of queuing. B . Cluster size (t-shirt size) mainly affects how much compute a single query gets to run faster, not how many separate queries can run at once, so growing it further does little to relieve queuing from many simultaneous users. C . Classic warehouses are not specifically optimized for concurrency; they offer entry-level performance without the intelligent workload management that helps distribute concurrent load, so switching to Classic would not resolve this queuing. D . Photon is a vectorized query engine that speeds up query execution rather than a resource competing with concurrency, so disabling it would not free capacity for more simultaneous queries and could slow individual queries down.