Answer-first summary for fast verification
Answer: After loading the data into a table., After loading the data into an internal stage.
Based on the community discussion and Snowflake documentation, Snowflake automatically encrypts data in two scenarios: (1) After loading data into an internal stage (B) - when data is uploaded to an internal Snowflake stage, it's automatically encrypted by the Snowflake client before transmission and remains encrypted in the stage; (2) After loading the data into a table (C) - all data at rest in Snowflake tables is always encrypted. Option A is incorrect because micro-partitioning occurs after data is already in tables. Option D is incorrect because external stages are outside Snowflake's control, so encryption isn't automatic. Option E is incorrect as encryption occurs regardless of stage encryption settings.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When does Snowflake automatically encrypt data loaded into the platform? (Select two.)
A
After the data is micro-partitioned.
B
After loading the data into a table.
C
After loading the data into an internal stage.
D
After loading data into an external stage.
E
Only when using an encrypted stage.
No comments yet.