What type of query benefits the MOST from search optimization?

• A.A query that uses only disjunction (i.e., OR) predicates
• B.A query that includes analytical expressions
• C.A query that filters on semi-structured data types
• D.A query that uses equality predicates or predicates that use IN

Comment: *

Name: *

Email: *

Verification: *

What happens to historical data when the retention period for an object ends?

• A.Time Travel on the historical data is dropped.
• B.The object containing the historical data is dropped.
• C.The data is cloned into a historical object.
• D.The data moves to Fail-safe

Comment: *

Name: *

Email: *

Verification: *

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the
data.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

• A.Stopping the virtual warehouse that the query is running against
• B.Removing a column from the query SELECT list
• C.Executing the RESULTS_SCAN() table function
• D.Changing a column that is not in the cached query
• E.Clustering of the data used by the query

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes a Snowflake stored procedure?

• A.They can contain only a single SQL statement.
• B.They can be created to run with a caller's rights or an owner's rights.
• C.They can only access tables from a single database.
• D.They can be created as secure and hide the underlying metadata from the user.

Comment: *

Name: *

Email: *

Verification: *