Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

• A.PUT
• B.GET
• C.COPY
• D.SELECT

Comment: *

Name: *

Email: *

Verification: *

What happens when a suspended virtual warehouse is resized in Snowflake?

• A.It will return an error.
• B.It will return a warning.
• C.The suspended warehouse is resumed and new compute resources are provisioned immediately.
• D.The additional compute resources are provisioned when the warehouse is resumed.

Comment: *

Name: *

Email: *

Verification: *

What type of function returns one value for each Invocation?

• A.Aggregate
• B.Scalar
• C.Table
• D.Window

Comment: *

Name: *

Email: *

Verification: *

How can a user get the MOST detailed information about individual table storage details in Snowflake?

• A.SHOW TABLES command
• B.SHOW EXTERNAL TABLES command
• C.TABLES view
• D.TABLE STORAGE METRICS view

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: *