Choose Between Time‑based and Data‑driven Triggers Based on Data Availability and Pipeline Dependencies. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   Which scenario is best suited for a time-based trigger?

   • AA job that runs a daily report every morning at 7 AM, regardless of when the source data was updated.
   • BA job that should run only after an upstream table has been refreshed.
   • CA job that must react immediately to user actions in a web application.
   • DA job that must process data as soon as it lands in a cloud storage bucket.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   A data pipeline processes sales data that is uploaded by stores at unpredictable times throughout the day. The downstream dashboard must reflect new sales as soon as possible. Which trigger type is most appropriate?

   • AManual trigger that requires an operator to start the job.
   • BTime-based trigger with a cron expression for every hour.
   • CTime-based trigger with a fixed daily schedule.
   • DData-driven trigger that runs when new sales files arrive.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is the defining characteristic of a data-driven trigger?

   • AIt runs a job at a fixed time every day, such as midnight.
   • BIt initiates a job run when new data arrives or becomes available in a specified source.
   • CIt schedules a job based on the number of rows in a table exceeding a threshold.
   • DIt runs a job only after a manual approval from an administrator.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   A downstream job must run only after an upstream job has successfully produced a new table partition. Which trigger type is most appropriate?

   • ATime-based trigger that runs every hour.
   • BManual trigger that an operator runs after checking the upstream job.
   • CData-driven trigger that monitors for the new partition.
   • DTime-based trigger that runs at a fixed time each day.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Compared to time-based triggers, data-driven triggers typically result in:

   • AHigher resource usage because they run more frequently than time-based triggers.
   • BLower resource usage because they only run when new data is available.
   • CMore predictable run times because they follow a cron expression.
   • DHigher latency because they wait for a fixed schedule.
   Reveal Solution Discussion Select an answer first