Snowflake · COF-C03
SnowPro Core Certification (COF-C03) Practice Tests
Validates hands-on expertise with the Snowflake AI Data Cloud, covering architecture, data loading, performance optimization, governance, and data collaboration. Designed for data engineers, DBAs, and cloud professionals working with Snowflake.
Exam Details
Practice Questions
592
≈ 5 practice exams
Duration
115 minutes
Passing Score
750/1000
Difficulty
AssociateLast Updated
May 2026
Topics Covered
Snowflake AI Data Cloud Features and ArchitectureAccount Management and Data GovernanceData Loading, Unloading, and ConnectivityPerformance Optimization, Querying, and TransformationData Collaboration
SnowPro Core Certification (COF-C03) Practice Exam Preparation
Use this COF-C03 practice exam to prepare for SnowPro Core Certification (COF-C03) with realistic questions, detailed explanations, and focused study modes. The practice bank includes 592 questions for Snowflake COF-C03, so you can review the exam steadily instead of relying on one long cram session.
As you practice, pay extra attention to recurring topics such as Snowflake AI Data Cloud Features and Architecture, Account Management and Data Governance, Data Loading, Unloading, and Connectivity, Performance Optimization, Querying, and Transformation, and Data Collaboration. Start with short sessions to identify weak areas, then move into timed quizzes once your accuracy is consistent.
The explanations are especially useful when you want to connect exam wording to the responsibilities and scenarios described in the official certification guidance. Use the free preview first, then unlock the full question bank when you are ready to build a complete study routine.
Exam Domain Breakdown
Snowflake AI Data Cloud Features and Architecture31%
Account Management and Data Governance20%
Data Loading, Unloading, and Connectivity18%
Performance Optimization, Querying, and Transformation21%
Data Collaboration10%
Exam Overview
The SnowPro Core Certification (COF-C03) is Snowflake's foundational technical credential, validating practical, hands-on expertise with the Snowflake AI Data Cloud. It covers the full breadth of Snowflake's platform: its unique multi-cluster, shared-data architecture that separates storage, compute, and cloud services; account and virtual warehouse management; structured, semi-structured, and unstructured data handling; performance monitoring and optimization; Role-Based Access Control (RBAC) and data governance; and secure data collaboration and sharing.
The COF-C03 version launched on February 16, 2026, replacing the retired COF-C02 exam. A key update in this version is an expanded emphasis on Snowflake's AI and ML capabilities, including Cortex AI, Snowpark, Iceberg tables, Notebooks, and Git integration — reflecting Snowflake's strategic evolution toward AI-driven data workflows. The certification is valid for two calendar years from the date of passing.
Who Should Take This Exam
The SnowPro Core Certification is designed for data engineers, database administrators, cloud architects, data analysts, and BI professionals who work with Snowflake in a hands-on capacity. It is particularly well-suited for professionals who build and maintain data pipelines, manage Snowflake accounts, optimize query performance, or implement data governance policies on the platform.
Snowflake recommends candidates have at least six months of practical experience with Snowflake before attempting the exam. This means the certification is appropriate for working professionals with meaningful platform exposure rather than those entirely new to cloud data warehousing. It also serves as a prerequisite stepping stone toward Snowflake's advanced certifications, including SnowPro Advanced: Data Engineer, Administrator, and Architect.
Prerequisites
There are no formal prerequisites required to register for the COF-C03 exam. However, Snowflake strongly recommends that candidates have a minimum of six months of hands-on experience working with the Snowflake platform before sitting for the exam, as questions are scenario-based and require applied knowledge rather than theoretical recall.
Candidates should be comfortable with SQL fundamentals, core cloud computing concepts (particularly as they apply to one or more of AWS, Azure, or GCP), and key Snowflake constructs such as virtual warehouses, stages, file formats, micro-partitions, and the COPY INTO command. Familiarity with data loading patterns (including Snowpipe for continuous ingestion), RBAC security models, and Snowflake's data sharing and collaboration features is also expected.
Exam Format
The COF-C03 exam consists of approximately 100 questions in multiple-choice and multiple-select formats. Candidates have 115 minutes to complete the exam. The exam is delivered in a proctored environment through Pearson VUE, available as either an online proctored session (via OnVUE) or at a physical Pearson VUE testing center.
Scoring uses a scaled score system with a maximum of 1,000 points; the minimum passing score is 750 out of 1,000 (75%). The exam costs $175 USD per attempt. The certification remains valid for two calendar years, after which candidates must recertify to maintain their status.
Skills Measured
- 1.Domain 1 — Snowflake AI Data Cloud Features and Architecture (31%): Covers Snowflake's multi-cluster, shared-data architecture including the separation of storage, compute, and cloud services layers. Topics include virtual warehouses, micro-partitions, data caching (result cache, local disk cache, remote disk cache), clustering keys, Snowflake editions, supported cloud platforms, and AI/ML capabilities such as Cortex AI, Snowpark, Iceberg tables, Notebooks, and Git integration.
- 2.Domain 2 — Account Management and Data Governance (20%): Covers Snowflake account configuration, resource monitors, virtual warehouse sizing and scaling policies, Role-Based Access Control (RBAC), user and role management, network policies, encryption, data masking, row access policies, object tagging, and compliance features supporting data governance frameworks.
- 3.Domain 3 — Data Loading, Unloading, and Connectivity (18%): Covers methods for ingesting data into and exporting data from Snowflake, including the COPY INTO command, internal and external stages, file format objects, Snowpipe for continuous/event-driven ingestion, Kafka and cloud storage connectors, Snowflake connectors for Python, Spark, JDBC/ODBC, and SnowSQL CLI.
- 4.Domain 4 — Performance Optimization, Querying, and Transformation (21%): Covers query profiling with the Query Profile tool, use of clustering and search optimization, warehouse sizing and multi-cluster warehouse configuration, result caching, materialized views, streams, tasks, stored procedures, Snowpark for data transformation in Python/Java/Scala, and interpreting EXPLAIN plans.
- 5.Domain 5 — Data Collaboration (10%): Covers Snowflake's data sharing capabilities including secure data shares, the Snowflake Marketplace, Data Clean Rooms, listing and consuming shared datasets, reader accounts, and collaboration models that allow sharing live data without copying or moving it.
Study Tips
- Download and thoroughly review the official COF-C03 Exam Study Guide from learn.snowflake.com — it outlines all five domains, their exact percentage weights, and the specific objectives tested, making it the single most authoritative preparation resource.
- Enroll in Snowflake University's 'SnowPro Core Certification Preparation' course and the 'Level Up: SnowPro Core' series, both available free on learn.snowflake.com, as they are purpose-built for this exam and cover the full domain blueprint.
- Activate a free Snowflake trial account and practice hands-on with COPY INTO, Snowpipe, virtual warehouse scaling, RBAC role hierarchies, and data sharing — the exam is scenario-based and rewards applied knowledge over rote memorization.
- Since Domain 1 (Architecture, 31%) and Domain 4 (Performance, 21%) together account for more than half the exam, prioritize understanding Snowflake's three-layer architecture, micro-partition internals, caching tiers, and query profiling with the Query Profile tool.
- Pay special attention to new COF-C03 topics not covered in COF-C02: Cortex AI functions, Snowflake Notebooks, Iceberg table support, and Git integration — these reflect Snowflake's AI Data Cloud positioning and are explicitly added to the updated exam.
- Use Snowflake's official documentation as your reference for precise command syntax, especially for COPY INTO options, file format parameters, stage types, resource monitor configurations, and warehouse properties — the exam tests specific parameter knowledge.
- Simulate exam conditions by taking timed practice tests under 115 minutes with the exam interface disabled; focus on eliminating incorrect multiple-select answers carefully, as partial credit is not awarded for multi-select questions.
Career Benefits
The SnowPro Core Certification is widely recognized as the foundational credential for data professionals working on the Snowflake platform, which has become one of the most widely adopted cloud data platforms across industries. Certified professionals qualify for roles including Snowflake Data Engineer, Cloud Data Architect, BI Engineer, Data Platform Consultant, and Solutions Engineer — roles that frequently list the SnowPro Core as a required or preferred qualification on job postings.
As of 2026, mid-level Snowflake data engineers typically earn $110,000–$140,000 annually, with senior engineers commanding $140,000–$180,000 base salaries, and contract rates ranging from $95–$135 per hour. Certification holders report salary increases of 20–40% compared to non-certified peers. The SnowPro Core also serves as the gateway to Snowflake's advanced-tier certifications (priced at $375 per attempt), including SnowPro Advanced: Data Engineer, Architect, and Administrator, which unlock higher-compensation specialist roles. Complementary skills in dbt, Snowpark, Python, Terraform, and AWS further amplify the market value of this certification.
Sample Questions
5 sample questions with answers and explanations. The full bank has 592 questions, enough for 5 full-length practice exams.
Preview — answers shown1. A developer at Northwind Finance uses Okta as the identity provider, configured via a SAML2 security integration in Snowflake. The developer's internal Snowflake account password expired 30 days ago. Today, the developer attempts to log in to Snowflake using the Okta SSO flow. The Okta session is active and the SAML assertion is valid. What is the expected outcome? (Select one!)
AAuthentication succeeds, but the developer is immediately redirected to reset the internal password before any data can be queried.
BAuthentication succeeds because SAML2 federated SSO bypasses all internal Snowflake password requirements when the IdP assertion is valid.
CAuthentication fails because an expired internal Snowflake password blocks SSO login regardless of the validity of the SAML assertion.
DAuthentication fails because the SAML2 security integration must be re-enrolled whenever a user's internal password expires.
Explanation
In Snowflake, an expired internal account password blocks SSO login even when the SAML assertion from the IdP is valid and the federation is correctly configured. This is intentional security behavior — Snowflake evaluates internal user account state before processing the external SAML authentication. The same behavior applies when a user has MUST_CHANGE_PASSWORD set to TRUE. The developer must have an administrator reset their Snowflake internal password before SSO access is restored. The SAML2 security integration does not need to be re-enrolled when passwords expire, and Snowflake does not provide a mid-session password reset redirect during the SSO flow. This design prevents a scenario where an IdP compromise alone could grant access to an account whose internal credentials are in an invalid state.
2. A data engineer at Fabrikam Corp builds a change data capture pipeline using a Snowflake stream called INVENTORY_STREAM on the INVENTORY table. They schedule a task to process new records but want the task to skip execution and avoid consuming warehouse compute credits when no unconsumed changes exist in the stream. What should the engineer include in the task definition to implement this conditional execution behavior? (Select one!)
AA WHEN clause containing STREAM_NOT_EMPTY('INVENTORY_STREAM') as the boolean condition
BA WHEN clause containing SYSTEM$STREAM_HAS_DATA('INVENTORY_STREAM') as the boolean condition
CA separate pre-check task that runs SELECT COUNT(*) FROM INVENTORY_STREAM and calls the processing task only when the count exceeds zero
DSetting the task property SKIP_IF_NO_DATA = TRUE in the CREATE TASK statement
Explanation
The SYSTEM$STREAM_HAS_DATA() system function returns TRUE when the specified stream contains unconsumed change records and FALSE when it does not. When included in a task's WHEN clause, Snowflake evaluates this condition before attempting to execute the task body. If the condition returns FALSE, the task skips the current scheduled run entirely without consuming any warehouse compute credits. This is the documented and recommended pattern for building efficient event-driven CDC pipelines in Snowflake. STREAM_NOT_EMPTY() is not a valid Snowflake function and will produce an error. A pre-check task using SELECT COUNT(*) still consumes compute credits for the count query itself and requires additional orchestration logic to conditionally trigger the downstream task. There is no SKIP_IF_NO_DATA property available on Snowflake task objects; the WHEN clause with SYSTEM$STREAM_HAS_DATA is the correct and only built-in mechanism for stream-conditional task execution.
3. A security architect at Contoso Cloud Services needs to configure Snowflake so that only connections originating from a specific AWS VPC endpoint are permitted. The organization routes all Snowflake traffic through a single AWS PrivateLink endpoint identified by its VPCE ID, and wants to block all connections that do not arrive through this endpoint. The VPCE ID cannot be mapped to a stable private IP address range. Which approach should the security architect use? (Select one!)
ACreate a network policy with the ALLOWED_IP_LIST parameter populated with the private IP ranges associated with the VPC endpoint subnet
BConfigure a SAML2 security integration restricted to the identity provider endpoint hosted within the organization's VPC
CDefine an authentication policy that limits allowed authentication methods to key-pair authentication for users connecting from non-internet sources
DCreate a network rule with NETWORK_RULE_TYPE = AWSVPCEID specifying the VPCE ID, then reference the rule in an account-level network policy
Explanation
Network rules extend Snowflake's access control model beyond IP address filtering by supporting network identifiers such as AWS VPC endpoint IDs, Azure Private Link resource IDs, and GCP Private Service Connect endpoint IDs. A network rule defines the set of identifiers to match, and a network policy references one or more network rules to enforce the restriction at the account or user level. Legacy network policies only support IP address ranges via ALLOWED_IP_LIST and BLOCKED_IP_LIST, which is inadequate when a VPCE ID cannot be resolved to a stable IP range. A SAML2 security integration configures federated authentication with an identity provider and operates at the authentication layer, not the network connectivity layer. Authentication policies govern credential type requirements such as MFA enforcement and allowed authentication methods but do not filter connections based on network origin or VPC endpoint identity.
4. A data engineering team at Northwind Pipeline Corp is evaluating when to use a Snowflake stored procedure versus a user-defined function (UDF) for different automation tasks. Which TWO statements correctly describe characteristics that are unique to stored procedures and distinguish them from UDFs in Snowflake? (Select two!)
Multiple correct answersAStored procedures can execute DML statements such as INSERT, UPDATE, and DELETE within their body
BStored procedures can be invoked inline within a SELECT statement as part of a query expression
CStored procedures return a scalar value or table result that can be referenced directly in SQL column expressions
DStored procedures support transaction control statements, allowing explicit COMMIT and ROLLBACK logic within the procedure body
EStored procedures are the only Snowflake object type that supports Python as an implementation language
Explanation
Stored procedures in Snowflake are designed for procedural, server-side logic and administrative automation. They can execute DML statements — including INSERT, UPDATE, DELETE, and MERGE — as well as DDL statements within their body, which UDFs are explicitly prohibited from doing. Stored procedures also support transaction control: they can issue COMMIT and ROLLBACK statements and manage their own transaction boundaries, enabling complex multi-step data operations with controlled atomicity. UDFs are query-time functions intended to return a value for each input row; they are called inline within SQL expressions in SELECT, WHERE, or FROM clauses and cannot contain DML or transaction control. Stored procedures cannot be called inline within a SELECT statement — they must be invoked using the CALL statement. Both UDFs and stored procedures support Python, Java, Scala, and JavaScript as implementation languages, so Python support is not a distinguishing characteristic of stored procedures.
5. A DevOps engineer at Tailspin Systems needs to rotate the RSA private key used by a service account that connects to Snowflake 24/7 using key-pair authentication. The rotation must occur without any interruption to the running service's connectivity. What should the engineer do? (Select one!)
AGenerate a new RSA key pair, set RSA_PUBLIC_KEY on the user account, and immediately revoke the old key using ALTER USER ... UNSET RSA_PUBLIC_KEY
BCreate a new Snowflake service user, assign the new public key to it, update the service connection string, then deactivate the old user
CGenerate a new RSA key pair and overwrite RSA_PUBLIC_KEY on the user — the service will continue using the old private key until it reconnects
DGenerate a new RSA key pair, assign the new public key to RSA_PUBLIC_KEY_2 on the user, update the service to use the new private key, then remove the old key from RSA_PUBLIC_KEY
Explanation
Snowflake supports two simultaneously active public keys on a user object — RSA_PUBLIC_KEY and RSA_PUBLIC_KEY_2 — specifically designed for zero-downtime key rotation. By assigning the new public key to RSA_PUBLIC_KEY_2 while the service continues authenticating with the existing key stored in RSA_PUBLIC_KEY, the engineer can update the service configuration to use the new private key, verify connectivity, and then safely remove the old key from RSA_PUBLIC_KEY. Immediately revoking or overwriting the currently active public key before updating the service breaks authentication and causes a service interruption. Creating a new Snowflake user is unnecessary and adds administrative overhead without solving the rotation challenge.
More Snowflake Practice Exams
SnowPro Advanced: Administrator (ADA-C02)
ADA-C02 · 600 questions
SnowPro Advanced: Data Analyst (DAA-C01)
DAA-C01 · 600 questions
SnowPro Specialty: Gen AI (GES-C01)
GES-C01 · 600 questions
SnowPro Specialty: Native Apps (NAS-C01)
NAS-C01 · 600 questions
SnowPro® Advanced: Data Scientist (DSA-C03)
DSA-C03 · 600 questions
SnowPro® Specialty: Snowpark (SPS-C01)
SPS-C01 · 599 questions
$17.99
One-time access to this exam
592 questions (5 practice exams' worth)
Unlimited timed exam simulations
Or $15/mo for all 253 exams
Detailed explanations
Free preview stays available