Snowflake COF-R02 Exam Questions Instant Access

Question 1

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

ATSV

BJSON

CPDF

DAvro

EParquet

FJPEG

Answer : B, D, E

Question 2

When loading data into Snowflake, how should the data be organized?

AInto single files with 100-250 MB of compressed data per file

BInto single files with 1-100 MB of compressed data per file

CInto files of maximum size of 1 GB of compressed data per file

DInto files of maximum size of 4 GB of compressed data per file

Answer : A

Question 3

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

ASTRUCT

BOBJECT

CBINARY

DARRAY

ECLOB

Answer : B, D

Characteristics of a VARIANT

A VARIANT can store a value of any other type, includingOBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.

Question 4

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

ATo accommodate more queries

BTo accommodate more users

CTo accommodate fluctuations in workload

DTo accommodate a more complex workload

Answer : D

Question 5

What is the recommended file sizing for data loading using Snowpipe?

AA compressed file size greater than 100 MB, and up to 250 MB

BA compressed file size greater than 100 GB, and up to 250 GB

CA compressed file size greater than 10 MB, and up to 100 MB

DA compressed file size greater than 1 GB, and up to 2 GB

Answer : A

https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20used%20to,data%20within%20one%2Dminute%20intervals.

Question 6

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

Aparse_json()

Bjson_extract_path_text()

Cobject_construct()

Dflatten

Answer : B

Question 7

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

AAuto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

BThe ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

CSnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

DA user cannot specify a default warehouse when using the ODBC driver.

EThe default virtual warehouse size can be changed at any time.

Answer : A

Snowflake SnowPro Core Recertification COF-R02 Exam Questions