The SnowPro Core exam (COF-C03) is a 100-question, 115-minute test that broadly covers Snowflake fundamentals. This article delivers carefully selected practice questions from the three highest-weighted domains (Architecture / Security / Data Transformation), with question patterns and key answer points explained for each one.
| Domain | Weight | Main Topics | Question Pattern |
|---|---|---|---|
| AI Data Cloud Features & Architecture | 25% | Three-layer architecture, caches, micro-partitions, editions | Knowledge questions on the differences between the 3 cache types, the role of each layer, and edition-specific features |
| Account Access & Security | 20% | RBAC, Network Policy, encryption, MFA | Scenario questions on roles directly under ACCOUNTADMIN and Network Policy precedence |
| Data Transformation | 20% | VARIANT type, FLATTEN, QUALIFY, UDFs | SQL knowledge questions on manipulating semi-structured data and the role of the QUALIFY clause |
| Performance Concepts | 15% | Warehouse design, scale-up vs scale-out, clustering keys | Judgement questions on improving concurrency and reading Query Profile |
| Data Movement | 10% | COPY INTO, Snowpipe, Stages | Knowledge questions on ON_ERROR option behavior and the Snowpipe billing model |
| Overview of Data Platform | 10% | Data Sharing, Marketplace, Replication | Knowledge questions on who pays for Reader Accounts and listing types |
Snowflake AI Data Cloud Features & Architecture (25%) is the highest-weighted domain on the exam. Make sure you understand the responsibilities of each layer in the three-tier architecture, the differences between the 3 cache types, and how micro-partitions work.
Architecture
問題 1
Which statement about Snowflake's 3 cache types is correct?
正解: 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 Access & Security domain (20%) tests the hierarchy of system-defined roles, how Network Policy works, and encryption schemes. The relationship between ACCOUNTADMIN, SYSADMIN, and SECURITYADMIN is a guaranteed topic.
Security
問題 2
When both account-level and user-level Network Policies are configured in Snowflake, which evaluation logic applies at connection time?
正解: 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 Overview of Data Transformation domain (20%) tests Snowflake-specific SQL features. Manipulating the VARIANT type, the FLATTEN function, and the QUALIFY clause are frequent topics on the Core exam.
Data Transformation
問題 3
Which statement correctly describes the role of Snowflake's QUALIFY clause?
正解: 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 (25%), the highest-weighted domain. Next, tackle Account Access & Security (20%) and Overview of Data Transformation (20%). These top 3 domains make up 65% of the exam, so locking them down is the fastest path to passing. Then cover the remaining domains — Performance Concepts (15%), Data Movement (10%), and Overview of Snowflake Cloud Data Platform (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 Core, Associate, 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
無料で問題を解いてみる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.
Snowflake Certifications: All 11 Exams Explained (2026)
Every SnowPro certification — Associate, Core, Specialty, Ad...
Snowflake Exam Difficulty Ranking: All 11 Certs Compared (2026)
All 11 SnowPro exams ranked by difficulty with study-time es...
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 — six domains, scope, sample ques...
SnowPro Associate Platform (SOL-C01): Complete Guide (2026)
The entry-level SnowPro Associate exam — scope, weighting, s...