Snowpipe is used for continuous, automated data loading into Snowflake. It uses a COPY INTO
statement within a pipe object to load data from files as soon as they are available in a stage. Snowpipe does not execute UDFs, stored procedures, or insert statements. References: Snowpipe | Snowflake Documentation
Question 2
How often are encryption keys automatically rotated by Snowflake?
Options:
A.
30 Days
B.
60 Days
C.
90 Days
D.
365 Days
Answer:
A
Explanation:
Explanation:
Snowflake automatically rotates encryption keys when they are more than 30 days old. Active keys are retired, and new keys are created. This process is part of Snowflake’s comprehensive security measures to ensure data protection and is managed entirely by the Snowflake service without requiring user intervention.
References:
Understanding Encryption Key Management in Snowflake
Question 3
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
Options:
A.
4
B.
8
C.
16
D.
32
Answer:
B
Explanation:
Explanation:
In Snowflake, each size increase in virtual warehouses doubles the number of servers. Therefore, if a size Small virtual warehouse is made up of two servers, a Large warehouse, which is two sizes larger, would be made up of eight servers (2 servers for Small, 4 for Medium, and 8 for Large)2.
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes: