COF-C03 Practice Questions

A.  

show grants to user USER1;

B.  

show grants of user USER1;

C.  

describe user USER1;

D.  

show grants on user USER1;

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.  

SCIM

B.  

Federated authentication

C.  

TLS 1.2

D.  

Key-pair authentication

E.  

OAuth

F.  

OCSP authentication

A.  

Micro-partitions

B.  

Clustering keys

C.  

Key partitions

D.  

Clustered partitions

A.  

SnowSQL

B.  

Snowflake classic web interface (Ul)

C.  

Snowsight

D.  

.NET driver

A.  

Metadata cache

B.  

Result cache

C.  

Remote cache

D.  

Local file cache

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.  

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.  

Users

B.  

Tables

C.  

Databases

D.  

Internal Stages

A.  

True

B.  

False

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.  

account__usage . query history view

B.  

account__usage.query__history__archive View

C.  

information__schema . cruery_history view

D.  

information__schema - query history_by_ses s i on view

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.  

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.  

Pipe

B.  

External stage

C.  

Task

D.  

Stream

A.  

Data sharing within a specific region

B.  

Query result retrieval

C.  

Database replication

D.  

Loading data into Snowflake