Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

• A.The user has the appropriate privileges on the objects associated with the query
• B.Micro-partitions have been reclustered since the query was last run
• C.The new query is run using the same virtual warehouse as the previous query
• D.The query includes a User Defined Function (UDF)
• E.The query has been run within 24 hours of the previously-run query

Comment: *

Name: *

Email: *

Verification: *

How often are encryption keys automatically rotated by Snowflake?

• A.30 Days
• B.60 Days
• C.90 Days
• D.365 Days

Comment: *

Name: *

Email: *

Verification: *

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

• A.Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
• B.A user cannot specify a default warehouse when using the ODBC driver.
• C.The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
• D.The default virtual warehouse size can be changed at any time.
• E.SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

Comment: *

Name: *

Email: *

Verification: *

Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?

• A.A VARIANT column is more secure than a string column
• B.A VARIANT column compresses data and a string column does not.
• C.A variant column can be used to create a data hierarchy and a string column cannot
• D.A VARIANT column will have a better query performance than a string column.

Comment: *

Name: *

Email: *

Verification: *

What can the Snowflake SCIM API be used to manage? (Select TWO).

• A.Users
• B.Integrations
• C.Roles
• D.Network policies
• E.Session policies

Comment: *

Name: *

Email: *

Verification: *