Sure Pass Exam COF-C02 PDF

SnowPro Core Certification Exam (COF-C02) Questions and Answers

Question 17

A permanent table and temporary table have the same name, TBL1, in a schema.

What will happen if a user executes select * from TBL1 ;?

The temporary table will take precedence over the permanent table.

The permanent table will take precedence over the temporary table.

An error will say there cannot be two tables with the same name in a schema.

The table that was created most recently will take precedence over the older table.

Question 18

What are the least privileges needed to view and modify resource monitors? (Select TWO).

SELECT

OWNERSHIP

MONITOR

MODIFY

USAGE

Question 19

What happens when a Snowflake user changes the data retention period at the schema level?

All child objects will retain data for the new retention period.

All child objects that do not have an explicit retention period will automatically inherit the new retention period.

All child objects with an explicit retention period will be overridden with the new retention period.

All explicit child object retention periods will remain unchanged.

Question 20

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).

Bytes scanned

Partitions scanned

Bytes spilled to local storage

Bytes spilled to remote storage

Percentage scanned from cache