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

Questions 6–10

1. 6foundation · easy

   A data engineer wants a Databricks job to start automatically whenever a new CSV file is uploaded to an Azure Data Lake Storage container. Which Lakeflow Jobs trigger type should be used?

   • AScheduled trigger
   • BFile arrival trigger
   • CRetry trigger
   • DTable update trigger
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A job must process files that are uploaded to an S3 bucket by a third-party service. The files are uploaded in batches, and the job should start only after all files in a batch are present. Which approach should be used?

   • AUse a file arrival trigger on the S3 bucket and configure it to wait for a specific file name pattern.
   • BUse a table update trigger on a table that is populated when the batch is complete.
   • CUse a scheduled trigger that runs every 15 minutes and checks for the presence of a batch-complete marker file.
   • DConfigure a file arrival trigger on the S3 bucket path.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A job must run whenever a 'user_activity' table is updated, but the team wants to avoid running the job during peak hours (9:00 AM to 5:00 PM) to save costs. Which configuration should be used?

   • AA scheduled trigger that runs every hour outside peak hours, and inside the job check if the table has been updated.
   • BA file arrival trigger on the table's underlying files, with a filter for non-peak hours.
   • CA table update trigger on 'user_activity' and a separate scheduled trigger that pauses the job during peak hours.
   • DA table update trigger on 'user_activity' with a schedule that excludes peak hours.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A data engineer needs to run a job every Monday at 9:00 AM to generate a weekly report. Which Lakeflow Jobs trigger type should be selected?

   • AManual trigger
   • BTable update trigger
   • CFile arrival trigger
   • DScheduled trigger
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A company has a job that must run under the following conditions: 1) Every day at 7:00 AM to generate a morning report. 2) Whenever a 'priority_orders' table is updated. 3) Whenever a file is uploaded to a specific directory. Which trigger configuration should be used?

   • ACreate three separate triggers (scheduled, table update, file arrival) all pointing to the same job.
   • BCreate a single file arrival trigger on the directory and a scheduled trigger at 7:00 AM, but no table update trigger.
   • CCreate a single scheduled trigger that runs every hour and checks for all conditions.
   • DCreate a single table update trigger on 'priority_orders' and a file arrival trigger on the directory, but no scheduled trigger.
   Reveal Solution Discussion Select an answer first