COF-C02 Practice Exam Questions and Answers

A.  

Data is hashed by the cluster key to facilitate fast searches for common data values

B.  

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C.  

Smaller micro-partitions are created for common data values to allow for more parallelism

D.  

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

A.  

Compute resources

B.  

Query execution

C.  

Authentication

D.  

Data storage

E.  

Metadata

A.  

Standard Edition

B.  

Enterprise Edition

C.  

Business Critical Edition

D.  

Virtual Private Snowflake Edition

A.  

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

B.  

Partitions scanned is equal to partitions total

C.  

An AggregateOperacor node is present

D.  

The query is spilling to remote storage

A.  

STATEMENT_TIMEOUT__IN__SECONDS

B.  

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C.  

MAX_CONCURRENCY__LEVEL

D.  

QUERY_TIMEOUT_IN_SECONDS

A.  

To call code that executes outside of Snowflake

B.  

To run a function in another Snowflake database

C.  

To share data in Snowflake with external parties

D.  

To ingest data from on-premises data sources

A.  

Variant

B.  

Object

C.  

Geometry

D.  

Geography

A.  

30 Days

B.  

60 Days

C.  

90 Days

D.  

365 Days

A.  

Load files that are approximately 25 MB or smaller.

B.  

Remove all dates and timestamps.

C.  

Load files that are approximately 100-250 MB (or larger)

D.  

Avoid using embedded characters such as commas for numeric data types

E.  

Remove semi-structured data types

A.  

Credits are billed per-minute with a 60-minute minimum

B.  

Credits are used to pay for cloud data storage usage

C.  

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D.  

Credits are consumed based on the warehouse size and the time the warehouse is running