A workflow has separate source-refresh and validation tasks. Analysts maintain a saved SQL query, publish_report, which must run as-is to change the report from pending to ready; if either prerequisite fails, the report must remain pending. Which task type and dependency behavior should the downstream task use?
Show the explanation
The SQL query task runs the maintained saved query as-is. Depending on both upstream tasks establishes their execution order, and All succeeded prevents the query from running if either task fails, leaving the report pending.