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

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

A.

True

B.

False

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

A.

True

B.

False

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

A.

True

B.

False

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

A.

True

B.

False

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

A.

Compute Credits = 50 Credits Cloud Services = 10

B.

Compute Credits = 80 Credits Cloud Services = 5

C.

Compute Credits = 10 Credits Cloud Services = 9

D.

Compute Credits = 120 Credits Cloud Services = 10

E.

Compute Credits = 200 Credits Cloud Services = 26

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

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