Question 1

Which items are considered schema objects in Snowflake? (Select TWO).

Options :

A : Pipe

B : File format

C : Resource monitor

D : Storage integration

E : Virtual warehouse

Answer: A,B

Question 2

What is cached during a query on a virtual warehouse?

Options :

A : All columns in a micro-partition

B : Any columns accessed during the query

C : The columns in the result set of the query

D : All rows accessed during the query

Answer: C

Question 3

True or False: Snowpipe via REST API can only reference External Stages as source.

Options :

A : True

B : False

Answer: B

Question 4

A Snowflake user accidentally deleted a table. The table no longer exists, but the session is within the data retention period. How can the table be restored using the LEAST amount of operational overhead?

Options :

A : Clone the table schema as it existed before the table was dropped.

B : Clone the database as it existed before the table was dropped.

C : Recreate the table and reload the data.

D : Run the UNDROP command against the table.

Answer: D

Question 5

What is the purpose of an External Function?

Options :

A : To call code that executes outside of Snowflake

B : To run a function in another Snowflake database

C : To share data in Snowflake with external parties

D : To ingest data from on-premises data sources

Answer: A

Free COF-C02 Mock Exam – Practice Online Confidently

Buying Options: