SnowPro Advanced: Architect — Question 30

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

Answer options

• 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.

Correct answer: A, E

Explanation

Option A is correct because tasks scheduled in UTC are unaffected by daylight saving time changes. Option E is also correct as it indicates that tasks will strictly adhere to the set schedule without accounting for any potential overlaps or omissions in time caused by daylight saving adjustments. Options B, C, and D are incorrect as they suggest varying behaviors that do not align with how Snowflake manages time changes.