Question 1

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

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.

Answer: A,B

Question 2

For authentication, snowflake Kafka connector relies on:

Options :

A : key pair authentication

B :

username/password

C : Both key pair authentication and username/password

Answer: A

Question 3

Where can you define the file format settings?

Options :

A : While creating named file formats

B : In the table definition

C : In the named stage definition

D : Directly in the COPY INTO TABLE statement when loading data

Answer: A,B,C,D

Question 4

Which of the below objects cannot be replicated?

Options :

A : Resource Monitors

B : Warehouses

C : Users

D : Databases

E : Shares

F : Roles

Answer: A,B,C

Question 5

What is the meaning of “Processing” in the query profiler menu when running a query?

Options :

A : The time when the processing was waiting for the network data transfer.

B : The time spent on data processing by the CPU.

C : The time when the processing was blocked by local disk access.

Answer: B

Higher Test Marks with Free Online SnowPro-Advanced-Architect Exam Practice