Snowflake COF-R02 Exam Questions Free Practice Test

Viewing page 5 out of 10 pages

Viewing questions 41-50 out of questions

Questions # 41:

Where would a Snowflake user find information about query activity from 90 days ago?

Options:

account__usage . query history view

account__usage.query__history__archive View

information__schema . cruery_history view

information__schema - query history_by_ses s i on view

Expert Solution

Questions # 42:

A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

Options:

Query against the result set cache

Query against a virtual warehouse cache

Query against the most-recently created micro-partition

Query against the metadata excite

Expert Solution

Questions # 43:

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

Options:

Data can be filtered by an optional where clause

Incoming data can be joined with other tables

Columns can be reordered

Columns can be omitted

Row level access can be defined

Expert Solution

Questions # 44:

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

Options:

list @mytable;

list @%raytable;

list @ %m.ystage;

list @mystage;

Expert Solution

Questions # 45:

What is the default File Format used in the COPY command if one is not specified?

Options:

CSV

JSON

Parquet

XML

Expert Solution

Questions # 46:

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

Options:

VARIANT

ARRAY

VARCHAR

XML

BLOB

Expert Solution

Questions # 47:

Which of the following describes how clustering keys work in Snowflake?

Options:

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

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

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

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

Expert Solution

Questions # 48:

What are value types that a VARIANT column can store? (Select TWO)

Options:

STRUCT

OBJECT

BINARY

ARRAY

CLOB

Expert Solution

Questions # 49:

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

Options:

True

False

Expert Solution

Questions # 50:

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Options:

STATEMENT_TIMEOUT__IN__SECONDS

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

MAX_CONCURRENCY__LEVEL

QUERY_TIMEOUT_IN_SECONDS

Expert Solution

Viewing page 5 out of 10 pages

Viewing questions 41-50 out of questions

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