Question 1

For a particular business group, number of concurrent users are large but do not fluctuate. These users run queries on snowflake and expects extremely low latency response. The queries are all standard and same and need to be served from the result cache to meet the low latency requirement. Which of the below option will you choose?

Options :

A : Provision a multi-cluster warehouse and run it in maximized mode

B : Provision a multi-cluster warehouse and run it in economy mode

C : Provision a small warehouse and monitor the query overload metrics

Answer: A

Question 2

Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario?

Options :

A : TRUE

B : FALSE

C : UPDATE

D : INSERT

Answer: B

Question 3

When using the CURRENT_ROLE and CURRENT_USER functions with secure UDFs that will be shared with Snowflake accounts, Snowflake returns a NULL value for these functions?

Options :

A : TRUE

B : FALSE

Answer: A

Question 4

You have just created a table in snowflake. There are now rows in the table. What will be the clustering depth of the table?

Options :

A : 0

B : 1

C : 2

Answer: A

Question 5

Which is the non-supportable JavaScript UDF data types?

Options :

A : Integers

B : Integers

C : Binary

D : Double

Answer: A