A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

• A.The primary cluster in the virtual warehouse
• B.The entire virtual warehouse
• C.The database in which the virtual warehouse resides
• D.The Queries currently being run on the virtual warehouse

Comment: *

Name: *

Email: *

Verification: *

When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

• A.1 hour
• B.2 hours
• C.4 hours
• D.8 hours

Comment: *

Name: *

Email: *

Verification: *

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

• A.4
• B.8
• C.16
• D.32

Correct Answer: B

In Snowflake, each size increase in virtual warehouses doubles the number of servers. Therefore, if a size Small virtual warehouse is made up of two servers, a Large warehouse, which is two sizes larger, would be made up of eight servers (2 servers for Small, 4 for Medium, and 8 for Large)2.
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Comment: *

Name: *

Email: *

Verification: *

A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

• A.Increase the warehouse size from Medium to 2XL.
• B.Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
• C.Configure the warehouse to a multi-cluster warehouse.
• D.Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Comment: *

Name: *

Email: *

Verification: *

What would cause different results to be returned when running the same query twice?

• A.SAMPLE is used and the seed is set
• B.sample is used and the seed is not set.
• C.Fraction-based sampling is used.
• D.Fixed-size sampling Is used.

Comment: *

Name: *

Email: *

Verification: *