Exam SnowPro Core topic 1 question 27 discussion

The PUT command in Snowflake automatically compresses files using Gzip and encrypts the files during the transfer process

correct answer:CD

C. Automatically compresses files using Gzip D. Automatically encrypts files Therefore, the correct options are: C. Automatically compresses files using Gzip D. Automatically encrypts files The PUT command in Snowflake compresses files using Gzip by default and encrypts files during the transfer to a stage, ensuring secure and efficient data loading.

PUT does not support uploading files to external stages. All files stored on internal stages for data loading and unloading operations are automatically encrypted using AES-256 strong encryption on the server side. By default, Snowflake provides additional client-side encryption with a 128-bit key (with the option to configure a 256-bit key). AUTO_COMPRESS is TRUE by default and by default it uses GZIP.

c and d

CD are the correct answer!

CD are the correct options

CD are the correct options

CD are the correct options

CD are the correct options

Uploaded files are automatically encrypted with 128-bit or 256-bit keys. AUTO_COMPRESS is TRUE by default and by default it uses GZIP. https://docs.snowflake.com/en/sql-reference/sql/put.html

CD are correct

First we will create a stage and then use PUT to load the data from onprem to that stage. Hence B. And the data will be transferred to the stage and will be encrypted, Hence D. So I guess it should be B and D.

CD is correct

CD is right answer

CD are default in snowflake. For compression and encryption , snowflake take care. AB are the correct option.

C and D make sense. AUTO_COMPRESS is an optional parameter for the PUT command with a default value of TRUE. This means C is definitely an answer. Also PUT automatically encrypts all data with 128-bit or 256-bit keys