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: 10 / 10
Total 330 questions

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

A.

Schema Stage

B.

User Stage

C.

Database Stage

D.

Table Stage

E.

External Named Stage

F.

Internal Named Stage

Which of the following are best practices for loading data into Snowflake? (Choose three.)

A.

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

B.

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

C.

Enclose fields that contain delimiter characters in single or double quotes.

D.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

E.

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

F.

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

A.

Business Critical Edition

B.

Standard Edition

C.

Virtual Private Snowflake (VPS)

D.

Enterprise Edition

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

A.

Management of metadata

B.

Computing the data

C.

Maintaining Availability Zones

D.

Infrastructure security

E.

Parsing and optimizing queries

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A.

Whether or not it is also a secure view

B.

How often the underlying base table is queried

C.

How often the base table changes

D.

Whether the materialized view has a cluster key defined

E.

How often the materialized view is queried

Which formats does Snowflake store unstructured data in? (Choose two.)

A.

GeoJSON

B.

Array

C.

XML

D.

Object

E.

BLOB

Which data type can store more than one type of data structure?

A.

JSON

B.

BINARY

C.

VARCHAR

D.

VARIANT

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Which of the following accurately describes shares?

A.

Tables, secure views, and secure UDFs can be shared

B.

Shares can be shared

C.

Data consumers can clone a new table from a share

D.

Access to a share cannot be revoked once granted