Snowflake SnowPro Core COF-C03 Exam Questions
SnowPro Core COF-C03 (Page 3 )

Updated On: 17-May-2026

What is a key difference between the Snowflake CLI and SnowSQL?

  1. SnowSQL is used for managing workloads and applications, while Snowflake CLI executes queries.
  2. Snowflake CLI is primarily used for managing workloads and applications, while SnowSQL is used for executing operations.
  3. SnowSQL supports only Data Definition Language (DDL) operations, while Snowflake CLI supports only Data Manipulation Language (DML) operations.
  4. Snowflake CLI only supports query execution, while SnowSQL manages Python packages.

Answer(s): B

Explanation:

The Snowflake CLI is designed for managing Snowflake resources, applications, and development workflows, while SnowSQL is a command-line client primarily used to execute SQL statements and perform database operations.



Which services are handled within the Cloud Services layer? (Choose two.)

  1. Authentication
  2. Query processing
  3. Secure socket
  4. Virtual warehouse hosting
  5. Metadata management

Answer(s): A,E

Explanation:

The Cloud Services layer is responsible for coordinating system-wide services such as authentication and access control, as well as managing metadata, which includes object definitions, query history, and optimization information.



A user is automating a data pipeline using the Snowflake CLI and needs to pass variables into SQL scripts.

Which variable templating syntaxes should be used? (Choose two.)

  1. STANDARD
  2. LEGACY
  3. JINJA
  4. NONE
  5. ALL

Answer(s): B,C

Explanation:

The Snowflake CLI supports variable templating using both legacy-style variables and Jinja templating, enabling dynamic parameterization of SQL scripts within automation workflows.



What is the MINIMUM Snowflake edition needed to apply 90 days of Time Travel to an object?

  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake (VPS)

Answer(s): B

Explanation:

Enterprise Edition supports extended Time Travel retention beyond the default limits, allowing up to 90 days for data recovery on supported objects.



Which objects can be recovered after being dropped? (Choose two.)

  1. View
  2. Transient table
  3. Temporary table
  4. Permanent table
  5. Materialized view

Answer(s): D,E

Explanation:

Permanent objects and materialized views support Time Travel and Fail-safe, allowing them to be recovered after being dropped within the retention period.



How does Snowflake support storage for external tables?

  1. Snowflake automatically replicates and stores all external table data.
  2. Snowflake stores the metadata from external tables.
  3. Snowflake references external tables using internal directory tables.
  4. Snowflake references external tables using internal transient tables.

Answer(s): B

Explanation:

Snowflake does not store the actual data of external tables; it stores only the metadata that defines the structure and location of the external data, which remains in external storage.



Which Snowflake features support the ability to write to a Git repository?

  1. Snowsight dashboards and stages
  2. Snowpipe and dynamic tables
  3. Stored procedures, tasks, and worksheets
  4. Streamlit applications, workspaces, and notebooks

Answer(s): D

Explanation:

Streamlit applications, workspaces, and notebooks are part of Snowflake's development environment that integrates with Git, allowing users to write, version, and synchronize code directly with a Git repository.



A Snowflake Practitioner is tasked with designing a data lakehouse architecture that requires:

1. Support for ACID transactions to ensure data consistency
2. The ability to evolve schemas over time without rewriting existing data
3. Efficient querying capabilities on large datasets

Which table type meets these requirements?

  1. Permanent
  2. Iceberg
  3. External
  4. Transient

Answer(s): B

Explanation:

Iceberg tables provide ACID transaction support, allow schema evolution without rewriting existing data, and enable efficient querying of large datasets stored in a lakehouse architecture.



Viewing page 3 of 14
Viewing questions 17 - 24 out of 100 questions


SnowPro Core COF-C03 Exam Discussions & Posts (Share your experience with others)

AI Tutor AI Tutor 👋 I’m here to help!