SNOWPRO-CORE Practice Questions

Snowflake retains information in the ACCESS HISTORY view for 365 days. This allows users to query

the access history of Snowflake objects within the last year1.

The BUILD_STAGE_FILE_URL function generates a Snowflake-hosted file URL to a staged file using the

stage name and relative file path as inputs2.

While Snowflake primarily deals with structured and semi-structured data, it also has the capability

to handle unstructured data. Unstructured data can be stored in Snowflake using variants of SQL data

types in tables, which can be permanent tables. These permanent tables, while traditionally used for

structured or semi-structured data (like JSON, Avro, or Parquet), can also accommodate unstructured

data in the form of binary formats or strings, offering flexibility in data storage and analysis.

However, the management and querying of unstructured data in Snowflake may require additional

considerations compared to structured data.

Reference: Snowflake Documentation on Data Types

A cached MFA token is valid for up to four hours. https://docs.snowflake.com/en/userguide/security-mfa#using-mfa-token-caching-to-minimize-the-number-of-prompts-during-

authentication-optional

Snowflake’s Time Travel feature is used for the maintenance of historical data, allowing users to

access and restore data that has been changed or deleted within a defined period4.

The Snowflake edition that enables data sharing only through Snowflake Support is the Virtual

Private Snowflake (VPS). By default, VPS does not permit data sharing outside of the VPS

environment, but it can be enabled through Snowflake Support4.

One of the characteristics of materialized views in Snowflake is that they allow multiple tables to be

joined in the underlying query. This enables the pre-computation of complex queries involving joins,

which can significantly improve the performance of subsequent queries that access the materialized

view4. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

The RETURN_ERRORS value in the VALIDATION_MODE option of the COPY command instructs

Snowflake to validate the data files and return errors encountered across all specified files, including

those that were partially loaded during an earlier load2. Reference: [COF-C02] SnowPro Core

Certification Exam Study Guide

The REST API used with unstructured data in Snowflake is GET /api/files/, which retrieves

(downloads) a data file from an internal or external stage4.

A masking policy in Snowflake consists of a single data type, with one or more conditions, and one or

more masking functions. These components define how the data is masked based on the specified

conditions3.