- (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
- (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
- (Exam Topic 2)
What data is stored in the Snowflake storage layer? (Select TWO).
Correct Answer:BD
- (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
- (Exam Topic 3)
When loading data into Snowflake, how should the data be organized?
Correct Answer:A
- (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."