QUESTION 31
If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

QUESTION 32
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: Choose 2 answers

QUESTION 33
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

QUESTION 34
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

QUESTION 35
Which type of table corresponds to a single Snowflake session?

QUESTION 36
True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

QUESTION 37
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).

QUESTION 38
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

QUESTION 39
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

QUESTION 40
Which of the following objects are contained within a schema? (Choose two.)

QUESTION 41
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

QUESTION 42
Which statement about billing applies to Snowflake credits?

QUESTION 43
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

QUESTION 44
Which of the following commands sets the Virtual Warehouse for a session?

QUESTION 45
What are value types that a VARIANT column can store? (Select TWO)

QUESTION 46
What features does Snowflake Time Travel enable?

QUESTION 47
True or False: When you create a custom role, it is a practice to immediately grant that role
to ACCOUNTADMIN.

QUESTION 48
True or False: A Virtual Warehouse can be resized while suspended.

QUESTION 49
Which object allows you to limit the number of credits consumed within a Snowflake account?

QUESTION 50
Which of the following statements is true of Snowflake?