Question 1

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Options :

A : Informatica

B : Power Bl

C : Adobe

D : Data Robot

Answer: D

Question 2

True or False: Data Providers can share data with only the Data Consumer.

Options :

A : True

B : False

Answer: B

Question 3

What affects whether the query results cache can be used?

Options :

A : If the query contains a deterministic function

B : If the virtual warehouse has been suspended

C : If the referenced data in the table has changed

D : If multiple users are using the same virtual warehouse

Answer: B

Question 4

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

Options :

A : The Pipe load history is reset to empty.

B : The REFRESH command is executed.

C : The stage will be purged.

D : The destination table is truncated.

Answer: B

Question 5

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

Options :

A : The validation_mode option is used when creating an Internal Stage

B : validation_mode=return_all_errors is a parameter of the copy command

C : The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

D : The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Answer: D

Free COF-R02 Mock Exam – Practice Online Confidently

Buying Options: