Before you sit for a Snowflake (SnowPro) certification exam, knowing what the actual questions look like is the fastest route to passing. This article walks through sample questions for each question format, centered on the Core and Advanced levels, with detailed answer explanations (we also keep one question from Platform Associate, which can no longer be booked, as a check on the basics).
Understand the strategy for multiple-choice, multiple-select, and SQL syntax questions, and use these problems to benchmark your readiness for the real exam.
| Format | Share (our estimate) | Characteristics | Strategy |
|---|---|---|---|
| Multiple Choice | ~70% | Exactly one correct answer | Eliminate down to two options |
| Multiple Select | ~30% | Number of correct answers is stated | Lock in the sure-thing options first |
| Interactive (ordering, matching, etc.) | Not used on Core | Appears on some Advanced exams; answered by drag-and-drop and similar | Know the order of steps and which feature does what |
SnowPro Core (COF-C03) is a 100-question exam covering Snowflake architecture, security, performance, and data protection broadly. Use the three sample questions below to get a feel for the style.
Core - Architecture
Question 1
Which functions are handled by the Cloud Services Layer in Snowflake's three-layer architecture? (Select 2)
Correct answer: A, C
The Cloud Services Layer is Snowflake's "brain" — it handles query parsing, optimization, and metadata management (A), plus authentication, RBAC, and access control (C). Option B (physical data storage) belongs to the Storage Layer (micro-partitions on cloud object storage). Option D (query compute) belongs to the Compute Layer (Virtual Warehouses). Cloud Services usage is not billed as long as it stays within 10% of that day's virtual warehouse usage; only the portion above that is billed.
Core - Virtual Warehouse
Question 2
Which statement about Snowflake multi-cluster Warehouses is correct?
Correct answer: B
In Auto-scaling mode, a multi-cluster Warehouse automatically scales out when queries queue up and scales back in when query load drops (B is correct). This solves the concurrency problem. Option A is wrong: multi-cluster Warehouses require Enterprise Edition or above. Option C is also wrong: more clusters increase concurrency capacity, but to speed up an individual query you scale up the Warehouse size. In Maximized mode (option D), the configured number of clusters start, but the Warehouse's auto-suspend setting still applies — so they don't necessarily run nonstop.
Core - Time Travel
Question 3
Which SQL correctly uses Snowflake Time Travel to query the "sales" table as of 30 days ago?
Correct answer: B
Time Travel uses the AT or BEFORE clause to specify a past point in time. For a timestamp-based query you use AT(TIMESTAMP => <timestamp>), and you compute the 30-days-ago timestamp with DATEADD(day, -30, CURRENT_TIMESTAMP()) — so B is correct. Option A's OFFSET is the difference from the current time in seconds, so -30 means 30 seconds ago (for 30 days you would convert to seconds, for example -30*24*60*60). Option C's "DAYS => 30" is not valid Time Travel syntax. Option D's "TRAVEL TO" simply doesn't exist in Snowflake. To access data from 30 days ago you also need Enterprise Edition or above with DATA_RETENTION_TIME_IN_DAYS set to 30 or more.
Platform Associate (SOL-C01) was an entry-level exam on Snowflake's core concepts. Its last published format was 65 questions in 85 minutes, but as of October 2026 it is no longer on Snowflake's official exam list and cannot be scheduled through Pearson VUE. We keep this question here as a check on the basics.
Associate - Role Hierarchy
Question 4
Among Snowflake's system-defined roles, which one has the broadest privileges and manages the entire account?
Correct answer: C
ACCOUNTADMIN sits at the top of Snowflake's system-defined role hierarchy and inherits the privileges of both SYSADMIN and SECURITYADMIN. It can manage databases, Warehouses, users, roles, and all security settings. SYSADMIN is focused on creating and managing databases and Warehouses, SECURITYADMIN on managing roles, privileges, and user security, and USERADMIN on creating users and roles. Snowflake best practice is to minimize day-to-day use of ACCOUNTADMIN and rely on SYSADMIN or custom roles instead.
SnowPro Advanced: Architect is a senior-level exam testing deep knowledge of architecture design, optimization, and governance. Passing SnowPro Core is a prerequisite, and the exam requires you to make design decisions and evaluate trade-offs.
Advanced Architect - Data Sharing Design
Question 5
What is the most appropriate design for sharing data via Secure Data Sharing with an external partner who does not have a Snowflake account?
Correct answer: B
When sharing data with an external partner who has no Snowflake account, a Reader Account is the right design. A Reader Account is created and managed by the data provider, and the partner can run SQL queries against the shared data with no Snowflake contract of their own. Compute costs for the Reader Account are borne by the provider. File export (A) is inferior to Secure Data Sharing on freshness and security. Forcing the partner onto an Enterprise contract (C) imposes unnecessary cost. A public listing (D) is inappropriate for a targeted share to a specific partner.
SnowPro exams also include questions that test precise knowledge of SQL syntax. COPY INTO, FLATTEN, GRANT/REVOKE, and semi-structured data processing syntax come up frequently.
SQL - FLATTEN & Semi-Structured Data
Question 6
Which SQL correctly expands a JSON array stored in the VARIANT column "data" into rows? Table: events (id INT, data VARIANT) data column: [{"type":"click","page":"home"},{"type":"view","page":"product"}]
Correct answer: A
To expand a VARIANT array or object into rows in Snowflake, you combine the FLATTEN function with the TABLE function. TABLE(FLATTEN(input => data)) expands the array into rows, and each expanded element is accessed via f.value. Accessing JSON keys with colon notation (f.value:type) is Snowflake-specific syntax. UNNEST is a PostgreSQL/BigQuery function (B), EXPLODE is a Spark SQL function (C), and JSON_EXTRACT is a MySQL/BigQuery function (D) — none of them work in Snowflake. In Snowflake you access semi-structured data with colon notation or the GET_PATH function.
Single-choice SnowPro questions usually contain one or two obviously wrong options. Eliminate the clearly wrong choices first — "available on Standard Edition" (when it actually requires Enterprise or above) or "this syntax doesn't exist" — then decide between the two remaining options. Accurate knowledge of edition restrictions is a powerful weapon for elimination.
Build and memorize a feature-by-edition matrix: Time Travel retention (Standard: 1 day / Enterprise+: 90 days), multi-cluster Warehouses (Enterprise+), Column-level Security (Enterprise+), Tri-Secret Secure (Business Critical+), AWS PrivateLink (Business Critical+), and so on. With this in hand, you can instantly judge many questions correct or incorrect.
SnowPro questions sometimes have multiple technically correct options. When that happens, pick the answer that best aligns with Snowflake best practices. For example, "create a Warehouse as ACCOUNTADMIN" and "create a Warehouse as SYSADMIN" are both possible, but the principle of least privilege makes SYSADMIN the right answer.
The Core exam is 100 questions in 115 minutes — about 70 seconds per question. Flag uncertain questions and skip them immediately: pass 1 covers every question (60-70 min), pass 2 returns to flagged questions (30-40 min), and the final 10 minutes are for review. Advanced exams give you more time per question at 65 questions in 115 minutes (about 106 seconds each), but make sure you still leave time to review.
What question formats appear on Snowflake exams?
SnowPro Core (COF-C03) uses two question formats: Multiple Choice (one correct answer) and Multiple Select (Select 2 / Select 3). Snowflake does not publish how many of each appear; by this site's estimate, Multiple Choice is about 70% of the test and Multiple Select about 30%. Some Advanced exams also include Interactive questions, where you answer by ordering or matching items. Unlike Databricks exams, the share of code-reading questions is low; the focus is on conceptual understanding, architecture comparisons, and best-practice judgement. That said, COPY INTO, CREATE STAGE, GRANT/REVOKE, and Time Travel syntax is tested through questions such as picking the correct SQL statement, so you still need to memorize it exactly.
Can I pass using only sample questions?
Passing with sample questions alone is difficult. They are useful for getting a feel for the format and finding weak domains, but SnowPro Core covers 5 domains across 100 questions — a scope that 5-15 sample questions can't fully cover. To pass, you need a well-rounded plan: conceptual study with the official Snowflake docs, hands-on practice with the 30-day free trial, and repeated drilling through a 200-400 question bank. Use sample questions as the entry point to your study, not the entire study.
Are the number of correct answers shown for multiple-select questions?
Yes — the sample questions in the official Study Guides state the number of correct answers in the prompt, such as "(Select TWO)" or "(Select THREE)." Snowflake does not publish whether partial credit is given, so aim to get every required choice right. Snowflake also does not publish the share of multiple-select questions on SnowPro Core, but by this site's estimate it is about 30%, so getting comfortable with this format directly affects your pass/fail outcome. Use process of elimination — rule out clearly wrong options first, then choose from what remains.
Want to try more questions?
The NicheeLab question bank lets you feel the question style across every domain
Try free questions →Related Snowflake Certification Articles
SnowPro Core: Complete Guide
Deep dive into the 100-question scope and pass strategy
Platform Associate: Complete Guide
SOL-C01's current status and exam content (no longer bookable)
Snowflake Exam Pass Rates
How the 750-point passing score works
80 Essential Snowflake Terms
Key exam terms organized by category
Practice with certification-focused question sets
Try free practice 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...