[Sep 14, 2025] New Real COF-C02 Exam Dumps Questions [Q403-Q427]

QUESTION 403
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

True

False

QUESTION 404
Which statements are true concerning Snowflake’s underlying cloud infrastructure? (Select THREE),

Snowflake data and services are deployed in a single availability zone within a cloud provider’s region.

Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

Snowflake can be deployed in a customer’s private cloud using the customer’s own compute and storage resources for Snowflake compute and storage

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

All three layers of Snowflake’s architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

Snowflake data and services are deployed in at least three availability zones within a cloud provider’s region

QUESTION 405
What is the MOST performant file format for loading data in Snowflake?

CSV (Unzipped)

Parquet

CSV (Gzipped)

ORC

QUESTION 406
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake.
The user enables the strip__outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?

It removes the last element of the outer array.

It removes the outer array structure and loads the records into separate table rows,

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

QUESTION 407
A user wants to upload a file to an internal Snowflake stage using a put command.
Which tools and or connectors could be used to execute this command? (Select TWO).

SnowCD

SnowSQL

SQL API

Python connector

Snowsight worksheets

QUESTION 408
Which of the following describes the Snowflake Cloud Services layer?

Coordinates activities in the Snowflake account

Executes queries submitted by the Snowflake account users

Manages quotas on the Snowflake account storage

Manages the virtual warehouse cache to speed up queries

QUESTION 409
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Standard

Premium

Enterprise

Business Critical

QUESTION 410
Which SQL statement will require a virtual warehouse to run?

SELECT COUNT{*) FROM TBL_EMPLOYEE;

ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);

INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,’Adam*,20000,* Finance’);

CREATE OR REPLACE TABLE TBL_EMPLOYEE (EMP_ID NUMBER,EMP_NAME VARCHAR(30),EMP_SALARY NUMBER, DEPT VARCHAR{20));

QUESTION 411
Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)

Range searches

Equality searches

Substring searches

Queries with IN predicates

Queries with aggregation

QUESTION 412
When creating a virtual warehouse in Snowsight using a create warehouse statement, which properties are enabled by default? (Select TWO).

ENABLE_QUERY_ACCELERATTON

INITIALLY_SUSPENDED

RES0URCE_M0NTTOR

AUTO_RESUME

AUTO_SUSPEND

QUESTION 413
Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

PURGE

MODIFY

REMOVE

DELETE

QUESTION 414
What are the main differences between the account usage views and the information schema views? (Select TWO).

No active warehouse to needed to query account usage views but one is needed to query information schema views.

Account usage views do not contain data about tables but information schema views do.

Account issue views contain dropped objects but information schema views do not.

Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

Information schema views are read-only but account usage views are not.

QUESTION 415
A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

QUESTION 416
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

The columns that are queried in the select clause.

The columns with very high cardinality.

The columns with many different values.

The columns most actively used in the select filters.

QUESTION 417
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Object-level access control

Column-level security to apply data masking policies to tables and views

QUESTION 418
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

SELECT SUM (ORDER_AMT) FROM SALES;

SELECT AVG(ORDER_QTY) FROM SALES;

SELECT MIN(ORDER_AMT) FROM SALES;

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

QUESTION 419
How can a Snowflake user access a JSON object, given the following table? (Select TWO).

src:salesperson.name

src:sa1esPerson. name

src:salesperson.Name

SRC:salesperson.name

SRC:salesperson.Name

QUESTION 420
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

A user cannot specify a default warehouse when using the ODBC driver.

The default virtual warehouse size can be changed at any time.

QUESTION 421
What can a user win a reader account do in Snowflake?

Load now data

Update existing data

Create a new snare

Query shared data

QUESTION 422
The Snowflake Search Optimization Services supports improved performance of which kind of query?

Queries against large tables where frequent DML occurs

Queries against tables larger than 1 TB

Selective point lookup queries

Queries against a subset of columns in a table

QUESTION 423
What object does Snowflake recommend using when planning to unload similarly-formatted data on a regular basis?

Stream

Task

Storage integration

Named file format

QUESTION 424
Which role must be used to create resource monitors?

SECURITYADMIN

ACCOUNTADMIN

SYSADMIN

ORGADMIN

QUESTION 425
Which Snowflake object can be used to record DML changes made to a table?

Snowpipe

Stage

Stream

Task

QUESTION 426
What transformations are supported in a CREATE PIPE … AS COPY … FROM (….) statement? (Select TWO.)

Data can be filtered by an optional where clause

Incoming data can be joined with other tables

Columns can be reordered

Columns can be omitted

Row level access can be defined

QUESTION 427
The effects of query pruning can be observed by evaluating which statistics? (Select TWO).

Partitions scanned

Partitions total

Bytes scanned

Bytes read from result

Bytes written

Leave a Reply Cancel reply