Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK … RESUME)?

Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK … RESUME)?
A . SYSTEM$TASK_DEPENDENTS
B . SYSTEM$TASK_DEPENDENTS_ENABLE
C . SYSTEM$TASK_DEPENDENTS_RESUME
D . SYSTEM$TASK_RECURSIVE_ENABLE

View Answer

Answer: B

Explanation:

To recursively resume all tasks in a DAG(A Directed Acyclic Graph (DAG) is a series of tasks com-posed of a single root task and additional tasks, organized by their dependencies.), query the SYS-TEM$TASK_DEPENDENTS_ENABLE function rather than resuming each task individually (using ALTER TASK … RESUME).