Noos
PT EN
RAN-DBDEA-00250
Ranvier · DBDEA

Exam DBDEA Topics: jobs Difficulty: hard

The first task in a Lakeflow Job runs a SQL task that computes yesterday's totals; a downstream notebook task needs that number as a parameter, but the SQL task does not use dbutils, so it cannot set a task value itself. How can the SQL task's output reach the notebook task?

Options (Reading Mode) Click to filter discussion →
  1. A. Have the SQL task write the value with dbutils.jobs.taskValues.set in a trailing statement
  2. B. Pull it with a dynamic value reference like {{tasks.totals.output.first_row.yesterday_total}}
  3. C. Recompute the total in the notebook with an identical SQL query against the same tables
  4. D. Declare the number as a job parameter and edit the job definition manually every single night
Reveal answer

Correct answer: Pull it with a dynamic value reference like {{tasks.totals.output.first_row.yesterday_total}}

Reference: https://docs.databricks.com/aws/en/jobs/dynamic-value-references

Train this exam on Ranvier →

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): Pull it with a dynamic value reference like {{tasks.totals.output.first_row.yesterday_total}}

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.