SnowPro Core Recertification (COF-R02)

Here you have the best Snowflake SnowPro Core Recertification practice exam questions

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

Question 1 of 60

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 60

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 60

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 60

What is the default access of a securable object until other access is granted?

No access

Read access

Write access

Full access

Correct Answer: A

Question 5 of 60

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.