SnowPro Core Streams and Tasks 2

Question 1

What is the primary purpose of a Snowflake Task?

Accepted Answer

To schedule and execute a SQL statement or stored procedure on a recurring basis

Answer

Snowflake Tasks are used to schedule a single SQL statement or stored procedure call to execute at a defined interval or cron schedule, enabling automated data pipelines.

Question 2

Which syntax correctly schedules a Snowflake Task to run every day at midnight UTC?

Accepted Answer

SCHEDULE = 'USING CRON 0 0 * * * UTC'

Answer

Snowflake cron-based task schedules require the format SCHEDULE = 'USING CRON ', for example SCHEDULE = 'USING CRON 0 0 * * * UTC'.

Question 3

What must you do before a newly created Snowflake Task will begin executing on its schedule?

Accepted Answer

Run ALTER TASK <task_name> RESUME to activate it

Answer

Newly created tasks are in a SUSPENDED state by default; you must explicitly run ALTER TASK <name> RESUME to activate scheduled execution.

Question 4

What is a Snowflake Task DAG (Directed Acyclic Graph)?

Accepted Answer

A root task that triggers on a schedule with one or more dependent child tasks that run in order

Answer

A task DAG is a tree of tasks where a root task runs on a defined schedule and triggers child tasks upon completion, allowing complex multi-step pipeline orchestration.

Question 5

What is the maximum number of child tasks that a single parent task can have in a Snowflake task DAG?

Accepted Answer

100

Answer

A single task node in a Snowflake DAG can have up to 100 child tasks, enabling broad parallel branching in complex pipeline workflows.

SnowPro Core Practice Test

SnowPro Core Practice Test

SnowPro Core Streams and Tasks 2