Noos
PT EN
RAN-DBDEA-00269
Ranvier · DBDEA

Exam DBDEA Topics: troubleshooting Difficulty: medium

Databricks SQL dashboards have been intermittently slow for a week. The team lead wants to review the slowest queries that one specific analyst ran on the shared warehouse last Tuesday, see how long each took, and check whether they were queued or spilling. How can the lead find them without leaving the workspace UI?

Options (Reading Mode) Click to filter discussion →
  1. A. Ask the analyst to export her own list manually, since each user's history is private and no consolidated view exists for the team
  2. B. Open Query History, filter by user, warehouse, and date range, then sort the runs by duration to surface the slowest
  3. C. Open a query profile, which lists every query in the workspace ranked by elapsed time and spill
  4. D. Rerun each dashboard query by hand, because query history is discarded as soon as execution finishes
Reveal answer

Correct answer: Open Query History, filter by user, warehouse, and date range, then sort the runs by duration to surface the slowest

Reference: https://docs.databricks.com/aws/en/sql/user/queries/query-history

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): Open Query History, filter by user, warehouse, and date range, then sort the runs by duration to surface the slowest

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.