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

To monitor virtual warehouse credit consumption in real time

Answer

To replicate data between two Snowflake accounts in different regions

Answer

To manage row-level access control policies on sensitive tables

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

SCHEDULE = '0 0 * * *'

Answer

INTERVAL = '1 DAY' AT '00:00 UTC'

Answer

SCHEDULE = 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

Grant EXECUTE TASK privilege to the PUBLIC role

Answer

Set AUTOSTART = TRUE in the task definition

Answer

Attach the task to a running virtual warehouse first

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 visual dashboard for monitoring warehouse credit usage over time

Answer

A schema-level view of all table relationships and foreign keys

Answer

A billing report that groups task costs by department or cost center

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

1

Answer

10

Answer

Unlimited

Question 6

Which account-level privilege is required for a role to own and execute Snowflake Tasks?

Accepted Answer

EXECUTE TASK on the account

Answer

USAGE on the database containing the task

Answer

OWNERSHIP on all tables referenced in the task's SQL

Answer

OPERATE on the virtual warehouse used by the task

Question 7

How can a Snowflake Task be configured to skip execution when there is no new data to process in a stream?

Accepted Answer

Use a WHEN SYSTEM$STREAM_HAS_DATA('<stream>') clause in the task definition

Answer

Set SKIP_IF_EMPTY = TRUE in the CREATE TASK statement

Answer

Enable AUTO_SKIP on the stream object

Answer

Set STREAM_CONDITION = TRUE in task parameters