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

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

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

What privilege should a user be granted to change permissions for new objects in a managed access schema?

• A.Grant the OWNERSHIP privilege on the schema.
• B.Grant the OWNERSHIP privilege on the database.
• C.Grant the MANAGE GRANTS global privilege.
• D.Grant ALL privileges on the schema.

Comment: *

Name: *

Email: *

Verification: *

Will data cached in a warehouse be lost when the warehouse is resized?

• A.Yes. because the compute resource is replaced in its entirety with a new compute resource.
• B.Yes. became the new compute resource will no longer have access to the cache encryption key
• C.No. because the size of the cache is independent from the warehouse size
• D.Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

Comment: *

Name: *

Email: *

Verification: *

Which of the following items does the Cloud services Layer manage? Choose 4 answers

• A.user authentication
• B.Data security
• C.Metadata
• D.Query compilation and optimization
• E.external blob storage

Comment: *

Name: *

Email: *

Verification: *