Answer: It compresses all files using GZIP., It encrypts the file data in transit.

The PUT command in Snowflake automatically compresses files using GZIP (option C) and encrypts the file data in transit (option D). These are built-in security and optimization features of the PUT command when uploading files to internal stages. Option A is incorrect because PUT does not create file format objects - that requires the CREATE FILE FORMAT command. Option B is incorrect because PUT does not automatically use the last stage created; the stage must be explicitly specified. Option E is incorrect because PUT uploads files to stages, it does not create or populate tables.

Author: LeetQuiz Editorial Team