Noos
PT EN
RAN-DBDEA-00276
Ranvier · DBDEA

Exam DBDEA Topics: troubleshooting Difficulty: easy

A data engineer supports dozens of Databricks SQL users and keeps finding the same performance problems: tables fragmented into small files, exploding joins, and skewed aggregations. The engineer wants a place where the platform itself flags these issues for specific queries and suggests what to do about them. Where should the engineer look?

Options (Reading Mode) Click to filter discussion →
  1. A. Performance insights, which appear in query history and the query profile with actionable recommendations
  2. B. Databricks Support tickets, because query recommendations are authored only by the support team on request
  3. C. The insights page, which makes modeling decisions like schema and partitioning choices on the engineer's behalf
  4. D. Cached query results, the only executions for which the platform generates performance insight recommendations
Reveal answer

Correct answer: Performance insights, which appear in query history and the query profile with actionable recommendations

Reference: https://docs.databricks.com/aws/en/sql/user/queries/performance-insights

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): Performance insights, which appear in query history and the query profile with actionable recommendations

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.