CertKeen

Databricks Data Engineer Professional · Free practice question 11 of 12

Table update triggers for jobs

A downstream Lakeflow Job at Kelmscott Foods should start only after both sales.gold.orders and sales.gold.returns have been updated by other teams' pipelines, whose finish times vary. Which trigger does this without polling code?

  1. A.A cron schedule set after the latest expected finish time
  2. B.A table update trigger on both tables, configured to fire when all of the tables are updated
  3. C.A continuous trigger that checks the tables in a loop
  4. D.A file arrival trigger on the tables' storage location
Show answer and explanation

Correct answer: B. A table update trigger on both tables, configured to fire when all of the tables are updated

Why: Table update triggers start a job when monitored Unity Catalog tables are updated; with several tables, the trigger can fire when any table or when all tables have been updated, and options such as the wait after the last change smooth out bursts of commits. A fixed schedule either waits too long or runs too early, a continuous polling loop wastes compute, and file arrival triggers watch storage paths rather than table commits.

More free Databricks Data Engineer Professional questions