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.
These options are correct because:
Using a UTC-based schedule (Option A) avoids issues with daylight saving time changes as UTC does not observe daylight saving time.
Snowflake allows task schedules to follow specified or local time zones (Option B), which can accommodate daylight saving time changes by adjusting the schedule accordingly.
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."
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
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Want to SAVE BIG on Certification Exam Prep?
laksnarn
5 days, 19 hours agohillcat111
1 year agostarkbi
1 year agovictorleonis
1 year, 1 month agoAlachramkowa
1 year, 2 months agoh8er
2 months, 3 weeks ago