In Snowflake, what allows users to perform recursive queries?

• A.QUALIFY
• B.LATERAL
• C.PIVOT
• D.CONNECT BY

Comment: *

Name: *

Email: *

Verification: *

How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dimension tables?

• A.Create transient tables and periodically copy them to permanent tables.
• B.Create temporary tables and periodically copy them to permanent tables
• C.Create regular tables with extended Time Travel and Fail-safe settings.
• D.Create regular tables with default Time Travel and Fail-safe settings

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake partner specializes in data catalog solutions?

• A.Alation
• B.DataRobot
• C.dbt
• D.Tableau

Comment: *

Name: *

Email: *

Verification: *

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

• A.STATEMENT_TIMEOUT__IN__SECONDS
• B.QUERY_TIMEOUT_IN_SECONDS
• C.STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
• D.MAX_CONCURRENCY__LEVEL

Comment: *

Name: *

Email: *

Verification: *

What situation is likely to cause data spillage when a query is run?

• A.When the number of queries exceeds the max_concurrency_level parameter setting.
• B.When the query contains multiple filters and no data is returned.
• C.When running queries that exceed the statement_timecut_in_seccnds parameter setting.
• D.When a virtual warehouse runs out of memory while executing the query.

Comment: *

Name: *

Email: *

Verification: *