certifhub logo
Use code BLOG30 | 30% OFF
Copied! Paste at checkout

Snowpro Advanced Architect · Free Practice Question Easy

Question 9

When executing a COPY INTO <location> FROM <table_name>; command to unload data from a Snowflake table to an external stage, and no specific COMPRESSION option is defined in the associated file format, which compression format does Snowflake apply by default to the unloaded files?
  • A GZIP
  • B BZIP2
  • C ZSTD
  • D SNAPPY
Reveal correct answer

Correct answer: A

Explanation

✅ GZIP

Explanation:

When COPY INTO FROM <table_name> is executed in Snowflake without specifying a COMPRESSION option, the default compression format applied to unloaded files is GZIP.

  • GZIP is the default compression → Snowflake automatically compresses unloaded files using GZIP unless explicitly overridden.

  • Efficient for storage and transfer → GZIP provides good compression ratios while maintaining fast decompression speeds.

  • Widely supported → Compatible with various cloud storage services and data processing tools.


❌ Why the other options are incorrect?

SNAPPY
→ Incorrect, because SNAPPY is optimized for fast decompression, but is not the default compression format in Snowflake.

ZSTD
→ Incorrect, because ZSTD is supported, but GZIP is the default unless explicitly changed.

BZIP2
→ Incorrect, because BZIP2 is available, but is not the default compression format.


For more details, check the official Snowflake documentation on COPY INTO.

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need