Noos
PT EN
RAN-DBDEA-00181
Ranvier · DBDEA

Exam DBDEA Topics: platform Difficulty: medium

A BI team is choosing a SQL warehouse for analysts who run ad hoc queries and dashboard refreshes with very uneven traffic: long quiet periods followed by bursts of concurrent queries. The team wants compute that starts quickly and scales responsively with that demand. Which warehouse should the team choose?

Options (Reading Mode) Click to filter discussion →
  1. A. A classic or pro warehouse, because these provision their clusters faster than serverless warehouses and react to load spikes more quickly
  2. B. Any warehouse type works, because classic, pro, and serverless warehouses behave identically in startup and scaling and differ only in price
  3. C. A serverless warehouse, which starts quickly, scales dynamically, and is the type Databricks recommends for most workloads
  4. D. A serverless warehouse, once the team has selected the instance types that its worker clusters will run on
Reveal answer

Correct answer: A serverless warehouse, which starts quickly, scales dynamically, and is the type Databricks recommends for most workloads

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 (C): A serverless warehouse, which starts quickly, scales dynamically, and is the type Databricks recommends for most workloads

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.