Implement Job Schedules Using Lakeflow Jobs with an Understanding of Trigger Types (scheduled, File Arrival, and Table Update) DATA-ENGINEER-ASSOCIATE Practice Questions (Page 1)

Questions 1–5

1. 1application · easy

   A job must run at 2:00 AM and 2:00 PM every day. Which cron expression should be used for the scheduled trigger?

   • A0 2 * * *
   • B0 14 * * *
   • C0 2,14 * * *
   • D0 2,14 * * 1-5
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   A data engineer needs to run a Databricks job every day at 6:00 AM UTC. Which Lakeflow Jobs trigger type should be configured?

   • AFile arrival trigger
   • BScheduled trigger
   • CContinuous trigger
   • DTable update trigger
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   A data engineer needs a Databricks job to run automatically whenever a Delta table is modified by an upstream process. Which Lakeflow Jobs trigger type should be configured?

   • ATable update trigger
   • BScheduled trigger
   • CFile arrival trigger
   • DEvent trigger
   Reveal Solution Discussion Select an answer first
5. 4application · easy

   A data pipeline maintains a 'customer_dim' table that is updated by multiple upstream jobs throughout the day. A downstream job must run every time 'customer_dim' is updated, but not at fixed intervals. Which trigger type should be configured?

   • AManual trigger that is invoked by each upstream job after it updates the table.
   • BFile arrival trigger on the table's storage location.
   • CScheduled trigger with a short interval, such as every 10 minutes.
   • DTable update trigger on 'customer_dim'.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   A job must start as soon as a new data file is uploaded to a cloud storage path. Which Lakeflow Jobs trigger type should be used?

   • ATime-based trigger
   • BTable update trigger
   • CScheduled trigger
   • DFile arrival trigger
   Reveal Solution Discussion Select an answer first