SnowPro Core Recertification

Here you have the best Snowflake COF-R02 practice exam questions

You have 52 total questions to study from
Each page has 5 questions, making a total of 11 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on May 12, 2025
This site is not affiliated with or endorsed by Snowflake.

Question 1 of 52

By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

0 days

1 day

7 days

14 days

Correct Answer: B

Question 2 of 52

A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.

What will Snowflake do if the user's IP address does not match the user-level network policy rules?

Log the user out.

Deactivate the network policy.

Prevent the user from executing additional queries.

Allow the user to continue until the session or login token expires.

Correct Answer: C

Question 3 of 52

What happens to the privileges granted to Snowflake system-defined roles?

The privileges cannot be revoked.

The privileges can be revoked by an ACCOUNTADMIN.

The privileges can be revoked by an ORGADMIN.

The privileges can be revoked by any user-defined role with appropriate privileges.

Correct Answer: A

Question 4 of 52

Streams can be configured to query change data on which Snowflake objects? (Choose two.)

Pipe

Stage

Secure view

Materialized view

Shared table

Correct Answer: D, E

Streams in Snowflake can be configured to query change data on materialized views and shared tables. These are the objects which can persist changes and can be tracked over time, making them suitable for stream operations.

Question 5 of 52

Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

Area chart

Box plot

Heat grid

Pie chart

Correct Answer: C

Snowflake's Snowsight supports multiple data visualization options to create dashboards. Among the choices given, a 'Heat grid' chart is a supported type of visualization that is specifically suited to displaying data patterns and distributions in Snowsight. Area charts, box plots, and pie charts are common visualization types but are not specifically noted as being available in Snowsight for Snowflake users.