Online COF-R02 Questions Video

SnowPro Core Recertification Exam Questions and Answers

Question 37

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

Question 38

Which type of table corresponds to a single Snowflake session?

Temporary

Translent

Provisional

Permanent

Question 39

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

True

False

Question 40

Which of the following objects can be cloned? (Choose four.)

Tables

Named File Formats

Schemas

Databases

Users