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

Serverless Tasks use Snowflake-managed compute resources that scale automatically, so no virtual warehouse needs to be specified or paid for when the task is idle.

Question 2

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

Accepted Answer

SNOWFLAKE.ACCOUNT_USAGE.TASK_HISTORY

Answer

The SNOWFLAKE.ACCOUNT_USAGE.TASK_HISTORY view provides a historical record of task runs including scheduled time, completion time, state (SUCCEEDED/FAILED/SKIPPED), and error messages with up to a 365-day window.

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

The TASK_HISTORY() Information Schema table function returns task runs within the last 7 days with near-real-time latency, while ACCOUNT_USAGE.TASK_HISTORY has up to a 45-minute delay but covers a 365-day window.

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

Suspending a root task automatically suspends all child tasks in its DAG because child tasks have no independent schedule — they only run when triggered by their predecessor.

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

Append-only streams capture only INSERT operations, making them ideal for immutable log-style tables where you only need to process newly appended rows without tracking updates or deletes.

SnowPro Core Practice Test

SnowPro Core Practice Test

SnowPro Core Streams and Tasks 3