Snowflake

Snowflake Core Practice Questions: Domain-by-Domain Drills and Explanations

2026-03-21
Updated: 2026-10-12
NicheeLab Editorial Team
Table of contents
  1. Question Patterns by Domain
  2. Architecture Practice Question
  3. Security Practice Question
  4. Data Transformation Practice Question
  5. Study Strategy by Domain
  6. Answering Techniques
  7. Frequently Asked Questions

The SnowPro Core exam (COF-C03) is a 100-question, 115-minute test that broadly covers Snowflake fundamentals across five domains. This article delivers carefully selected practice questions centered on the three highest-weighted domains (Architecture / Performance Optimization, Querying, and Transformation / Account Management and Data Governance), with question patterns and key answer points explained for each one.

Question Patterns by Domain

DomainWeightMain TopicsQuestion Pattern
Snowflake AI Data Cloud Features & Architecture31%Three-layer architecture, editions, virtual warehouses, micro-partitions, UDFs / stored proceduresKnowledge and judgement questions on the role of each layer, edition-specific features, and how to improve concurrency
Account Management and Data Governance20%RBAC, Network Policy, authentication (MFA etc.), encryption, masking, Resource MonitorsScenario questions on roles directly under ACCOUNTADMIN and Network Policy precedence
Data Loading, Unloading, and Connectivity18%COPY INTO, Stages, Snowpipe, Streams/Tasks, connectorsKnowledge questions on ON_ERROR option behavior and the Snowpipe billing model
Performance Optimization, Querying, and Transformation21%Caches, Query Profile, clustering keys, VARIANT type, FLATTEN, QUALIFYQuestions on the differences between the 3 cache types, reading Query Profile, and the role of the QUALIFY clause
Data Collaboration10%Data Sharing, Marketplace, Replication, Time Travel, cloningKnowledge questions on who pays for Reader Accounts and listing types

Architecture Practice Question

Snowflake AI Data Cloud Features & Architecture (31%) is the highest-weighted domain on the exam. Make sure you understand the responsibilities of each layer in the three-tier architecture, how micro-partitions work, and how the editions differ. Caching itself is listed under the Performance Optimization, Querying, and Transformation domain, but the question below asks which layer each cache lives in, so it rests on your grasp of the architecture.

Architecture

Question 1

Which statement about Snowflake's 3 cache types is correct?

  1. Metadata Cache is stored on each Virtual Warehouse's local SSD and is cleared when the Warehouse is suspended
  2. Result Cache retains the result of an identical query for 24 hours, and if the underlying data has not changed, it returns the result without starting a Warehouse
  3. Warehouse Cache is stored in the Cloud Services Layer and is shared across all Warehouses in the account
  4. Result Cache is only valid while the Warehouse is running, and is cleared when the Warehouse is suspended

Correct answer: B

Snowflake has 3 cache types. Result Cache is managed by the Cloud Services Layer and caches identical query results for 24 hours. If the underlying data has not changed, it returns the result instantly without starting a Warehouse, consuming zero compute credits (B). Metadata Cache is also managed by the Cloud Services Layer and holds statistics like table row counts and MIN/MAX values (A is wrong: it lives in the Cloud Services Layer, not on local SSD). Warehouse Cache caches data in the Compute Layer (on each Warehouse's local SSD) and is cleared when the Warehouse is suspended (C is wrong: it is per-Warehouse and not shared; D is wrong: it describes Warehouse Cache, not Result Cache).

Security Practice Question

The Account Management and Data Governance domain (20%) tests the hierarchy of system-defined roles, how Network Policy works, and encryption schemes, along with governance and cost-management features such as masking and Resource Monitors. The relationship between ACCOUNTADMIN, SYSADMIN, and SECURITYADMIN is a guaranteed topic.

Security

Question 2

When both account-level and user-level Network Policies are configured in Snowflake, which evaluation logic applies at connection time?

  1. The account-level setting always takes precedence, and the user-level setting is ignored
  2. The user-level setting takes precedence over the account-level setting
  3. The UNION of both settings' ALLOWED_IP_LIST is applied
  4. The INTERSECT of both settings' ALLOWED_IP_LIST is applied

Correct answer: B

In Snowflake's Network Policy, user-level settings take precedence over account-level settings. If a user has a Network Policy assigned, only the user-level Network Policy applies to that user's connections, and the account-level setting is ignored (it is not a UNION or INTERSECT). Users without a user-level setting fall back to the account-level Network Policy. This design lets you apply different network rules to specific remote workers or external consultants than the account-wide IP restrictions.

Data Transformation Practice Question

The Performance Optimization, Querying, and Transformation domain (21%) tests query performance tuning along with data transformation using Snowflake-specific SQL features. Manipulating the VARIANT type, the FLATTEN function, and the QUALIFY clause are frequent topics on the Core exam.

Data Transformation

Question 3

Which statement correctly describes the role of Snowflake's QUALIFY clause?

  1. Filters the results of a GROUP BY clause, used as an alternative to HAVING
  2. Filters the results of window functions (such as ROW_NUMBER or RANK) directly
  3. Specifies JOIN conditions, used as an alternative to the ON clause
  4. Applies filter conditions to a CTE's result set

Correct answer: B

QUALIFY is a Snowflake-specific SQL extension that filters window function results directly. Normally, filtering on window function results requires a subquery or CTE, but QUALIFY lets you do it in a single SELECT statement. For example, to get the top 3 sales per department, you can write: SELECT *, ROW_NUMBER() OVER (PARTITION BY dept ORDER BY sales DESC) rn FROM sales_table QUALIFY rn <= 3. The SQL execution order is WHERE → GROUP BY → HAVING → WINDOW → QUALIFY, so QUALIFY is applied after window function computation. HAVING filters GROUP BY results and does not work with window functions (A is wrong).

Study Strategy by Domain

Architecture (31%) - Top Priority

  • Memorize the responsibilities of each layer in the three-tier architecture (Storage / Compute / Cloud Services)
  • Understand the characteristics of micro-partitions (50-500 MB, columnar, automatically managed)
  • Build a feature diff table across editions (Standard / Enterprise / Business Critical / VPS)
  • When to scale up (faster individual queries) vs scale out (better concurrency)
  • Tabulate the differences between UDFs and Stored Procedures (how they are called, whether they can run DDL, their permission models)

Performance Optimization, Querying, and Transformation (21%) - High Priority

  • Map out the 3 cache types (Result / Metadata / Warehouse) by storage location, TTL, and whether they consume credits
  • Practice manipulating the VARIANT type in actual SQL (dot notation, bracket notation, FLATTEN)
  • Get comfortable with QUALIFY, LATERAL FLATTEN, and PARSE_JSON
  • When to set clustering keys (TB-scale tables, frequently filtered columns)
  • How to read Spill and partition pruning in Query Profile

Account Management and Data Governance (20%) - High Priority

  • Memorize the 5 system-defined role hierarchy (ACCOUNTADMIN → SYSADMIN / SECURITYADMIN → USERADMIN → PUBLIC)
  • Understand the user-level precedence rule for Network Policy
  • Map encryption schemes (AES-256, automatic key rotation, Tri-Secret Secure) to their corresponding editions

Data Loading, Unloading, and Connectivity (18%) - Medium Priority

  • Sort out COPY INTO file formats and ON_ERROR options, and when to use internal vs external stages
  • Understand how automated ingestion differs across Snowpipe, Snowpipe Streaming, Streams/Tasks, and Dynamic Tables
  • Get familiar with how external connectivity works: drivers, connectors, and storage integrations

Data Collaboration (10%) - Medium Priority

  • Sort out the roles of providers, consumers, and reader accounts in Secure Data Sharing, and who pays for reader accounts
  • Know the Snowflake Marketplace and how private and public listings differ
  • Understand how Time Travel, Fail-safe, cloning, and replication and failover work, and when to use each

Answering Techniques

Time Allocation

100 questions in 115 minutes works out to about 70 seconds per question. If a question is unclear after 30 seconds of thought, flag it and skip. A solid strategy: answer 80+ questions in the first pass, then come back for flagged questions on the second pass.

Process of Elimination

A common pattern: eliminate two clearly wrong choices from the four options and decide between the remaining two. Absolute language like "in all editions," "always," or "only" tends to mark wrong answers.

Multiple-Response Questions

"Select 2" or "Select 3" questions explicitly state how many answers you need to pick. Since you know the correct count, process of elimination becomes especially effective.

Try more practice questions

Drill every SnowPro Core domain comprehensively with the NicheeLab question bank

Try free questions →

Frequently Asked Questions

How many questions are on the SnowPro Core exam and what is the time limit?

SnowPro Core (COF-C03) is a 100-question, 115-minute exam. That works out to about 70 seconds per question, so time management is critical for passing. The passing score is 750/1000, and aiming for 80%+ correct gives you a safe margin. Practice the strategy of flagging tough questions, skipping them, and returning later.

Which domain should I study first?

Start with Snowflake AI Data Cloud Features & Architecture (31%), the highest-weighted domain. Next, tackle Performance Optimization, Querying, and Transformation (21%) and Account Management and Data Governance (20%). These top 3 domains make up 72% of the exam, so locking them down is the fastest path to passing. Then cover the remaining domains — Data Loading, Unloading, and Connectivity (18%) and Data Collaboration (10%) — proportional to their weights.

Can I pass without hands-on experience?

Yes, you can pass SnowPro Core without real-world Snowflake experience. Spin up the free 30-day Snowflake trial and get hands-on (CREATE TABLE, COPY INTO, creating Virtual Warehouses, inspecting Query Profile), read the official documentation for concepts, and drill question banks. Repeat that cycle for 2-3 months and you can reach pass territory. If you already have hands-on Snowflake experience, 1-2 months of study is usually enough.

Related SnowPro Core Articles

SnowPro Core Exam: Complete Guide

Full coverage of exam scope, sample questions, and pass strategy

Snowflake Exam Sample Questions

Sample questions for the Core and Advanced levels

How to Study for Snowflake Certifications

Fastest path to passing and study-time estimates

Free Snowflake Question Bank

Bilingual practice questions you can try for free

Check what you learned with practice questions

Practice with certification-focused question sets

Try free questions
Author

NicheeLab Editorial Team

NicheeLab editorial team focused on data engineering and cloud certification learning. Content is structured around practical study needs and official exam domains.


Related articles
Snowflake

Snowflake Certifications: All 11 Exams Explained (2026)

Every SnowPro certification on Snowflake's official list — C...

Snowflake

Snowflake Exam Difficulty Ranking: All 11 Certs Compared (2026)

All 11 SnowPro exams compared by difficulty in a ranking and...

Snowflake

Snowflake Study Guide: Fastest Pass Route by Exam (2026)

How to pass SnowPro certifications efficiently — official ma...

Snowflake

SnowPro Core (COF-C03): Complete Exam Guide (2026)

Pass the SnowPro Core exam — five domains, scope, sample que...

Snowflake

SnowPro Associate Platform (SOL-C01): Current Status & What to Take Next (2026)

As of October 2026, SnowPro Associate: Platform (SOL-C01) is...

Browse all Snowflake articles (103)
© 2026 NicheeLab All rights reserved.