SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 27


The PUT command: (Choose two.)

Show Answer
Correct Answer: CD

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.

Discussion

19 comments
Sign in to comment
SV1122Options: CD
Dec 30, 2022

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

N89Options: CD
Dec 31, 2022

CD are the correct options

ajay_1233456
Jan 22, 2023

CD are the correct options

ramisou
Mar 30, 2023

CD are the correct options

Fosterchild123
Feb 26, 2022

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

bharathmvOptions: CD
Sep 7, 2022

CD is correct

PrashantGupta1616Options: CD
Jun 6, 2024

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.

Mallikharjuna452
Jul 18, 2024

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

Percy2112Options: AB
Aug 14, 2022

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

bharathmv
Sep 7, 2022

CD is right answer

[Removed]Options: BD
Oct 24, 2022

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.

Tapasgup007Options: CD
Dec 3, 2022

CD are correct

Mayuri917233Options: CD
May 11, 2023

CD are the correct options

BobFar
Oct 10, 2023

CD are the correct answer!

_yyuktaOptions: CD
Feb 23, 2024

c and d

JasMozaiOptions: CD
May 8, 2024

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.

pranalig
Jun 16, 2024

correct answer:CD

jeny12138Options: CD
Apr 7, 2025

CD is true

sabithaMROptions: CD
Apr 10, 2025

CD are true