Snowflake Updated COF-C02 Exam Questions and Answers by presley

Fail-safe is a non-configurable feature in Snowflake that provides an additional layer of data protection beyond Time Travel. Time Travel allows users to access historical data within a configurable period (up to 90 days), while Fail-safe provides an additional 7-day period during which Snowflake retains historical data to recover from significant data loss or corruption incidents. This period is not accessible by users but can be used by Snowflake support to assist in data recovery efforts.References: Snowflake Documentation on Fail-safe and Time Travel

The RESULT_SCAN function returns the output of a previously executed query by referencing its query ID.

Example:

SELECT * FROM RESULT_SCAN('query_id');

Other functions like QUERY_HISTORY or TASK_HISTORY provide metadata about queries but do not return query results.

References:

Snowflake Documentation: RESULT_SCAN Function

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.

Snowflake does not support traditional large object data types like BLOB (Binary Large Object) and CLOB (Character Large Object).

Recommended alternatives:

BINARY (C): Used for binary data like images or files.

VARCHAR (E): Used for large text-based data, such as documents or logs.

References:

Snowflake Documentation: Data Types