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 2)

Questions 6–10

1. 6expert · hard

   A data engineer is monitoring a job that runs every hour. Over the past 24 hours, the job has failed 4 times. The DAG shows that the 'transform' task is the longest-running task, taking 25 minutes on average. The 'load' task takes 5 minutes. The total run time for the job is 30 minutes. What is the most appropriate conclusion?

   • AThe job is unreliable, but the run time is not a concern.
   • BThe 'load' task is the bottleneck because it is the final step.
   • CThe 'transform' task is the bottleneck and should be optimized.
   • DThe job is healthy because the failure rate is below 20%.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A data engineer is investigating a nightly job that has been running longer than usual. The DAG view shows that the 'extract' task took 45 minutes, while the 'transform' task took 10 minutes. The job's total run time is 60 minutes. What should the engineer conclude?

   • AThe job is running efficiently because all tasks completed successfully.
   • BThe job has a parallel execution issue because the total run time is not the sum of all task durations.
   • CThe 'extract' task is the bottleneck and should be optimized first.
   • DThe 'transform' task is the bottleneck because it is the core processing step.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   In the Lakeflow Jobs UI, what does a high failure rate over time indicate about a pipeline?

   • AThe pipeline is performing efficiently and quickly.
   • BThe pipeline is running more frequently than expected.
   • CThe pipeline is unreliable and may require investigation into the causes of failures.
   • DThe pipeline is using too many resources.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   In the Lakeflow Jobs UI, a job run is displayed with the status 'Pending'. What does this status indicate about the run?

   • AThe run is currently executing its tasks.
   • BThe run has completed successfully and is awaiting final confirmation.
   • CThe run has been submitted and is waiting for resources to become available.
   • DThe run has encountered an error and is waiting for user intervention.
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A data engineer is monitoring a job that runs every 2 hours. Over the past 48 hours, the job has failed 6 times. The average run time has increased from 15 minutes to 25 minutes. The DAG shows that the 'transform' task is the longest-running task. What is the most appropriate action?

   • ACheck the cluster logs for resource contention.
   • BInvestigate the 'transform' task for performance issues.
   • CIgnore the failures because the job is mostly successful.
   • DIncrease the frequency of the job to reduce failure rates.
   Reveal Solution Discussion Select an answer first