Free COF-R02 Snowflake Updates

SnowPro Core Recertification Exam Questions and Answers

Question 13

In the Snowflake access control model, which entity owns an object by default?

The user who created the object

The SYSADMIN role

Ownership depends on the type of object

The role used to create the object

Question 14

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

PURGE

MODIFY

REMOVE

DELETE

Question 15

When loading data into Snowflake, how should the data be organized?

Into single files with 100-250 MB of compressed data per file

Into single files with 1-100 MB of compressed data per file

Into files of maximum size of 1 GB of compressed data per file

Into files of maximum size of 4 GB of compressed data per file

Question 16

Which SQL command can be used to see the CREATE definition of a masking policy?

SHOW MASKING POLICIES

DESCRIBE MASKING POLICY

GET_DDL

LIST MASKING POLICIES