Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?

The correct answer is C. CURRENT_TASK_GRAPHS. CURRENT_TASK_GRAPHS is the Snowflake table function that returns information about DAG runs that are currently scheduled or actively executing. It shows the real-time state of in-flight task graph executions. The other functions serve different purposes: COMPLETE_TASK_GRAPHS…

Data Transformations

Question

Options

ATASK_HISTORY
BTASK_DEPENDENTS
CCURRENT_TASK_GRAPHS
DCOMPLETE_TASK_GRAPHS

How the community answered

(47 responses)

B
2% (1)
C
94% (44)
D
4% (2)

Explanation

CURRENT_TASK_GRAPHS is the Snowflake table function that returns information about DAG runs that are currently scheduled or actively executing. It shows the real-time state of in-flight task graph executions. The other functions serve different purposes: COMPLETE_TASK_GRAPHS shows details about DAG runs that have already finished; TASK_HISTORY returns the execution history of individual tasks; and TASK_DEPENDENTS shows the hierarchical dependency structure of tasks within a DAG, not their runtime status.

Topics

#Task Graphs#Monitoring#Snowflake Tasks

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice