Snowflake · SF-CORE · Intermediate

SnowPro Core Certification (COF-C03) — Practice Questions and Mock Exam

Name: Pass-IT
Author: Pass-IT

The SnowPro Core Certification (COF-C03) validates a solid understanding of Snowflake's AI Data Cloud platform, including its architecture, virtual warehouses, data loading and transformation, semi-structured and unstructured data handling, performance optimization, data protection, and secure data sharing.

Practice for free Try a practice question first

Try a practice question first Practice for free

Start practicing SF-CORE free Buy SF-CORE access for $29.99

100Questions per Pass-IT mock exam

115minPass-IT mock exam time limit

Official SF-CORE exam: 750 out of 1000 points to pass.

Checked against Snowflake · August 2026 · Current exam version

Try Pass-IT

See what learning with Pass-IT is like.

Answer a SF-CORE sample question and read the explanation with its source. Right here, with no sign-up.

Data Collaboration1 / 5

What is the purpose of Cross-Cloud Auto-Fulfillment in Snowflake?

AlexFull explanation from Alex

Cross-Cloud Auto-Fulfillment automatically replicates a provider's data products (listings) to Snowflake regions where consumers request access, eliminating manual replication setup. Replication occurs on-demand only when consumer demand exists. The option “To automatically migrate all objects…” is wrong — auto-fulfillment handles data product replication, not full account migration between cloud providers. The option “To synchronize user accounts and access control roles across…” describes cross-account role synchronization, handled by replication groups, not auto-fulfillment. The option “To convert data formats between the storage systems used…” describes data format conversion, which is unrelated to this feature. Ref: docs.snowflake.com/en/collaboration/provider-listings-auto-fulfillment

Sourcedocs.snowflake.com

Account Management and Data Governance4 / 5

Which Snowflake object allows administrators to restrict access to the Snowflake service based on user IP addresses?

AlexFull explanation from Alex

Network policies control inbound access to Snowflake by specifying allowed and blocked IP addresses via CIDR notation. They can be applied at account level (ALTER ACCOUNT), user level (ALTER USER), or security integration level. When multiple levels apply, the most restrictive policy takes precedence. SECURITYADMIN or higher can create and manage them. The option “Resource monitor” (Resource monitor) controls credit consumption, not IP access. The option “Security integration” (Security integration) manages external authentication (OAuth, SCIM), not IP filtering. The option “Firewall rule” (Firewall rule) is not a Snowflake object type. Ref: docs.snowflake.com/en/user-guide/network-policies

Sourcedocs.snowflake.com

Create a free account

How to prepare for SF-CORE with Pass-IT.

Currently 340 practice questions for SF-CORE, with new ones added regularly. Focus on what you still need to learn.

Get past difficult questions.

Understand why an answer is correct. Alex explains the concepts and answers your follow-up questions so you can apply what you learn to the next task.

Meet Alex →

Try the available questions in the preview above.

Make your study time count.

Practice at your level.
For new practice sessions, Pass-IT adjusts the difficulty based on your previous answers.

Learn from mistakes.
Incorrect answers automatically become flashcards. When you review them, you rate how confidently you remember; Pass-IT schedules the next review.

See how focused practice works →

Try the available questions in the preview above.

Practice for the moment that counts.

Take a full mock exam with a time limit and find out whether you can finish in time.

Your SF-CORE mock exam

Questions: 100
Minutes: 115

Illustration of an exam session

Start
Answer questions
Finish

Length and time limit of the Pass-IT mock exam.

Go into your exam with more confidence.

Your Readiness Score helps you assess whether you are ready for the exam. Results by exam domain show you where you should keep practicing.

Your money back if you fail despite 80% Readiness.
If your Readiness Score is at least 80% when you take the exam and you still fail, we refund the Pass-IT purchase price for this certification.

For active, paid access. Submit proof of failing within 14 days.

Further guarantee conditions

You need at least 80% Readiness and active, paid access to the certification when you take the exam. Take the exam within your access period and submit official proof of failing within 14 days after the exam.

For purchases through Apple or Google, refunds are handled by the respective store. See the full terms for further details.

Read the guarantee terms →

The Readiness Score describes your practice progress, not a probability of passing.

Guarantee requirement

80%

At least 80% Readiness
when you take the exam

Money back if you fail

Question counts and mock exam settings from the current Pass-IT catalog.

Exam domains

What you practice for SF-CORE.

Exam topics, relevant practice and sources you can check.

Understand the Snowflake platformSee the guide for weighting105 QuestionsPass-IT questions

Connect Snowflake’s architecture to the tools and resources you use.

Explain the cloud services, compute and storage layers, compare editions, and work with Snowsight, Snowflake CLI and IDE integrations.
Navigate organizations, accounts and database objects, including stages, functions, procedures, pipes, models and applications; apply session context and parameter precedence.
Choose warehouse types, sizes and scaling policies for loading, reporting, concurrency and complex queries, with suitable auto-suspend settings.
Explain micro-partitions and clustering, and choose permanent, temporary, transient, Iceberg, external or dynamic tables and standard, materialized or secure views.
Recognize how Notebooks, Streamlit, Snowpark, Cortex AI SQL, Search, Analyst and Snowflake ML support applications and AI workloads.

Official Snowflake objectives

Secure and govern an accountSee the guide for weighting69 QuestionsPass-IT questions

Control access, protect data and keep track of consumption.

Explain RBAC and DAC, object and role hierarchies, secondary roles and account identifiers; combine network policies, authentication methods and logging to control access.
Use masking, row and column security, tags, privacy policies, encryption keys, Trust Center, alerts, lineage and replication or failover to protect and govern data.
Calculate warehouse credit use and monitor costs and activity with resource monitors and ACCOUNT_USAGE.

Official Snowflake objectives

Load data and connect toolsSee the guide for weighting57 QuestionsPass-IT questions

Move data into and out of Snowflake and connect the systems that use it.

Define file formats, internal or external stages, encryption and directory tables, then load or unload with COPY INTO and handle errors.
Automate ingestion with Snowpipe, Snowpipe Streaming, streams, tasks and dynamic tables, and explain Openflow’s role in ingestion.
Choose drivers, connectors and storage, API or Git integrations for the connection you need.

Official Snowflake objectives

Query and transform efficientlySee the guide for weighting75 QuestionsPass-IT questions

Find the cause of slow queries and choose suitable transformations.

Use Query Profile, query insights and ACCOUNT_USAGE history or attribution to diagnose spilling, poor pruning, exploding joins and queueing; group similar workloads.
Choose query acceleration, search optimization, clustering keys or materialized views for the performance problem.
Distinguish result, metadata and warehouse caches and their effects on repeated work.
Transform structured, semi-structured and unstructured data with SQL, aggregate and window functions, and query optimization techniques.

Official Snowflake objectives

Collaborate with dataSee the guide for weighting34 QuestionsPass-IT questions

Share data with the right consumers while retaining recovery options.

Explain how replication, failover, cloning, Time Travel and Fail-safe support data protection and collaboration.
Distinguish providers, consumers and reader accounts, then use secure direct shares, resharing and Data Clean Rooms appropriately.
Use private or public Marketplace listings and Native Apps to distribute data and applications.

Official Snowflake objectives

Question formats you can practice

Multiple Choice: Select one answer.
Multiple Response: Select multiple applicable answers.

These are Pass-IT practice formats. Check the Snowflake certification page for the official exam information.

How we review questions

Source check: The answer, answer options and explanation are checked against official documentation. We call this canonical validation.

Adversarial review: An additional AI reviewer specifically looks for factual errors, ambiguous answers and weaknesses in the explanation.

Learning objectives: We count specific exam topics with clearly linked exercises. Subheadings are not counted separately.

The figures refer to available questions in each SF-CORE exam domain. The additional review count includes matching review logs for the current question version, even if errors were found. It is not an error-free rate.

The date shows the latest matching evidence or log entry in each domain. An import or transfer of an existing review result can update this entry. This does not mean the entire question pool has been reviewed again.

Review methods and criteria in detail

Frequently asked questions

Your preparation

How much study time should I plan for SF-CORE?

For planning, Pass-IT estimates roughly 35–90 hours. Relevant experience may put you toward the lower end; starting from scratch may put you toward the higher end. Your needs may fall outside this range. This is not a time requirement from Snowflake or a promise that you will be exam-ready within that time.

What do you need before SnowPro Core?

Nothing formal. Snowflake recommends six or more months of experience using the platform, and the catalog budget is around 60 hours. That is the shortest budget in the SnowPro range, because every other exam assumes this material rather than teaching it.

Using Pass-IT

What language are Pass-IT questions in?

Questions in the app are currently in English. Translations of the sample questions on this page apply only to this preview. Check with Snowflake for the languages available for the official exam.

How long does my SF-CORE access last?

Access covers this certification for 12 months. You pay once, with no automatic renewal.

When does the money-back guarantee apply?

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days. Guarantee terms

About the SF-CORE exam

Where can I take the SF-CORE exam?

Online proctored or onsite testing centers.

How long is the SnowPro Core Certification (COF-C03) exam?

The SnowPro Core Certification (COF-C03) exam has 100 questions and a 115-minute time limit.

How do you get Snowflake certified?

SnowPro Core is the entry point and the only Snowflake exam with no certification prerequisite. It runs 100 questions in 115 minutes, and Snowflake recommends six or more months of hands-on use rather than a formal background. Every advanced SnowPro exam requires this one first, so it is the gate to the rest of the range.

How long does SnowPro Core stay valid?

Two years from the certification issue date. You recertify through the Snowflake continuing-education programme, either by completing an eligible instructor-led training course or by earning an equivalent or higher SnowPro certification. The programme requires a valid certification to take part, so letting it lapse closes that route.

How many times can you retake SnowPro Core?

For SnowPro Core, you are limited to four attempts in total at the same exam in any 12-month period. You must wait seven days between all attempts, including before your first retake.

Your preparation for SF-CORE

$29.99one-time

12 months of access for SF-CORE · No automatic renewal

Buy SF-CORE access

Questions in the app are currently in English.

Try 20 questions for freeFree account required. No credit card.

Already have an account? Log in

Prefer a subscription? View subscriptions →

Money back if you fail with at least 80% Readiness, for eligible purchases under the guarantee terms.

Guarantee terms

Full guarantee terms →