- (Exam Topic 2)
What is the MOST performant file format for loading data in Snowflake?

Correct Answer:A

- (Exam Topic 3)
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Correct Answer:B
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

- (Exam Topic 1)
True or False: Once created, a micro-partition will never be changed.

Correct Answer:A
Reference: https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/

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

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 security administrator (o

- (Exam Topic 3)
Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

Correct Answer:AEF

- (Exam Topic 3)
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Correct Answer:AD