New Year Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Snowflake COF-R02 - SnowPro Core Recertification Exam

Snowflake COF-R02 Premium Access     Download Demo    
Page: 8 / 10
Total 330 questions

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

A.

Removing a column from the query SELECT list

B.

Stopping the virtual warehouse that the query is running against

C.

Clustering of the data used by the query

D.

Executing the RESULTS_SCAN() table function

E.

Changing a column that is not in the cached query

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

A.

The explain plan output is available graphically.

B.

An explain plan can be used to conduct performance analysis without executing a query.

C.

An explain plan will handle queries with temporary tables and the query profiler will not.

D.

An explain plan's output will display automatic data skew optimization information.

What internal stages are available in Snowflake? (Choose three.)

A.

Schema stage

B.

Named stage

C.

User stage

D.

Stream stage

E.

Table stage

F.

Database stage

How many resource monitors can be assigned at the account level?

A.

1

B.

2

C.

3

D.

4

Which of the following objects are contained within a schema? (Choose two.)

A.

Role

B.

Stream

C.

Warehouse

D.

External table

E.

User

F.

Share

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A.

A directory table is a separate database object.

B.

Directory tables store data file metadata.

C.

A directory table will be automatically added to a stage.

D.

Directory tables do not have their own grantable privileges.

E.

Directory table data can not be refreshed manually.

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

A.

parse_json()

B.

json_extract_path_text()

C.

object_construct()

D.

flatten

Which of the following describes a Snowflake stored procedure?

A.

They can be created as secure and hide the underlying metadata from the user.

B.

They can only access tables from a single database.

C.

They can contain only a single SQL statement.

D.

They can be created to run with a caller's rights or an owner's rights.

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

A.

Configure the warehouse to a size larger than generally required

B.

Set the minimum and maximum clusters to autoscale

C.

Use the standard warehouse scaling policy

D.

Use the economy warehouse scaling policy

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

A.

The number of queries executed

B.

The number of active users assigned to the warehouse

C.

The size of the virtual warehouse

D.

The length of time the warehouse is running

E.

The duration of the queries that are executed