Snowflake Network Policies Worksheet

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

• Is available to all Snowflake Editions

• Is only available to customers with Business Critical Edition

• Restricts or enables access to specific IP addresses

• Is activated using an ALTER DATABASE command

Network policies can be set at which Snowflake levels?

• Schema

• Role

• Account

• Database

• User

What is the order of precedence (highest to lowest) of network policies when applied at the account, user, and security integrations layers?

• Account, user, security integration

• Account, security integration, user

• User, security integration, account

• Security integration, user, account

Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

• OAuth

• Network policies

• Single Sign-On (SSO)

• Multi-Factor Authentication (MFA) (Correcta)

What will prevent unauthorized access to a Snowflake account from an unknown source?

• Network policy

• End-to-end encryption

• Multi-Factor Authentication (MFA)

• Role-Based Access Control (RBAC)

Who can activate and enforce a network policy for all users in a Snowflake account?

• A user with a USERADMIN or higher role

• A user with a SECURITYADMIN or higher role

• A role that has been granted the ATTACH POLICY privilege

• A role that has the NETWORK_POLICY account parameter set

• A role that has the OWNERSHIP of the network policy

Which feature of Snowflake’s Continuous Data Protection (CDP) has associated costs?

• Fail-safe

• Network policies

• End-to-end encryption

• Multi-Factor Authentication (MFA)

Which command can be used to list all network policies available in an account?

• SHOW NETWORK POLICIES

• LIST ALL POLICIES

• DISPLAY NETWORK RULES

• GET NETWORK POLICIES

How are network policies defined in Snowflake?

• They are a set of rules that define the network routes within Snowflake.

• They are a set of rules that dictate how Snowflake accounts can be used between multiple users.

• They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.

• They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect to Snowflake.

What happens when a network policy includes values that appear in both the allowed and blocked IP address lists?

• Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.

• Those IP addresses are denied access to the Snowflake account as Snowflake applies the blocked IP address list first.

• Snowflake issues an alert message and adds the duplicate IP address values to both the allowed and blocked IP address lists.

• Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address lists.