SnowPro Core Streams and Tasks 3

Question 1

When using Serverless Tasks in Snowflake, which compute resource handles the execution?

Accepted Answer

Snowflake-managed compute that scales automatically based on workload

Answer

A user-defined virtual warehouse specified in the task

Answer

An external cloud function such as AWS Lambda or Azure Functions

Answer

The account's default X-Small warehouse shared across all serverless tasks

Question 2

Which ACCOUNT_USAGE view provides a full historical record of Snowflake Task execution runs?

Accepted Answer

SNOWFLAKE.ACCOUNT_USAGE.TASK_HISTORY

Answer

SNOWFLAKE.ACCOUNT_USAGE.TASK_LOG

Answer

SNOWFLAKE.ACCOUNT_USAGE.SCHEDULER_EVENTS

Answer

SNOWFLAKE.ACCOUNT_USAGE.TASK_RUNS

Question 3

What does the TASK_HISTORY() Information Schema table function return compared to the ACCOUNT_USAGE.TASK_HISTORY view?

Accepted Answer

Task runs within the last 7 days with lower latency than ACCOUNT_USAGE

Answer

DDL definitions for all tasks in the account

Answer

Credit consumption per task over a rolling 30-day window

Answer

The current execution state of all actively running tasks in real time

Question 4

What happens to child tasks in a DAG when the root task is suspended?

Accepted Answer

Child tasks are automatically suspended along with the root task

Answer

Child tasks continue running on independently scheduled intervals

Answer

Child tasks execute one final time and then stop permanently

Answer

Child tasks must be manually suspended one by one using ALTER TASK

Question 5

What is the key characteristic of an 'append-only' stream in Snowflake compared to a standard stream?

Accepted Answer

It tracks only INSERT operations and ignores UPDATE and DELETE changes

Answer

It captures only the final (post-image) state of updated rows without the pre-image

Answer

It retains change records for a longer period than a standard stream

Answer

It automatically deduplicates repeated inserts of the same row

Question 6

What does the SYSTEM$TASK_DEPENDENTS_ENABLE('<root_task>') function do in Snowflake?

Accepted Answer

Resumes the root task and all of its child tasks in the DAG simultaneously with one call

Answer

Validates that all task dependency configurations in the DAG are correctly formed

Answer

Creates dependency links between two previously independent tasks

Answer

Enables serverless compute for every task in the specified DAG

Question 7

Which practice ensures that stream data in a Snowflake pipeline is processed exactly once without risk of duplication on retry?

Accepted Answer

Consuming stream data inside a transaction — the offset advances only if the transaction commits successfully

Answer

Setting STREAM_DEDUP = TRUE on the CREATE TASK statement

Answer

Using SELECT DISTINCT in all queries that read from the stream

Answer

Enabling ENFORCE_ONCE = TRUE on the task to prevent parallel executions