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.
| Domain | Weight | Main Topics | Question Pattern |
|---|---|---|---|
| Snowflake AI Data Cloud Features & Architecture | 31% | Three-layer architecture, editions, virtual warehouses, micro-partitions, UDFs / stored procedures | Knowledge and judgement questions on the role of each layer, edition-specific features, and how to improve concurrency |
| Account Management and Data Governance | 20% | RBAC, Network Policy, authentication (MFA etc.), encryption, masking, Resource Monitors | Scenario questions on roles directly under ACCOUNTADMIN and Network Policy precedence |
| Data Loading, Unloading, and Connectivity | 18% | COPY INTO, Stages, Snowpipe, Streams/Tasks, connectors | Knowledge questions on ON_ERROR option behavior and the Snowpipe billing model |
| Performance Optimization, Querying, and Transformation | 21% | Caches, Query Profile, clustering keys, VARIANT type, FLATTEN, QUALIFY | Questions on the differences between the 3 cache types, reading Query Profile, and the role of the QUALIFY clause |
| Data Collaboration | 10% | Data Sharing, Marketplace, Replication, Time Travel, cloning | Knowledge questions on who pays for Reader Accounts and listing types |
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?
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).
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?
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.
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?
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).
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.
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.
"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 →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
Practice with certification-focused question sets
Try free questionsNicheeLab Editorial Team
NicheeLab editorial team focused on data engineering and cloud certification learning. Content is structured around practical study needs and official exam domains.
Snowflake Certifications: All 11 Exams Explained (2026)
Every SnowPro certification on Snowflake's official list — C...
Snowflake Exam Difficulty Ranking: All 11 Certs Compared (2026)
All 11 SnowPro exams compared by difficulty in a ranking and...
Snowflake Study Guide: Fastest Pass Route by Exam (2026)
How to pass SnowPro certifications efficiently — official ma...
SnowPro Core (COF-C03): Complete Exam Guide (2026)
Pass the SnowPro Core exam — five domains, scope, sample que...
SnowPro Associate Platform (SOL-C01): Current Status & What to Take Next (2026)
As of October 2026, SnowPro Associate: Platform (SOL-C01) is...