How does Snowflake handle timezone for task schedules?

Tasks always run in UTC regardless of the timezone setting

The timezone can be specified using the TIMEZONE parameter in the CREATE TASK statement

The timezone is derived from the session timezone of the user who created the task

Tasks do not support timezone configuration; they always use the account's default timezone

What is the correct way to consume a stream within a task to avoid reprocessing?

Use a SELECT statement to read the stream without any DML

Use a DML statement (INSERT, MERGE, etc.) that reads from the stream

Use a TRUNCATE statement on the stream

Use a CREATE TABLE AS SELECT (CTAS) statement to copy the stream data

What is the primary purpose of a stream in Snowflake?

To provide a read-only snapshot of a table at a point in time

To replicate data to another Snowflake account for disaster recovery

To store historical data for long-term retention

To capture change data (inserts, updates, deletes) on a table since the last transaction

A team has a task DAG with three tasks: T1, T2, and T3. T1 is scheduled, T2 depends on T1, and T3 depends on T2. They want to ensure that if T2 fails, T3 does not run, but they also want T1 to continue running on its schedule. What is the best way to handle this?

Set T2's SUSPEND_TASK_AFTER_FAILURE to TRUE to prevent T3 from running.

Set T3 to run independently with its own schedule to ensure it always runs.

Use a stored procedure in T2 to catch errors and manually run T3.

Leave the DAG as is; T3 will not run if T2 fails, and T1 will continue on its schedule.

SnowflakeSnowPro Advanced — Architect

Domain 3Objective 2

Implement Streams and Tasks ARA-C01 Practice Questions (Page 1)

Part of the Data Engineering domain, which accounts for 24% of the ARA-C01 exam.

24questions here

5free pages

9concepts

24%of the exam

Questions 1–5

1foundation · easy
How does Snowflake handle timezone for task schedules?
Select an answer first
2foundation · easy
What is the correct way to consume a stream within a task to avoid reprocessing?
Select an answer first
3foundation · easy
What is the primary purpose of a stream in Snowflake?
Select an answer first
4expert · hard
A team has a task DAG with three tasks: T1, T2, and T3. T1 is scheduled, T2 depends on T1, and T3 depends on T2. They want to ensure that if T2 fails, T3 does not run, but they also want T1 to continue running on its schedule. What is the best way to handle this?
Select an answer first
5foundation · easy
Which stream type records only INSERT operations and excludes updates and deletes?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to ARA-C01

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “ARA-C01” is a trademark of its owner, used for identification only.