When is the result set cache no longer available? (Select TWO)

• A.When another warehouse is used to execute the query
• B.When another user executes the query
• C.When the underlying data has changed
• D.When the warehouse used to execute the query is suspended
• E.When it has been 24 hours since the last query

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands are not blocking operations? Choose 2 answers

• A.COPY
• B.UPDATE
• C.INSERT
• D.MERGE

Comment: *

Name: *

Email: *

Verification: *

When will Snowflake charge credits for the use of the Cloud Services layer?

• A.Credits will be charged only when a virtual warehouse consumes serverless compute services.
• B.Credits will be charged whenever the Cloud Services layer is used.
• C.Credits will be charged only when running a Snowflake-provisioned compute warehouse comfute_wh.
• D.Credits will be charged when the daily consumption of cloud services resources exceeds Wo of the daily warehouse usage.

Comment: *

Name: *

Email: *

Verification: *

Which are true of Snowflake roles?

• A.In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
• B.Roles are a subset of users and users own objects In Snowflake
• C.The public role controls at other roles
• D.All grants to objects are given to roles, and never to users

Comment: *

Name: *

Email: *

Verification: *

True or False: Snowpipe via REST API can only reference External Stages as source.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *