Answer: gzip

The correct answer is D (gzip) because Snowflake documentation explicitly states that gzip is the default compression method for unloaded data files unless compression is disabled or another supported method is explicitly specified. The community discussion confirms this with 100% consensus on answer D, and the highest upvoted comment references the official Snowflake documentation that verifies gzip as the default. Options A (Brotli), B (bzip2), and C (Zstandard) are supported compression methods in Snowflake but are not the default for unloading operations.

Author: LeetQuiz Editorial Team