Snowflake Updated COF-C03 Exam Questions and Answers by inaaya

Snowflake allows users to write custom application logic in JavaScript for two types of objects: Stored Procedures and User-Defined Functions (UDFs).

Stored Procedures:Snowflake stored procedures can be written in JavaScript to encapsulate complex business logic and procedural operations.

CREATE OR REPLACE PROCEDURE my_procedure()

RETURNS STRING

LANGUAGE JAVASCRIPT

EXECUTE AS CALLER

AS

$$

// JavaScript logic here

$$;

User-Defined Functions (UDFs):Snowflake UDFs can be written in JavaScript to perform custom calculations or operations on data.

CREATE OR REPLACE FUNCTION my_function(x FLOAT)

RETURNS FLOAT

LANGUAGE JAVASCRIPT

AS

$$

return x * 2;

$$;

The correct answer is B. PARTITION BY .

The PARTITION BY option in COPY INTO < location > partitions unloaded data into separate files based on the expression specified. This is commonly used to organize unloaded files by values such as date, region, or another column.

Why B is correct:

PARTITION BY controls how unloaded rows are grouped into different output paths/files.

Example:

COPY INTO @my_stage/sales/

FROM sales

PARTITION BY (TO_DATE(sale_date))

FILE_FORMAT = (TYPE = CSV);

This unloads rows into separate output paths based on the sale_date expression.

Why the other options are incorrect:

A. DETAILED_OUTPUT controls the amount of unload result information returned by the command.

C. FILE_FORMAT controls the format of the unloaded files, such as CSV, JSON, or Parquet.

D. HEADER controls whether column headings are included in unloaded output files.

Official Snowflake documentation reference:

Snowflake documentation for COPY INTO < location > describes PARTITION BY as the option used to partition unloaded rows into separate files based on an expression.

The correct answer is C. PARSE_JSON .

PARSE_JSON parses a valid JSON-formatted string and returns a VARIANT value. This is commonly used when inserting semi-structured JSON data into a VARIANT column.

Why C is correct:

A VARIANT column can store semi-structured data such as JSON objects and arrays. When the source value is a JSON string, PARSE_JSON converts it into a Snowflake VARIANT.

Example:

CREATE TABLE json_table (

src VARIANT

);

INSERT INTO json_table

SELECT PARSE_JSON( ' { " customer_id " : 101, " region " : " WEST " } ' );

Why the other options are incorrect:

A. TO_JSON converts a VARIANT value into a JSON string. It is commonly used in the opposite direction.

B. TO_VARCHAR converts a value to a string, not to a semi-structured VARIANT.

D. OBJECT_INSERT inserts or updates a key-value pair inside an existing object, but it is not the primary function used to parse JSON text into a VARIANT column.

Official Snowflake documentation reference:

Snowflake documentation describes PARSE_JSON as a function that interprets an input string as JSON and returns a VARIANT value.