Databricks-DE-Assoc Working with Lakeflow Jobs Practice Question
A data engineer is building a Lakeflow Job with a task that runs a SQL notebook. The task must run only on weekdays and must be completed before 9 AM. The engineer wants to configure the schedule to meet these requirements. What should the engineer do?
⚠ Common exam trap
The trap here is assuming that event-based triggers or continuous execution can enforce time-of-day and weekday constraints, which they cannot.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use a cron expression with a schedule that runs at 8 AM Monday through Friday.
The correct method is to use a cron schedule that runs at 8 AM Monday through Friday. Lakeflow Jobs natively support cron expressions, allowing precise control over run times and days. This satisfies the weekday-only and before-9-AM requirements without additional complexity.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Configure the job to run continuously with a 1-hour pause between runs and enable a weekday filter.
Why it's wrong here
Continuous jobs with pauses are not designed for specific time windows; they run at fixed intervals. There is no built-in weekday filter for continuous jobs. This would not ensure the job runs only on weekdays or completes before 9 AM, and it would consume resources unnecessarily.
- ✓
Use a cron expression with a schedule that runs at 8 AM Monday through Friday.
Why this is correct
Lakeflow Jobs support cron-based schedules. A cron expression like '0 0 8 ? * MON-FRI *' (Quartz format) runs at 8 AM on weekdays. This meets the requirement of running only on weekdays and completing before 9 AM, assuming the task finishes within an hour. This is the standard way to set time-based schedules.
- ✗
Set the job to trigger on a file arrival event and filter for weekdays.
Why it's wrong here
File arrival triggers are event-based and do not inherently support weekday filtering or time-of-day constraints. While you could use a file arrival trigger, it would not guarantee running only on weekdays or before 9 AM. This approach does not meet the scheduling requirements.
- ✗
Use a Databricks SQL alert to trigger the job when a condition is met.
Why it's wrong here
Databricks SQL alerts are used for monitoring query results and can trigger notifications, but they are not a scheduling mechanism for Lakeflow Jobs. Using an alert to trigger a job is not a supported feature. This approach does not provide time-based scheduling.
About these practice questions
This Databricks-DE-Assoc question is part of Courseiva's 276-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Databricks exam blueprint
This Databricks-DE-Assoc practice question is part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Databricks-DE-Assoc exam.