The PUT command: (Choose two.)
The PUT command: (Choose two.)
The PUT command in Snowflake automatically compresses files using Gzip as the default compression method. Additionally, all files are automatically encrypted during the transfer process using 128-bit or 256-bit keys. This ensures both efficient data storage and secure data transfer.
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 the correct options
CD are the correct options
CD are the correct options
CD is correct
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
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 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 right answer
CD are default in snowflake. For compression and encryption , snowflake take care. AB are the correct option.