COF-C03: SnowPro Core Certification

By Snowflake · Browse Mode
About the Exam

Snowflake's foundational certification, covering the architecture and day-to-day use of the platform. It covers Snowflake's multi-cluster shared-data architecture, virtual warehouses and compute management, data loading and unloading, SQL and semi-structured data, account and object security, performance and cost concepts, and data sharing. Passing demonstrates a working knowledge of Snowflake across roles rather than deep specialisation.

Exam Topics

  • Snowflake AI Data Cloud Features & Architecture31%
  • Account Management & Data Governance20%
  • Data Loading, Unloading & Connectivity18%
  • Performance Optimization, Querying & Transformation21%
  • Data Collaboration10%

How to Use This Practice Exam

  1. Browse — Read each question, select your answer, and reveal the explanation.
  2. Exam Mode — Simulate real exam conditions with a timed session and score report.
  3. Learn Mode — Spaced repetition schedules questions you struggle with for long-term retention.

Download the Full Exam PDF

Get every question and answer in a clean, printable PDF built for offline study. Purchase once, keep permanent access, and re-download the latest version anytime.

Get PDF
Learn More

Last updated August 12, 2026 at 7:01 AM

Topic filter
Retired questions
Question sort
Questions per page

QuestionQ1

Data Collaboration

Which table type does Open Catalog support for providing centralized read and write access to a table?

Explanation

Snowflake Open Catalog is built for Apache Iceberg tables and provides centralized, secure read and write access to those tables across REST-compatible query engines.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ2

Data Loading, Unloading & Connectivity

What is one key distinction between the Snowflake CLI and SnowSQL?

Explanation

Snowflake CLI is designed for developer-centric workloads and can create, manage, update, and view Snowflake applications. SnowSQL is a legacy command-line client primarily used to connect to Snowflake and execute SQL queries and operations, including DDL and DML.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ3

Snowflake AI Data Cloud Features & Architecture

Which is the MINIMUM Snowflake edition required to apply 90 days of Time Travel to an object?

Explanation

Extended Snowflake Time Travel retention of up to 90 days requires Enterprise Edition or higher; Standard Edition permits only 0 or 1 day. Therefore, Enterprise is the minimum edition that supports a 90-day retention period.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ4

Data Loading, Unloading & Connectivity

A user is automating a data pipeline with the Snowflake CLI and must pass variables into SQL scripts.

Which variable-templating syntaxes does Snowflake CLI support?

Choose three
Explanation

Snowflake CLI supports STANDARD syntax (<% variable_name %>), LEGACY SnowSQL syntax (&{ variable_name } or &variable_name), and JINJA syntax ({{ variable_name }}). ALL and NONE configure which supported syntaxes are enabled; they are not variable syntaxes themselves.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ5

Snowflake AI Data Cloud Features & Architecture

Which services are managed in the Cloud Services layer?

Choose two
Explanation

Snowflake’s Cloud Services layer manages authentication and metadata management. Virtual warehouses provide the compute resources that process SQL statements, so query processing and virtual-warehouse hosting are not the matching Cloud Services-layer services. Snowflake key concepts and architecture

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!
Know a question that should be here? Contribute to this exam
Back home