SnowPro-Core Free Practice Test

- (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

- (Exam Topic 1)
True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

1. A. True
2. B. False

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

- (Exam Topic 1)
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

1. A. True
2. B. False

Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide-data-unload.html