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: C

Explanation:

In Snowflake, to recursively resume all tasks in a chain of tasks, the Data Engineer would use the function:

C. SYSTEM$TASK_DEPENDENTS_RESUME

This function will recursively resume a specified task and all of its dependent tasks in a chain. It saves time compared to individually using ALTER TASK … RESUME for each task in the chain.