SnowPro Core Recertification

By Snowflake · Browse Mode
About the Exam

SnowPro Core Recertification is the renewal path for people who already hold SnowPro Core and need to keep the credential current. Snowflake's certification policies state that Snowflake certifications expire after two years and can be renewed through the Continuing Education program. Passing demonstrates that the candidate has maintained current Snowflake core certification status and can keep the credential active for another renewal cycle.

Exam Topics

  • Data Engineering20%
  • Data Loading and Transformation20%
  • SQL20%
  • Data Protection20%
  • Account and Security20%

How to Use This Practice Exam

  1. Browse — Read each question, select your answer, and reveal the explanation.
  2. Exam Mode — Simulate real exam conditions with a timed session and score report.
  3. Learn Mode — Spaced repetition schedules questions you struggle with for long-term retention.

Download the Full Exam PDF

Get every question and answer in a clean, printable PDF built for offline study. Purchase once, keep permanent access, and re-download the latest version anytime.

Get PDF
Learn More

Last updated November 11, 2025 at 1:08 AM

Topic filter
Retired questions
Question sort
Questions per page

QuestionQ1

SQL

Streams can be configured to query change data on which Snowflake objects?

Choose two
Explanation

Snowflake supports streams on views, including secure views, and on standard tables, including shared tables. Streams do not track changes in materialized views; pipes and stages are not supported stream source objects.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ2

Data Loading and Transformation

Which chart type does Snowsight support for Snowflake users who visualize data with dashboards?

Explanation

Snowsight supports heat grids as a chart type. Dashboards visualize query results using Snowsight charts, so a heat grid can be used in that context.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ3

Account and Security

What does a Notify & Suspend action for a resource monitor do?

Explanation

A Notify & Suspend action notifies account administrators who have enabled notifications and suspends all assigned warehouses only after their currently executing statements have completed. It does not cancel active statements; immediate cancellation is the behavior of Notify & Suspend Immediately.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ4

Data Protection

In addition to completing all standard steps for sharing data, which privilege must be granted on every database referenced by a secure view in order to share it?

Explanation

Snowflake requires the REFERENCE_USAGE privilege on each database referenced by a secure view before the view can be granted to a share. The database containing the secure view instead receives the normal USAGE grant for the share.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ5

SQL

What types of subqueries does Snowflake support?

Choose two
Explanation

Snowflake supports uncorrelated scalar subqueries anywhere a value expression can be used. It also supports EXISTS, ANY / ALL, and IN subqueries in WHERE clauses, whether correlated or uncorrelated.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

That's the end of the preview

It's free

100% of the questions are free for all users.
No strings attached.

Sign up freeLog in
Topics covered
Data EngineeringData Loading and TransformationSQLData ProtectionAccount and Security
Know a question that should be here? Contribute to this exam
Back home