Which compression method is NOT yet detectable by Snowflake?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Which compression method is NOT yet detectable by Snowflake?

Explanation:
Snowflake can automatically detect and decompress several common compression schemes used for data files during loading. It recognizes gzip, bz2, and deflate and will transparently handle these when you load data (especially if you enable auto-detection). Brotli, however, isn’t supported for automatic detection by Snowflake, so a Brotli-compressed file can’t be decompressed on the fly. To work with Brotli, you’d need to decompress the file before loading or provide an uncompressed stream. That’s why Brotli is the option that isn’t detectable by Snowflake.

Snowflake can automatically detect and decompress several common compression schemes used for data files during loading. It recognizes gzip, bz2, and deflate and will transparently handle these when you load data (especially if you enable auto-detection). Brotli, however, isn’t supported for automatic detection by Snowflake, so a Brotli-compressed file can’t be decompressed on the fly. To work with Brotli, you’d need to decompress the file before loading or provide an uncompressed stream. That’s why Brotli is the option that isn’t detectable by Snowflake.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy