The SnowPro Core Certification Exam (COF-C02)

In a Snowflake Query Profile, the statistics " Partitions scanned " and " Bytes scanned " reflect the efficiency of query pruning. Query pruning refers to the ability of the query engine to skip unnecessary data, thereby reducing the amount of data that needs to be processed. Efficient pruning results in fewer partitions and bytes being scanned, improving query performance.

Snowflake Documentation: Understanding Query Profiles

Top of Form

Bottom of Form

In Snowflake, network policies define the allowed IP address ranges from which users can connect to Snowflake, enhancing security by restricting access based on network location. The creation and management of network policies require sufficient privileges. Specifically, a user with theSECURITYADMINrole or any role with higher privileges, such asACCOUNTADMIN, can create network policies. Additionally, a custom role can be granted theCREATE NETWORK POLICYprivilege, enabling users assigned to that role to also create network policies. This approach allows for flexible and secure management of network access to Snowflake.

In Snowflake, a table ' s clustering depth indicates the degree of micro-partition overlap based on the clustering keys defined for the table. A clustering depth of 1 implies that the table has no overlapping micro-partitions. This is an optimal scenario, indicating that the table ' s data is well- clustered according to the specified clustering keys. Well-clustered data can lead to more efficient query performance, as it reduces the amount of data scanned during query execution and improves the effectiveness of data pruning.

When a user is granted a custom role , they inherit only the privileges assigned to that role . This is aligned with the principle of least privilege in RBAC.

Access History in Snowflake is a feature designed to support auditing by tracking access to data within Snowflake, including when a user ' s query reads column data. It provides detailed information on queries executed, including the user who ran the query, the query text, and the objects (e.g., tables, views) accessed by the query. This feature is instrumental for auditing purposes, helping organizations to monitor and audit data access for security and compliance.

For users assigned theACCOUNTADMINrole, Snowflake recommends enforcing Multi-Factor Authentication (MFA) to enhance security. TheACCOUNTADMINrole has extensive permissions, making it crucial to secure accounts held by such users against unauthorized access. MFA adds an additional layer of security by requiring a second form of verification beyond just the username and password, significantly reducing the risk of account compromise.

When unloading data using the COPY INTO < location > command, Snowflake offers options to compress files. The default behavior is governed by the COMPRESSION parameter. Setting COMPRESSION = AUTO allows Snowflake to automatically use its default compression algorithm, which is GZIP for most formats like CSV.

In Snowflake, the default access level for any securable object (such as a table, view, or schema) is " No access " until explicit access is granted. This means that when an object is created, only the owner of the object and roles with the necessary privileges can access it. Other users or roles will not have any form of access to the object until it is explicitly granted.

This design adheres to the principle of least privilege, ensuring that access to data is tightly controlled and that users and roles only have the access necessary for their functions. To grant access, the owner of the object or a role with the GRANT option can use the GRANT statement to provide specific privileges to other users or roles.

For example, to grant SELECT access on a table to a specific role, you would use a command similar to:

GRANTSELECTONTABLEmy_tableTOROLE my_role;

Snowsight, the Snowflake user interface, supports a variety of chart types for data visualization, including line charts and pie charts. These chart types help users analyze and interpret data more effectively.

Line Charts:Useful for showing trends over time or comparing different data sets.

Pie Charts:Ideal for displaying proportions and percentages within a dataset.