When should a multi-cluster virtual warehouse be used in Snowflake?

• A.When there is significant disk spilling shown on the Query Profile
• B.When dynamic vertical scaling is being used in the warehouse
• C.When there are no concurrent queries running on the warehouse
• D.When queuing is delaying query execution on the warehouse

Comment: *

Name: *

Email: *

Verification: *

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

• A.Load files that are approximately 25 MB or smaller.
• B.Remove all dates and timestamps.
• C.Load files that are approximately 100-250 MB (or larger)
• D.Avoid using embedded characters such as commas for numeric data types
• E.Remove semi-structured data types

Comment: *

Name: *

Email: *

Verification: *

How can a Snowflake user automate virtual warehouse operations for optimal credit consumption? (Select TWO).

• A.Auto-resume when a query is in a queue.
• B.Auto-resume after a set time period.
• C.Auto-suspend while the query is being written.
• D.Auto-suspend after a set time period.
• E.Auto-suspend after a specified period of inactivity.

Comment: *

Name: *

Email: *

Verification: *

True or False: Fail-safe can be disabled within a Snowflake account.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

• A.Bytes scanned
• B.Bytes written to result
• C.Partitions scanned
• D.Partitions total
• E.Percentage scanned from cache

Comment: *

Name: *

Email: *

Verification: *