Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Get Unlimited Access

Snowflake Discussions

Exam SnowPro Advanced Architect topic 1 question 40 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 40
Topic #: 1

[All SnowPro Advanced Architect Questions]

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.

Show Suggested Answer

Suggested Answer: BD 🗳️

by Alachramkowa at April 29, 2023, 1:54 p.m.

Comments

Submit Cancel

hillcat111

10 months ago

Answer is A,E and is validated

upvoted 2 times

...

starkbi

10 months, 3 weeks ago

Selected Answer: AE

Against B: "A scheduled task runs according to the specified cron expression in the local time for a given time zone. Special care should be taken with regard to scheduling tasks for time zones that recognize daylight saving time. Tasks scheduled during specific times on days when the transition from standard time to daylight saving time (or the reverse) occurs can have unexpected behaviors."

upvoted 4 times

...

victorleonis

11 months, 1 week ago

Selected Answer: AB

I guess that is A, B

upvoted 3 times

...

Alachramkowa

1 year ago

https://docs.snowflake.com/en/user-guide/tasks-intro#task-scheduling-and-daylight-saving-time AE

upvoted 4 times

h8er

2 weeks, 3 days ago

This example provided in your link is below: "During the autumn change from daylight saving time to standard time, a task scheduled to start at 1 AM in the America/Los_Angeles time zone (i.e. 0 1 * * * America/Los_Angeles) would run twice: once at 1 AM and then again when 1:59:59 AM shifts to 1:00:00 AM local time. That is, there are two points in time when the local time is 1 AM." option E states "fail to handle" it is not failing to handle the task as it is executing it twice.

upvoted 1 times

...