Noos
PT EN
RAN-DBDEA-00280
Ranvier · DBDEA

Exam DBDEA Topics: troubleshooting Difficulty: hard

A pro SQL warehouse serves the company's morning dashboards. At 9 a.m., more concurrent queries arrive than the running clusters can execute, and analysts watch their queries sit in QUEUED status. The warehouse is configured with a minimum of 1 and a maximum of 6 clusters. What does the warehouse do while queries are queued?

Options (Reading Mode) Click to filter discussion →
  1. A. It keeps them queued and provisions additional clusters of the same size, up to the configured maximum, to drain the backlog
  2. B. It replaces each cluster's driver with a larger driver type, which frees capacity for every waiting query
  3. C. It fails the queued queries immediately with a timeout, forcing analysts to resubmit after the morning peak
  4. D. It keeps growing past the configured maximum, because warehouse scale-out has no configurable limit
Reveal answer

Correct answer: It keeps them queued and provisions additional clusters of the same size, up to the configured maximum, to drain the backlog

Reference: https://docs.databricks.com/aws/en/compute/sql-warehouse/warehouse-behavior

02 — The Myelin Layer · Canonical Discussion

Where the exam tries to trick you — and how those who passed solved it.

0 Passed

contributed to this question

Answer Distractor Matrix Click an option to filter or open its dissection.
✦ Consolidated Synthesis (Wiki) rev. #1 (baseline) · CC BY-SA 4.0
Start synthesis for this question →

No community synthesis consolidated for this question yet. Below is the verifiable official starting point — if you passed the exam, open the option dissection.

Official Answer (A): It keeps them queued and provisions additional clusters of the same size, up to the configured maximum, to drain the backlog

Ranvier · DBDEA

Contribute to this Question

Your contribution builds your Orbital Sheath

Peer contributions

No public contribution yet. Be the first who passed to explain why the distractors trick candidates — your contribution builds your Orbital Sheath.