In a Lakeflow Job, a notification task must run after three upstream tasks regardless of whether they succeed or fail, so alerts are always sent. Which task-level condition implements 'run once all upstream tasks reach a terminal state, success or failure'?
Answer & explanation
Correct answer: E
WHY E: ALL_DONE runs the task once all dependencies have reached a terminal state — success, failure, or skipped — which is exactly 'always run' behavior. WHY NOT A: ALL_SUCCESS (the default) runs only if all upstream tasks succeed, so it is skipped on failure. WHY NOT B: NONE_FAILED runs only when nothing failed — the opposite of covering failures. WHY NOT C: A time-offset schedule is unreliable (durations vary) and decouples the task from its dependencies. WHY NOT D: AT_LEAST_ONE_SUCCESS requires a success and would be skipped if all upstream tasks fail.