Use the Lakeflow Jobs UI to Monitor Pipeline Health by Interpreting Job Statuses, Viewing DAG‑based Task Graphs to Spot Upstream Blockers, and Tracking Pipeline Run Times and Failure Rates. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 3)

Questions 11–15

1. 11expert · hard

   A data engineer is monitoring a job that runs every 6 hours. Over the past week, the job has failed 4 times, and the average run time has increased from 20 minutes to 35 minutes. The DAG shows that the 'load' task is the longest-running task. What is the most appropriate conclusion?

   • AThe job is becoming less reliable and slower, so the 'load' task should be investigated.
   • BThe job is healthy because the failure rate is below 10%.
   • CThe job is unreliable, but the run time increase is not a concern.
   • DThe job is healthy because the 'load' task is the longest, which is expected.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   A pipeline's run time has been steadily increasing over the past week, but the failure rate remains low. What does this combination of metrics suggest about the pipeline's health?

   • AThe pipeline is healthy and no action is needed.
   • BThe pipeline is failing frequently and needs immediate attention.
   • CThe pipeline is reliable but may be experiencing performance degradation, such as a bottleneck.
   • DThe pipeline is unhealthy and should be immediately stopped.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   A data engineer wants to assess the performance of a pipeline by looking at how long the entire run took. Which metric in the Lakeflow Jobs UI would directly provide this information?

   • AThe number of tasks in the run.
   • BThe number of retries for the run.
   • CThe run duration, shown as the time from run start to run end.
   • DThe cluster's uptime.
   Reveal Solution Discussion Select an answer first
5. 14application · easy

   A data engineer is monitoring a job that runs every 4 hours. Over the past 24 hours, the job has failed 2 times. What is the failure rate?

   • A33.3%
   • B50%
   • C16.7%
   • D8.3%
   Reveal Solution Discussion Select an answer first
6. 15application · easy

   A data engineer is monitoring a job that runs every hour. Over the past 24 hours, the job has failed 6 times. What is the failure rate for this job?

   • A30%
   • B25%
   • C15%
   • D20%
   Reveal Solution Discussion Select an answer first