Snowflake Updated COF-C03 Exam Questions and Answers by stephen

A directory table is a special Snowflake-managed table that stores metadata about unstructured data files (such as images, videos) in a stage.

It supports automatic metadata refresh .

It enables listing and querying file-level details .

The correct answers are A. CSV stores flat, tabular data and E. JSON can be loaded into a VARIANT column without predefined schema .

Important correction:

The provided answer A, B is not correct. CSV does not natively support complex semi-structured data types such as arrays and objects. JSON does.

Why A is correct:

CSV is a delimited, flat file format commonly used for structured, tabular data. Each row usually represents a record, and each field is separated by a delimiter such as a comma.

Why E is correct:

JSON is semi-structured data and can be loaded into a Snowflake VARIANT column. This allows Snowflake to store JSON objects and arrays without requiring every nested field to be predefined as a relational column.

Example:

CREATE TABLE json_data (

src VARIANT

);

COPY INTO json_data

FROM @my_stage

FILE_FORMAT = (TYPE = JSON);

Why the other options are incorrect:

B. CSV does not natively support arrays and objects. JSON supports nested structures such as arrays and objects.

C. JSON does not need to be converted to CSV before it can be queried in Snowflake. Snowflake can query JSON data stored in VARIANT, OBJECT, or ARRAY columns.

D. CSV files do not automatically detect and apply Snowflake table data types during loading. The target table schema and file format options control how data is interpreted.

Official Snowflake documentation reference:

Snowflake documentation explains that CSV is used for structured data, while semi-structured formats such as JSON can be loaded into VARIANT columns and queried using semi-structured data syntax.

The correct answer is B. SELECT * FROM table_A TABLESAMPLE (100); .

TABLESAMPLE (100) samples 100 percent of the table, so it returns all rows from table_A.

Why B is correct:

SELECT *

FROM table_A TABLESAMPLE (100);

This requests a 100 percent sample, which is effectively the full table.

Why the other options are incorrect:

A. TABLESAMPLE (0) returns 0 percent of the table, not all rows.

C. SAMPLE (10) returns approximately 10 percent of the rows, not all rows.

D. TABLESAMPLE BERNOULLI (10) samples each row with a 10 percent probability, not all rows.

Official Snowflake documentation reference:

Snowflake documentation explains that SAMPLE / TABLESAMPLE can specify a probability percentage. A value of 100 represents 100 percent of the table.