COF-C02 Snowflake Exam Questions and Free Practice Test

Question 73

- (Topic 4)
Which Snowflake function will parse a JSON-null into a SQL-null?

A. TO_CHAR

B. TO_VARIANT

C. TO_VARCHAR

D. STRIP NULL VALUE

Correct Answer:D
The STRIP_NULL_VALUE function in Snowflake is used to convert a JSON null value into a SQL NULL value1.

Question 74

- (Topic 3)
Which kind of Snowflake table stores file-level metadata for each file in a stage?

A. Directory

B. External

C. Temporary

D. Transient

Correct Answer:A
The kind of Snowflake table that stores file-level metadata for each file in a stage is a directory table. A directory table is an implicit object layered on a stage and stores file-level metadata about the data files in the stage3.

Question 75

- (Topic 6)
Which Snowflake native tool can be used to diagnose and troubleshoot network connections?

A. SnowSQL

B. Snowflake Python connector

C. Snowsight

D. SnowCD

Correct Answer:A
SnowSQL, Snowflake's command-line client, can be used to diagnose and troubleshoot network connections. SnowSQL provides various commands and options to test connectivity, configure network settings, and troubleshoot issues related to network connections between the client and Snowflake.
References:
✑ Snowflake Documentation: SnowSQL

Question 76

- (Topic 3)
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?

A. 60

B. 91

C. 120

D. 121

Correct Answer:D
Snowflake??s billing for virtual warehouses is per-second, with a minimum of 60 seconds for each time the warehouse is started or resumed. Therefore, if a warehouse runs for 61 seconds, it is billed for 61 seconds. If it is then shut down and restarted, running for an additional 30 seconds, it is billed for another 60 seconds (the minimum charge for a restart), totaling 121 seconds2

Question 77

- (Topic 6)
Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?

A. A VARIANT column is more secure than a string column

B. A VARIANT column compresses data and a string column does not.

C. A variant column can be used to create a data hierarchy and a string column cannot

D. A VARIANT column will have a better query performance than a string column.

Correct Answer:C
A VARIANT column in Snowflake is specifically designed to store semi-structured data, such as JSON, and allows for the creation of a data hierarchy. Unlike string columns, VARIANT columns can natively handle JSON data structures, enabling complex querying and manipulation of hierarchical data using functions designed for semi-structured data. References:
✑ Snowflake Documentation: VARIANT Data

Question 78

- (Topic 1)
Which statement about billing applies to Snowflake credits?

A. Credits are billed per-minute with a 60-minute minimum

B. Credits are used to pay for cloud data storage usage

C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D. Credits are consumed based on the warehouse size and the time the warehouse is running

Correct Answer:D
Snowflake credits are the unit of measure for the compute resources used in Snowflake. The number of credits consumed depends on the size of the virtual warehouse and the time it is running. Larger warehouses consume more credits per hour than smaller ones, and credits are billed for the time the warehouse is active, regardless of the actual usage within that time.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

START COF-C02 EXAM