SnowPro Advanced: Architect — Question 143

What occurs when unloading data from Snowflake? (Choose two.)

Answer options

• A. All data files unloaded to an external stage are automatically encrypted using 128-bit keys.
• B. All data files unloaded to an internal stage are automatically encrypted using 128-bit keys.
• C. Target cloud storage can only be in the same cloud and region as Snowflake.
• D. Output files are encoded using UTF-8.
• E. All data files are uncompressed by default.

Correct answer: B, D

Explanation

Option B is correct because data files unloaded to an internal stage are indeed encrypted by default. Option D is also correct as the output files are encoded using UTF-8. Options A and C are incorrect as external stages do not have automatic encryption with 128-bit keys, and cloud storage can be in different regions. Option E is false since files are compressed by default unless specified otherwise.