COF-C02 Practice Questions

A.  

The column name and element names are both case-sensitive.

B.  

The column name and element names are both case-insensitive.

C.  

The column name is case-sensitive but element names are case-insensitive.

D.  

The column name is case-insensitive but element names are case-sensitive.

A.  

Aggregate

B.  

Scalar

C.  

Table

D.  

Window

A.  

Hierarchical key model

B.  

Client-side encryption

C.  

Tri-secret secure encryption

D.  

Key pair authentication

A.  

View

B.  

Secure view

C.  

Materialized view

D.  

External table

A.  

TABLES

B.  

TABLE_STORAGE_METRICS

C.  

STORAGE_DAILY_HISTORY

D.  

STORAGE USAGE

A.  

Binary file in Avro

B.  

Binary file in Parquet

C.  

Comma-separated JSON

D.  

Newline Delimited JSON

E.  

Plain text file containing XML elements

A.  

Add or remove users from a worksheet.

B.  

Move a worksheet to a folder or a dashboard.

C.  

Combine multiple worksheets into a single worksheet.

D.  

Tag frequently accessed worksheets for ease of access.

A.  

Users

B.  

Tables

C.  

Databases

D.  

Internal Stages

A.  

SINGLE=TRUE

B.  

MAX_FILE_NUMBER=1

C.  

FILE_NUMBER=1

D.  

MULTIPLE=FAISE

A.  

The primary cluster in the virtual warehouse

B.  

The entire virtual warehouse

C.  

The database in which the virtual warehouse resides

D.  

The Queries currently being run on the virtual warehouse

A.  

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

B.  

Clustering keys sort the designated columns over time, without blocking DML operations

C.  

Clustering keys create a distributed, parallel data structure of pointers to a table ' s rows and columns

D.  

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

A.  

The user has the appropriate privileges on the objects associated with the query

B.  

Micro-partitions have been reclustered since the query was last run

C.  

The new query is run using the same virtual warehouse as the previous query

D.  

The query includes a User Defined Function (UDF)

E.  

The query has been run within 24 hours of the previously-run query

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

A.  

STATEMENT_TIMEOUT__IN__SECONDS

B.  

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C.  

MAX_CONCURRENCY__LEVEL

D.  

QUERY_TIMEOUT_IN_SECONDS

A.  

It removes the last element of the outer array.

B.  

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

C.  

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

D.  

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

A.  

Set SINGLE: = true for larger files

B.  

Use OBJECT_CONSTRUCT ( * ) when using Parquet

C.  

Avoid the use of the CAST function

D.  

Define an individual file format

A.  

CSV (Unzipped)

B.  

Parquet

C.  

CSV (Gzipped)

D.  

ORC

A.  

As configured in the create pipe settings

B.  

Until the pipe is dropped

C.  

64 days

D.  

14 days

A.  

They are a type of User-defined Function (UDF).

B.  

They contain their own SQL code.

C.  

They call code that is stored inside of Snowflake.

D.  

They can return multiple rows for each row received

A.  

Metadata cache

B.  

Result cache

C.  

Remote cache

D.  

Local file cache