Exam DP-203 topic 2 question 111 discussion

1. two times 2. will automatically adjust "For time zones that observe daylight saving, trigger time will auto-adjust for the twice a year change, if the recurrence is set to Days or above. To opt out of the daylight saving change, please select a time zone that does not observe daylight saving, for instance UTC." https://learn.microsoft.com/en-us/azure/data-factory/how-to-create-schedule-trigger?tabs=data-factory#azure-data-factory-and-synapse-portal-experience

1. Two times (3am and 9pm) 2. Auto adjusts - as Microsoft documentation says for ADF "For time zones that observe daylight saving, trigger time auto-adjusts for the twice-a-year change, if the recurrence is set to Days or above. " https://learn.microsoft.com/en-us/azure/data-factory/how-to-create-schedule-trigger?tabs=data-factory"

The trigger will execute [answer choice] on Sunday, March 3, 2024: two times The trigger [answer choice] daylight saving time: will automatically adjust for

bing copilot: The trigger is set to execute at 3 AM and 9 PM Pacific Time on Sundays. However, on March 3, 2024, daylight saving time begins in the Pacific Time zone, moving the clock forward by one hour. So, the trigger will execute only one time on Sunday, March 3, 2024. The trigger operates in the Pacific Standard Time zone, which observes daylight saving time. However, the JSON file does not specify any adjustments for daylight saving time. Therefore, the trigger is unaffected by daylight saving time.

Two times. Will automatically adjust. or time zones that observe daylight saving, trigger time will auto-adjust for the twice a year change, if the recurrence is set to Days or above. To opt out of the daylight saving change, please select a time zone that does not observe daylight saving, for instance UTC Daylight saving adjustment only happens for trigger with recurrence set to Days or above. If the trigger is set to Hours or Minutes frequency, it will continue to fire at regular intervals.

1. two times 2. will automatically adjust

There's a catch here, as daylight savings actually starts on the SECOND Sunday of March, and March 3 2024 is before this date.

"[...] we are also adding support for Daylight Saving auto-adjustment: for time zones that observe Daylight Saving, auto change schedule trigger time twice a year (e.g. 8AM daily trigger will fire at 8AM, whether it's PST or PDT)" https://techcommunity.microsoft.com/t5/azure-data-factory-blog/time-zone-and-daylight-saving-support-for-schedule-trigger/ba-p/1840199

2nd answer should be : will require an adjustment for ref to : https://learn.microsoft.com/en-us/azure/data-factory/how-to-create-schedule-trigger?tabs=data-factory The timeZone element specifies the time zone that the trigger is created in. This setting affects both startTime and endTime.

Agree, as of 2020 ADF supports auto-adjustemt for Daylight Saving in Schedule Triggers for time zones that aren't UTC. Since here we are using Pacific time, answer seems correct. Source: https://techcommunity.microsoft.com/t5/azure-data-factory-blog/time-zone-and-daylight-saving-support-for-schedule-trigger/ba-p/1840199

Azure Data Factory only supports time zones UTC. I think should requiret the adjustment.