Snowflake Exam ARA-R01 Topic 3 Question 15 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 15
Topic #: 3

[All ARA-R01 Questions]

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

AA task scheduled in a UTC-based schedule will have no issues with the time changes.

BTask schedules can be designed to follow specified or local time zones to accommodate the time changes.

CA task will move to a suspended state during the daylight savings time change.

DA frequent task execution schedule like minutes may not cause a problem, but will affect the task history.

EA task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

Show Suggested Answer

Suggested Answer: D

When a new table (table_6) is added to a schema in the provider's account that is part of a data share, the consumer will not automatically see the new table. The consumer will only be able to access the new table once the appropriate privileges are granted by the provider. The correct process, as outlined in option D, involves using the provider's ACCOUNTADMIN role to grant USAGE privileges on the database and schema, followed by SELECT privileges on the new table, specifically to the share that includes the consumer's database. This ensures that the consumer account can access the new table under the established data sharing setup. Reference:

Snowflake Documentation on Managing Access Control

Snowflake Documentation on Data Sharing

by Vincenza at Aug 04, 2024, 09:11 PM

Limited Time Offer

25%

Off

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Desiree

1 months ago

I'm going with A and B. Gotta love that Snowflake flexibility when it comes to time zones and daylight savings. No need to stress about the clocks changing.

upvoted 0 times

...

Abel

1 months ago

Haha, I bet the 'frequent task execution' option is a trap. Like, 'oh, you thought that would work? Nope, still affects the history!'

upvoted 0 times

...

Gerald

1 months ago

C and E seem like the wrong answers. Tasks shouldn't suspend or fail to handle time changes, that would be a major limitation.

upvoted 0 times

Laurel

4 days ago

B) Task schedules can be designed to follow specified or local time zones to accommodate the time changes.

upvoted 0 times

...

Kristine

15 days ago

A) A task scheduled in a UTC-based schedule will have no issues with the time changes.

upvoted 0 times

...

3 months ago

I think option B is correct because tasks can be scheduled based on local time zones.

upvoted 0 times

...