COF-C02 Online Practice Questions and Answers

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

A. CSV (Unzipped)

B. Parquet

C. CSV (Gzipped)

D. ORC

What happens when a virtual warehouse is resized?

A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

D. Users who are trying to use the warehouse will receive an error message until the resizing is complete

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

A. Management of metadata

B. Computing the data

C. Maintaining Availability Zones

D. Infrastructure security

E. Parsing and optimizing queries

What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

A. 1

B. 5

C. 10

D. 100

Which command is used to unload files from an internal or external stage to a local file system?

A. COPY INTO

B. GET

C. PUT

D. TRANSFER

Which common query problems can the Query Profile help a user identify and troubleshoot? (Choose two.)

A. When window functions are used incorrectly

B. When there are exploding joins

C. When there is a UNION without ALL

D. When the SELECT DISTINCT command returns too many values

E. When there are Common Table Expressions (CTEs) without a final SELECT statement

Snowflake best practice recommends that which role be used to enforce a network policy on a Snowflake account?

A. ACCOUNTADMIN

B. SECURITYADMIN

C. SYSADMIN

D. USERADMIN

When data is loaded into Snowflake, what formats does Snowflake use internally to store the data in cloud storage? (Choose two.)

A. Key-value

B. Columnar

C. Graph

D. Document

E. Compressed

Snowflake's access control framework combines which models for securing data? (Select TWO).

A. Attribute-based Access Control (ABAC)

B. Discretionary Access Control (DAC)

C. Access Control List (ACL)

D. Role-based Access Control (RBAC)

E. Rule-based Access Control (RuBAC)

Which Snowflake native tool can be used to diagnose and troubleshoot network connections?

A. SnowSQL

B. Snowflake Python connector

C. Snowsight

D. SnowCD