Snowflake COF-C03 Exam Questions Instant Access

Question 1

Where can file formats be specified when unloading data from Snowflake? Select TWO.

AIn a SELECT statement

BIn a CREATE STAGE statement

CIn a CREATE DATABASE statement

DIn a CREATE INTEGRATION statement

EIn a COPY INTO <location> statement

Answer : B, E

The correct answers are B. In a CREATE STAGE statement and E. In a COPY INTO <location> statement.

When unloading data from Snowflake, file format options can be specified directly in the COPY INTO <location> command or associated with a named stage. Defining the file format in a stage is useful when repeated loads or unloads use the same format settings.

Why B is correct:

A stage can include a file format definition or reference. When data is unloaded to that stage, the file format associated with the stage can be used.

Example:

CREATE STAGE my_stage

FILE_FORMAT = (TYPE = CSV FIELD_DELIMITER = ',');

COPY INTO @my_stage

FROM my_table;

Why E is correct:

The COPY INTO <location> command can specify file format options directly.

Example:

COPY INTO @my_stage/output/

FROM my_table

FILE_FORMAT = (TYPE = CSV COMPRESSION = GZIP);

Why the other options are incorrect:

A . A SELECT statement defines the query result to unload, but file format options are not specified as part of a normal SELECT.

C . A database definition does not define unload file format options.

D . An integration defines access to external services or storage, not the file format used for unloading.

Official Snowflake documentation reference:

Snowflake documentation explains that file format options can be specified in the COPY INTO <location> command or as part of a named stage definition.

Question 2

Which setting will help control credit consumption for a virtual warehouse that needs to run in Auto-scale mode?

ASet the warehouse scaling policy to ECONOMY.

BSet the MIN_CLUSTER_COUNT to 1.

CSet the AUTO_SUSPEND property of the warehouse to 0.

DSet the MIN_CLUSTER_COUNT to 2 and set the MAX_CLUSTER_COUNT to 2.

Answer : A

The correct answer is A. Set the warehouse scaling policy to ECONOMY.

A multi-cluster warehouse can use Auto-scale mode to add or remove clusters based on query concurrency. To help control credit consumption, Snowflake provides an Economy scaling policy.

Why A is correct:

The ECONOMY scaling policy is more conservative than the STANDARD scaling policy. It starts additional clusters only when Snowflake estimates there is enough query load to keep the new cluster busy for a meaningful amount of time. This helps reduce unnecessary cluster starts and can lower credit usage.

Why the other options are incorrect:

B . Setting MIN_CLUSTER_COUNT = 1 can help avoid running multiple clusters constantly, but it does not specifically control Auto-scale behavior as effectively as the Economy scaling policy.

C . Setting AUTO_SUSPEND = 0 disables automatic suspension, which can increase credit consumption.

D . Setting both minimum and maximum cluster count to 2 forces two clusters and removes Auto-scale flexibility. This can increase cost and does not control consumption efficiently.

Official Snowflake documentation reference:

Snowflake documentation explains that the Economy scaling policy conserves credits by starting additional clusters only when enough query load exists to justify them.

Question 3

When semi-structured data includes dates and timestamps as string values, what Snowflake recommendation will OPTIMIZE pruning and MINIMIZE storage consumption?

AStore the data as a VARIANT data type.

BStore the data as an ARRAY data type.

CStrip the outer array using TRY_PARSE_JSON.

DFlatten the key data into relational columns.

Answer : D

Question 4

A Snowflake user needs to optimize the definition of a secure view, but the user cannot see the view.

Which of the LEAST-PRIVILEGED access or role that should be granted to the user to complete this task?

AGrant the user the AYSADMIN role.

BGrant the user the ownership privilege on the secure view.

CGrant the user the imported privileges privilege on the database.

DGrant the user the SHOWFLAKE. object viewer database role.

Answer : D

Question 5

What action will change a customized schedule for a resource monitor back to the default schedule?

AChanging the monitoring frequency to the default value

BChanging the monitoring start timestamp to the default value

CDropping and re-creating the monitor

DCloning the monitor and then editing the cloned monitor schedule

Answer : C

Resource monitor schedules cannot be reset via update. The only way to restore the default schedule is to drop and recreate the monitor.

Snowflake Docs: Resource Monitor Scheduling

Question 6

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

AA single join node uses more than 50% of the query time

BPartitions scanned is equal to partitions total

CAn AggregateOperacor node is present

DThe query is spilling to remote storage

Answer : D

When a query in Snowflake is too large to fit into the available memory, it will start spilling to remote storage. This is an indication that the memory allocated for the query is insufficient for its execution, and as a result, Snowflake uses remote disk storage to handle the overflow. This spill to remote storage can lead to slower query performance due to the additional I/O operations required.

[COF-C03] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Query Profile1

Snowpro Core Certification Exam Flashcards2

Question 7

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

AVARIANT

BVARRAY

CSTRUCT

DARRAY

EQUEUE

Answer : A, D

Snowflake supports the VARIANT and ARRAY data types for semi-structured data. VARIANT can store values of any other type, including OBJECT and ARRAY, making it suitable for semi-structured data formats like JSON.ARRAY is used to store an ordered list of elements

Snowflake SnowPro Core Certification 2026 COF-C03 Exam Questions