Which security features are used to control inbound access to Snowflake and internal stages? (Choose two.)

• A.Network rules
• B.Feature policies
• C.Network policies
• D.Packages policies
• E.Authentication policies

Comment: *

Name: *

Email: *

Verification: *

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

• A.The cloned views and the stored procedures will reference the cloned tables in the cloned database.
• B.An error will occur, as views with qualified references cannot be cloned.
• C.An error will occur, as stored objects cannot be cloned.
• D.The stored procedures and views will refer to tables in the source database.

Comment: *

Name: *

Email: *

Verification: *

What is the minimum Snowflake edition required to create a materialized view?

• A.Standard Edition
• B.Enterprise Edition
• C.Business Critical Edition
• D.Virtual Private Snowflake Edition

Comment: *

Name: *

Email: *

Verification: *

Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)

• A.Range searches
• B.Equality searches
• C.Substring searches
• D.Queries with IN predicates
• E.Queries with aggregation

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