COF-R02 Snowflake Exam Lab Questions

SnowPro Core Recertification Exam Questions and Answers

Question 21

When is the result set cache no longer available? (Select TWO)

When another warehouse is used to execute the query

When another user executes the query

When the underlying data has changed

When the warehouse used to execute the query is suspended

When it has been 24 hours since the last query

Question 22

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An AggregateOperacor node is present

The query is spilling to remote storage

Question 23

Which data type can be used to store geospatial data in Snowflake?

Variant

Object

Geometry

Geography

Question 24

What is a limitation of a Materialized View?

A Materialized View cannot support any aggregate functions

A Materialized View can only reference up to two tables

A Materialized View cannot be joined with other tables

A Materialized View cannot be defined with a JOIN