PDF COF-C03 Study Guide

To list all network policies available in an account, the correct command isSHOW NETWORK POLICIES. Network policies in Snowflake are used to define and enforce rules for how users can connect to Snowflake, including IP whitelisting and other connection requirements. TheSHOW NETWORK POLICIEScommand provides a list of all network policies defined within the account, along with their details.

TheDESCRIBE SESSION POLICYandDESCRIBE NETWORK POLICYcommands do not exist in Snowflake SQL syntax. TheSHOW SESSION POLICIEScommand is also incorrect, as it does not pertain to the correct naming convention used by Snowflake for network policy management.

UsingSHOW NETWORK POLICIESwithout any additional parameters will display all network policies in the account, which is useful for administrators to review and manage the security configurations pertaining to network access.

Snowflake CLI can obtain connection parameters from multiple sources. When the same connection parameter is specified in more than one place, the higher-precedence source overrides the lower-precedence source.

An environment variable such as SNOWFLAKE_ROLE overrides the role configured for the connection in config.toml. Therefore, when SNOWFLAKE_ROLE=SYSADMIN is present, the CLI session uses SYSADMIN, even when the selected connection specifies another role.

A missing warehouse does not cause Snowflake CLI to ignore the configured role. A user’s default role can also be overridden when another valid role is explicitly supplied through a higher-precedence configuration source.

Snowflake implements Discretionary Access Control (DAC) by using a role-based access control model. In this model, access privileges are not directly assigned to individual objects or users but are encapsulated within roles. These roles are then assigned to users, effectively granting them the access privileges contained within the role. This approach allows for granular control over database access, making it easier to manage permissions in a scalable and flexible manner.