- (Exam Topic 3)
When loading data into Snowflake, how should the data be organized?

1. A. Into single files with 100-250 MB of compressed data per file
2. B. Into single files with 1-100 MB of compressed data per file
3. C. Into files of maximum size of 1 GB of compressed data per file
4. D. Into files of maximum size of 4 GB of compressed data per file

Correct Answer: A

- (Exam Topic 1)
How a Snowpipe charges calculated?

1. A. Per-second/per Warehouse size
2. B. Per-second/per-core granularity
3. C. Number of Pipes in account
4. D. Total storage bucket size

Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

- (Exam Topic 1)
True or False: An active warehouse is required to run a COPY INTO statement.

1. A. True
2. B. False

Correct Answer: A

- (Exam Topic 2)
What are value types that a VARIANT column can store? (Select TWO)

1. A. STRUCT
2. B. OBJECT
3. C. BINARY
4. D. ARRAY
5. E. CLOB

Correct Answer: BD
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics

- (Exam Topic 2)
User-level network policies can be created by which of the following roles? (Select TWO).

1. A. ROLEADMIN
2. B. ACCOUNTADMIN
3. C. SYSADMIN
4. D. SECURITYADMIN
5. E. USERADMIN

Correct Answer: DE
By default, Snowflake allows users to connect to the service from any computer or device IP address. A security administrator (or higher) can create a network policy to allow or deny access to a single IP address or a list of addresses. Network policies currently support only Internet Protocol version 4 (i.e. IPv4) addresses.
An administrator with sufficient permissions can create any number of network policies. https://docs.snowflake.com/en/user-guide/network-policies.html#:~:text=A%20security%20administrator%20(o