Noos
PT EN
RAN-DBDEA-00005
Ranvier · DBDEA

Exam DBDEA Topics: platform Difficulty: medium

A BI team connects Tableau and Power BI to the Databricks workspace over JDBC/ODBC and spends the day running ad hoc SQL queries and dashboards against gold Delta tables. Analysts do not want to size or tune Spark clusters; they need compute that is optimized for SQL analytics and BI workloads and that starts and scales on demand with query traffic. Which compute service should the team use?

Options (Reading Mode) Click to filter discussion →
  1. A. A classic all-purpose Spark cluster with Photon enabled, shared by all analysts
  2. B. A SQL warehouse, the compute optimized for SQL queries, analytics, and business intelligence workloads
  3. C. A classic job cluster scoped to a nightly Lakeflow Job, which the BI tools would have to connect to during the day while it stays running
  4. D. Serverless compute for jobs, because the BI tools schedule their queries as job tasks
Reveal answer

Correct answer: A SQL warehouse, the compute optimized for SQL queries, analytics, and business intelligence workloads

Reference: https://docs.databricks.com/aws/en/compute

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 (B): A SQL warehouse, the compute optimized for SQL queries, analytics, and business intelligence workloads

⚓ Official Documentation Anchor: https://docs.databricks.com/aws/en/compute
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.