How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)
A . A task scheduled in a UTC-based schedule will have no issues with the time changes.
B . Task schedules can be designed to follow specified or local time zones to accommodate the time changes.
C . A task will move to a suspended state during the daylight savings time change.
D . A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.
E . A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

View Answer

Answer: A, B

Explanation:

According to the Snowflake documentation1 and the web search results2, these two statements are true about how the change of local time due to daylight savings time is handled in Snowflake tasks. A task is a feature that allows scheduling and executing SQL statements or stored procedures in Snowflake. A task can be scheduled using a cron expression that specifies the frequency and time zone of the task execution.

A task scheduled in a UTC-based schedule will have no issues with the time changes. UTC is a universal time standard that does not observe daylight savings time. Therefore, a task that uses UTC as the time zone will run at the same time throughout the year, regardless of the local time changes1.

Task schedules can be designed to follow specified or local time zones to accommodate the time changes. Snowflake supports using any valid IANA time zone identifier in the cron expression for a task. This allows the task to run according to the local time of the specified time zone, which may include daylight savings time adjustments. For example, a task that uses Europe/London as the time zone will run one hour earlier or later when the local time switches between GMT and BST12.

Reference: Snowflake Documentation: Scheduling Tasks

Snowflake Community: Do the timezones used in scheduling tasks in Snowflake adhere to daylight savings?