What is the passing score for the Snowflake SnowPro Core exam?

The SnowPro Core (COF-C03) certification exam passing score is 750 or higher on a scaled score range of 0 to 1000.

Is CloudPrep affiliated with Snowflake Inc.?

No. Snowflake® and SnowPro® are registered trademarks of Snowflake Inc. CloudPrep is an independent educational platform and is not affiliated with, sponsored by, or endorsed by Snowflake Inc.

Which structured and semi-structured file types are natively supported by Snowflake File Formats for data loading?

CSV, JSON, AVRO, ORC, PARQUET, and XML — Snowflake natively supports 6 data file formats: CSV (delimited), JSON, AVRO, ORC, PARQUET, and XML.

Which SQL statement creates a reusable named file format for parsing pipe-delimited files with a header row?

`CREATE FILE FORMAT my_pipe_format TYPE = CSV FIELD_DELIMITER = '|' SKIP_HEADER = 1;` — `CREATE FILE FORMAT ... TYPE = CSV FIELD_DELIMITER = '|' SKIP_HEADER = 1;` is standard Snowflake DDL.

Which compression algorithms are natively recognized by Snowflake during data loading?

AUTO, GZIP, BZ2, BROTLI, ZSTD, DEFLATE, RAW_DEFLATE, and NONE — Snowflake recognizes GZIP, BZ2, BROTLI, ZSTD, DEFLATE, and AUTO (which automatically detects compression from file extension).

File Formats | SnowPro Core® Study Guide

Domain: Data Loading, Unloading & Connectivity (Pro Study Module)

September 2026 · 672 words · 10 min read

<02-file-formats>

Overview

File formats dictate how Snowflake parses flat files during data loading (COPY INTO <table>) and how it formats files during data unloading (COPY INTO <location>). Knowing which formats are supported and the specific options available for parsing semi-structured and structured data is a heavily tested area on the SnowPro Core certification.

Key Concepts

Supported File Formats

Unlock Full Deep-Dive Guide & 14 Practice MCQs

This complete architectural module, full checkpoint quiz, and unlimited mock exam simulations are included with the CloudPrep Pro Pass.

Unlock with Pro Pass