Question 1

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

Options :

A : The primary cluster in the virtual warehouse

B : The entire virtual warehouse

C : The database in which the virtual warehouse resides

D : The Queries currently being run on the virtual warehouse

Answer: B

Question 2

What is the only supported character set for loading and unloading data from all supported file formats?

Options :

A : UTF-8

B : UTF-16

C : ISO-8859-1

D : WINDOWS-1253

Answer: A

Question 3

What would cause different results to be returned when running the same query twice?

Options :

A : SAMPLE is used and the seed is set

B : sample is used and the seed is not set.

C : Fraction-based sampling is used.

D : Fixed-size sampling Is used.

Answer: B

Question 4

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

Options :

A : Swift

B : JavaScript

C : Python

D : SQL

Answer: C

Question 5

While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

Options :

A : MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters

B : MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters

C : MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters

D : MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters

Answer: C