Question 1

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 2

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 3

What is the purpose of the use of the VALIDATE command?

Options :

A : To view any queries that encountered an error

B : To verify that a SELECT query will run without error

C : To prevent a put statement from running if an error occurs

D :

Answer: D

Question 4

A stream object will advance its offset when it is used in which statement?

Options :

A : SELECT

B : INSERT

C : CREATE

D :

Answer: B

Question 5

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

Higher Test Marks with Free Online COF-C02 Exam Practice