Snowflake COF-R02 Exam Questions Free Practice Test

Viewing page 6 out of 10 pages

Viewing questions 51-60 out of questions

Questions # 51:

What is the default character set used when loading CSV files into Snowflake?

Options:

UTF-8

UTF-16

ISO S859-1

ANSI_X3.A

Expert Solution

Questions # 52:

What are ways to create and manage data shares in Snowflake? (Select TWO)

Options:

Through the Snowflake web interface (Ul)

Through the DATA_SHARE=TRUE parameter

Through SQL commands

Through the enable__share=true parameter

Using the CREATE SHARE AS SELECT * TABLE command

Expert Solution

Questions # 53:

Which copy INTO command outputs the data into one file?

Options:

SINGLE=TRUE

MAX_FILE_NUMBER=1

FILE_NUMBER=1

MULTIPLE=FAISE

Expert Solution

Questions # 54:

Which of the following can be executed/called with Snowpipe?

Options:

A User Defined Function (UDF)

A stored procedure

A single copy_into statement

A single insert__into statement

Expert Solution

Questions # 55:

Which Snowflake technique can be used to improve the performance of a query?

Options:

Clustering

Indexing

Fragmenting

Using INDEX__HINTS

Expert Solution

Questions # 56:

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Options:

Pipe

External stage

Task

Stream

Expert Solution

Questions # 57:

What is a responsibility of Snowflake's virtual warehouses?

Options:

Infrastructure management

Metadata management

Query execution

Query parsing and optimization

Management of the storage layer

Expert Solution

Questions # 58:

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Options:

The table contains a column that has very low cardinality

DML statements that are being issued against the table are blocked

The table has a small number of micro-partitions

Queries on the table are running slower than expected

The clustering depth for the table is large

Expert Solution

Questions # 59:

Which command can be used to stage local files from which Snowflake interface?

Options:

SnowSQL

Snowflake classic web interface (Ul)

Snowsight

.NET driver

Expert Solution

Questions # 60:

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

Options:

Create a task that runs a copy into operation from an external stage every 5 minutes

Create a task that puts the files in an internal stage and automate the data loading wizard

Create a task that runs a GET operation to intermittently check for new files

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Expert Solution

Viewing page 6 out of 10 pages

Viewing questions 51-60 out of questions

Pass the Snowflake SnowPro Core Certification COF-R02 Questions and answers with CertsForce