Databricks Data Engineer Associate · 16% practice allocation

Databricks Data Engineer Associate: Working with Lakeflow Jobs Practice Questions

5 free sample questions from the Working with Lakeflow Jobs domain, with answers and explanations. The full Data Engineer Associate bank has 300 questions across 7 domains. Questions are scenario-based and written from the official Databricks exam guide.

1.

A data engineer is building a production Databricks Workflow that runs a Python notebook as Task A, followed by a SQL task as Task B. They want Task B to receive a string output value produced by Task A (e.g., the name of a newly created table). What is the correct mechanism to pass this value between tasks?

  • A. Pass the value as a job parameter when configuring the dependency between Task A and Task B in the UI
  • B. Write the value to a Delta table from Task A and read it back in Task B using a SELECT statement
  • C. Store the value in a Databricks secret scope and retrieve it in Task B
  • D. Use dbutils.jobs.taskValues.set() in Task A and dbutils.jobs.taskValues.get() in Task B✓ Correct
Explanation

Databricks Workflows provides the Task Values API (dbutils.jobs.taskValues.set() and dbutils.jobs.taskValues.get()) specifically for passing lightweight key-value outputs between tasks in the same job run. Writing to a Delta table works functionally but is not the intended mechanism for inter-task communication and introduces unnecessary overhead. Secret scopes are for storing credentials, not dynamic run-time values produced by tasks. Job parameters are set at the job level before the run begins and cannot be dynamically set by one task for consumption by another during the same run.

2.

A data engineering team runs a complex Databricks Workflow with 20 tasks. They want to enforce the following governance rules: (1) The job must use a dedicated service principal identity, not individual user credentials. (2) The job cluster must use a specific instance profile to access S3 data. (3) If the job takes longer than 4 hours, it should be automatically terminated. Which THREE configurations are required to enforce all three rules? (Select THREE)

  • A. Attach the required IAM instance profile to the job cluster definition within the Workflow's cluster configuration✓ Correct
  • B. Set the cluster's Spark configuration property spark.databricks.timeout to 14400 seconds
  • C. Add a monitoring task at the end of the workflow that checks elapsed time and calls the Jobs API to cancel if over 4 hours
  • D. Configure a job-level timeout of 240 minutes in the Workflow settings✓ Correct
  • E. Set the job's 'Run as' identity to the designated service principal in the job's permission settings✓ Correct
  • F. Enable Databricks Unity Catalog on the workspace to enforce the service principal identity automatically
Explanation

Setting 'Run as' to a service principal ensures all job actions use that identity instead of the job creator's credentials, satisfying rule 1. Attaching the IAM instance profile to the job cluster definition gives the cluster nodes the correct AWS permissions to access S3, satisfying rule 2. Configuring a job-level timeout of 240 minutes (4 hours) causes Databricks to automatically terminate the run if it exceeds that duration, satisfying rule 3. Adding a monitoring task is a custom workaround that is unnecessary because native job-level timeout exists. Unity Catalog enforces data governance but does not automatically change the run-as identity for a job — that must be explicitly configured. spark.databricks.timeout is not a valid Spark configuration property for controlling job run duration in Databricks Workflows.

3.

A data engineer wants to run a Databricks Workflow on a recurring schedule but needs to ensure that if a run is still in progress when the next scheduled trigger fires, the new run does NOT start until the previous one completes. Which Workflow setting should the engineer configure?

  • A. Set a retry policy with zero retries and a long timeout
  • B. Configure the job cluster with autoscaling to handle overlapping runs
  • C. Enable the 'Skip if already running' checkbox in the schedule configuration
  • D. Set the job's maximum concurrent runs to 1✓ Correct
Explanation

Setting maximum concurrent runs to 1 ensures only one instance of the job can execute at a time; if a scheduled trigger fires while a run is active, the new run is queued rather than started immediately. There is no native 'Skip if already running' checkbox in Databricks Workflows — this is a distractor conflating behavior from other orchestrators. Autoscaling compute does not control concurrency at the job scheduling level. A retry policy with zero retries and a long timeout only affects failure handling, not concurrent execution.

4.

A data engineer is designing a Databricks Workflow for a financial reporting pipeline. The pipeline has the following requirements: (1) If any task fails, the on-call engineer must be notified immediately. (2) Certain non-critical tasks, if they fail, should not block downstream tasks. Which TWO Databricks Workflow features should the engineer use to meet these requirements? (Select TWO)

  • A. Configure the non-critical tasks with 'Continue on failure' behavior so downstream tasks proceed even if they fail✓ Correct
  • B. Set non-critical tasks to use the 'Run if' condition set to 'At least one parent succeeded'
  • C. Use a Databricks SQL Alert instead of job notifications for failure detection
  • D. Enable automatic retry with 5 retries on all tasks to minimize failure notifications
  • E. Configure job-level email notifications for the 'On failure' event✓ Correct
Explanation

Job-level 'On failure' email notifications ensure the on-call engineer is alerted whenever any task in the workflow fails, satisfying requirement 1. Setting non-critical tasks to 'Continue on failure' (available in task settings) allows downstream tasks to still execute even if the non-critical task fails, satisfying requirement 2. Setting 'Run if' to 'At least one parent succeeded' controls downstream execution logic based on parent outcomes but is designed for branching logic, not for allowing a failed task itself to not block — 'Continue on failure' is the direct setting. Configuring retries on all tasks would reduce failure notifications but adds unnecessary delay and does not address the notification or unblocking requirements. Using a Databricks SQL Alert is for query-based threshold monitoring, not Workflow task failure alerting.

5.

A Delta Live Tables pipeline is configured in Triggered mode. A data engineer wants to ensure that each pipeline run fully re-processes all source data from scratch rather than incrementally processing only new data. Which pipeline setting achieves this?

  • A. Set the pipeline to Continuous mode instead of Triggered mode
  • B. Delete the pipeline's streaming checkpoints before each run
  • C. Set the pipeline's target schema to a new database for each run
  • D. Enable Full refresh in the pipeline run configuration✓ Correct
Explanation

A Full refresh in DLT causes the pipeline to drop and recompute all tables from source data, effectively re-processing everything from scratch. Switching to Continuous mode changes the execution frequency but still processes data incrementally using checkpoints — it does not force a full recompute. Manually deleting streaming checkpoints is not a supported or recommended practice in DLT; DLT manages its own internal state. Changing the target schema creates a new set of tables but does not force re-processing of the existing pipeline's data within the same pipeline definition.

Test yourself across every Data Engineer Associate domain

The free Data Engineer Associate practice test mixes about 20 questions weighted like the exam. The full 300-question bank adds instant grading, flashcards and a timed mock exam.

Study this domain

Working with Lakeflow Jobs study guide (Data Engineer Associate) →

Other Data Engineer Associate domains

← All Databricks Data Engineer Associate study resources