DATABRICKS-DEA Question 78

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose B0

  - Correct answer : B — A scheduled trigger using a Quartz cron expression with the time zone set to America/New_York, since the requirement is a fixed wall-clock time rather than a data event. A . Even though the job reads transaction files, the actual requirement is a guaranteed fixed start time regardless of data timing, and a file arrival trigger would instead run whenever files land, which could be well before or after 2 AM. B . A cron-based scheduled trigger with the correct time zone directly guarantees the job starts at 2 AM local time every night, matching a requirement that is explicitly about a fixed wall-clock time rather than about reacting to any particular data event. C . Relying on the transaction table's update timing is an approximation at best, since the table could update earlier or later than expected on a given night, which does not guarantee the fixed 2 AM start the analysts require. D . A continuous trigger reruns the job back-to-back with no fixed schedule at all, so it cannot guarantee output is ready at any specific wall-clock time like 2 AM.