Question 1

Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?

Options :

A : Alerts

B : External tables

C : Secure views

D : Materialized views

Answer: A

Question 2

How can unstructured data be processed in a Snowflake stage? (Select TWO).

Options :

A : Use a SQL procedure.

B : Use external functions.

C : Use a C# procedure.

D : Implement a Golang (Go) User-Defined Function (UDF).

E : Implement a Python User-Defined Function (UDF).

Answer: B

Question 3

What is included in the calculation of the execution time reported in a Query Profile? (Select TWO).

Options :

A : Pruning

B : Local disk IO

C : Processing

D : Caching

E : Spilling

Answer: C,E

Question 4

When cloning a schema, which Snowflake object will not be included in the clone?

Options :

A : An external stage

B : A named internal stage

C : A task

D : A User-Defined Function (UDF)

Answer: A

Question 5

How does Snowflake reorganize data when it is loaded? (Select TWO).

Options :

A : Binary format

B : Columnar format

C : Compressed format

D : Raw format

E : Zipped format

Answer: B,C

Free COF-C02 Mock Exam – Practice Online Confidently