COF-C02 Practice Questions

Snowflake recommends creating objects with a role that has the necessary privileges and is not

overly permissive. SYSADMIN is typically used for managing system-level objects and operations.

Creating objects with a custom role and granting this role to SYSADMIN allows for more granular

control and adherence to the principle of least privilege.

Based on best practices for

database object ownership and role management.

:

Snowflake data providers can share data residing in different databases through secure views.

Secure views allow for the referencing of objects such as schemas, tables, and other views contained

in one or more databases, as long as those databases belong to the same account. This enables

providers to share data securely and efficiently with consumers.

[COF-C02] SnowPro

Core Certification Exam Study Guide

The supported file formats for unloading data from Snowflake include JSON, Parquet, and CSV. These

formats are commonly used for their flexibility and compatibility with various data processing tools

The correct statement to accommodate the request for a marketing co-worker to change the size of

their medium virtual warehouse called mktg__WH is to grant the MODIFY privilege on the

warehouse to the ROLE MARKETING. This privilege allows the role to change the warehouse size

among other properties.

[COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Access Control Privileges1

Snowflake provides Multi-Factor Authentication (MFA) support as an integrated feature, powered by

the Duo Security service. This service is managed completely by Snowflake, and users do not need to

sign up separately with Duo1

The minimum Snowflake edition required to use Dynamic Data Masking is the Enterprise

edition. This feature is not available in the Standard edition2.

When unloading data to a stage, it is recommended to define an individual file format. This ensures

that the data is unloaded in a consistent and expected format, which can be crucial for downstream

processing and analysis2

Users are responsible for data storage costs in Snowflake until the data expires from the Fail-safe

period. Fail-safe is the final stage in the data lifecycle, following Time Travel, and provides additional

protection against accidental data loss. Once data exits the Fail-safe state, users are no longer billed

for its storage

The ACCESS_HISTORY view in Snowflake is utilized to support compliance auditing. It provides

detailed information on data access within Snowflake, including reads and writes by user

queries. This view is essential for regulatory compliance auditing as it offers insights into the usage of

tables and columns, and maintains a direct link between the user, the query, and the accessed data1.

[COF-C02] SnowPro Core Certification Exam Study Guide