Question 103

- (Exam Topic 3)
Which of the following describes a Snowflake stored procedure?

Correct Answer:A
Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html

Question 104

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

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

Question 105

- (Exam Topic 2)
What data is stored in the Snowflake storage layer? (Select TWO).

Correct Answer:BD

Question 106

- (Exam Topic 2)
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Correct Answer:AD

Question 107

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

Correct Answer:A

Question 108

- (Exam Topic 1)
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Correct Answer:BD
https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage "Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size."

START SnowPro-Core EXAM