Snowflake Updated COF-C02 Exam Questions and Answers by santiago

Transient Tables:

These are storage objects designed to store data beyond a single session.

They do not incur Fail-safe costs, making them more cost-effective than permanent tables for temporary or intermediate data storage.

Why Other Options Are Incorrect:

A. Permanent table: Supports Fail-safe and incurs additional costs.

B. External table: Stores metadata for external data but does not store actual data.

C. Temporary table: Data persists only within a session and is not suitable for multi-session use.

References:

Transient Tables Documentation

Stored procedures can execute both DDL (Data Definition Language) and DML (Data Manipulation Language) statements.

Example: A stored procedure can create a table (DDL) and insert data into it (DML) in the same execution block.

Other objects like UDFs and UDTFs are limited to returning values or sets of rows, and cannot perform DDL/DML operations.

References:

Snowflake Documentation: Stored Procedures

To use key pair authentication in Snowflake, you need to set the public key for the user. This allows the user to authenticate using their private key.

Generate Key Pair: Generate a public and private key pair.

Set Public Key:

ALTER USER jsmith SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...';

Authentication: The user can now authenticate by signing requests with the corresponding private key.

References:

Snowflake Documentation: Key Pair Authentication & Key Rotation

Snowflake Documentation: ALTER USER

The RESULT_SCAN table function is used in Snowflake to perform additional processing on the results of a previously-run query. It allows users to reference the result set of a previous query by its query ID, enabling further analysis or transformations without re-executing the original query.

References:

Snowflake Documentation: RESULT_SCAN