Data-Engineer-Associate - Troubleshooting, Monitoring, and Optimization (10% of the exam) - Section 6.1

Identify trends in job performance using the Lakeflow Jobs run history view to compare current execution times against historical baselines.

Read the Lakeflow Jobs run history to compare a run's duration with earlier runs, spot regressions, and link a slowdown to a change in data volume or code. Recognise when a duration alert is the right safeguard.

job run historyexecution time baselineduration trendsjob run matrixduration alerts

Practice question for this objective

Free sampleTroubleshooting, Monitoring, and Optimizationmedium

A nightly Lakeflow Job has grown from about forty minutes to about seventy minutes over the past three weeks. Opening the job in the Lakeflow Jobs run history, an engineer sees that the transformation task itself still takes roughly the same time in every recent run, while the gap between the run starting and the task beginning has grown steadily. The job runs on a job cluster that is created for each run. Which conclusion does the run history support, and what should the engineer address first?

  • AThe transformation is spilling more shuffle data each night, so the engineer should raise the executor memory on the job cluster and rerun to confirm the improvement.
  • BThe source tables have grown, so the engineer should repartition the largest input and add workers to the job cluster until the nightly duration returns to its earlier level.
  • CThe job is being throttled by concurrent runs of the same job, so the engineer should lower the maximum concurrent runs setting and rerun the job on the same schedule.
  • DThe extra time is spent before execution, waiting on compute to be provisioned, so the engineer should attack the cluster start and queueing time rather than tune the Spark work. Correct
Read a Lakeflow Jobs run history breakdown to tell compute acquisition time apart from task execution time before choosing a fix. A run duration in Lakeflow Jobs covers more than the code: it includes queueing and the provisioning of the compute the task runs on. Because the run history reports those portions separately, a run whose execution time is flat while its pre-execution time climbs is telling the engineer that the regression sits in compute acquisition, so the correct first move is to shorten or remove the cluster start, for example by moving the task to serverless compute or to a pool, rather than tuning a transformation that has not changed.

Why A is wrong: Spill is a genuine cause of growing task duration and is a common first guess, but the run history shows the task duration flat and the pre-task time rising, so the extra minutes are not being spent inside the transformation at all.

Why B is wrong: Growing input would show up as longer task execution in the run history, and it does not, so adding workers spends money on the part of the run that has not changed.

Why C is wrong: Concurrency limits can delay a run and so this looks plausible, but a single nightly schedule produces one run at a time, and the run history would show a queued run rather than a steadily lengthening setup phase.

Why D is correct: The run history separates the waiting and setup portion of a run from the task execution portion, and here only the former has grown, which points at compute acquisition rather than at the transformation logic.

See more Data-Engineer-Associate practice questions, answers explained.

Exam traps in Troubleshooting, Monitoring, and Optimization

Answers that look right on this material and are not. Each one is a distractor from a different question in the Data-Engineer-Associate bank for this domain.

  • Compare last night's run against the immediately preceding run of the same job, and treat any increase over that single run as the regression the team needs to investigate.

    Why it is wrong: One prior run is the easiest comparison to make in the run history, but a single sample carries the same hour to hour variation as the run being judged, so the comparison cannot separate noise from a trend.

  • Compare the count of tasks in the recent runs against the earlier ones, because a run that has gained tasks is doing more work and the added tasks account for the extra minutes without any change in the data volume.

    Why it is wrong: Task count is worth knowing and a changed job definition would show up in it, but the job here is unchanged, so this reading confirms only that the structure is the same and leaves the source of the extra fifteen minutes unidentified.

  • Raise the run history retention period in the job's settings, because the workspace run list keeps runs for a configurable number of days and the default value is what is trimming the older runs away.

    Why it is wrong: It is a reasonable guess that a retention window shown in a product is something the owner can extend, but the run list retention is fixed rather than a job setting, so an engineer looking for that field will not find one and the older runs stay unavailable.

Examworthy is not affiliated with or endorsed by Databricks. Original, blueprint-aligned practice material only.