When loading Brotli-compressed CSV files, which option must be specified?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

When loading Brotli-compressed CSV files, which option must be specified?

Explanation:
When loading Brotli-compressed CSV files, you must tell the loader exactly which compression was used so it can decompress properly. Brotli is different from GZIP/DEFLATE, and auto-detection isn’t always reliable, so you specify BROTLI explicitly (for example, in the file format or COPY INTO settings). GZIP or DEFLATE would only apply if the data were compressed with those algorithms, which Brotli isn’t. Relying on AUTO can fail if Brotli isn’t detected correctly, so explicitly setting BROTLI ensures the data is decompressed and loaded correctly.

When loading Brotli-compressed CSV files, you must tell the loader exactly which compression was used so it can decompress properly. Brotli is different from GZIP/DEFLATE, and auto-detection isn’t always reliable, so you specify BROTLI explicitly (for example, in the file format or COPY INTO settings). GZIP or DEFLATE would only apply if the data were compressed with those algorithms, which Brotli isn’t. Relying on AUTO can fail if Brotli isn’t detected correctly, so explicitly setting BROTLI ensures the data is decompressed and loaded correctly.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy