SnowPro-Core Free Practice Test

- (Exam Topic 3)
Which command sets the Virtual Warehouse for a session?

1. A. COPY WAREHOUSE FROM <<config file>>;
2. B. SET WAREHOUSE = <>;
3. C. USE WAREHOUSE <>;
4. D. USE VIRTUAL_WAREHOUSE <>;

Correct Answer: C
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

- (Exam Topic 3)
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

1. A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
2. B. Allows a user to import the files in a sequential order
3. C. Increases the latency staging and accuracy when loading the data
4. D. Allows optimization of parallel operations

Correct Answer: D

- (Exam Topic 1)
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

1. A. True
2. B. False

Correct Answer: A
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

- (Exam Topic 2)
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

1. A. True
2. B. False

Correct Answer: A
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

- (Exam Topic 1)
True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

1. A. True
2. B. False

Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/credits.html