Free COF-C03 Questions Attempt

The type of Snowflake table that persists until it is explicitly dropped, is available for all users with relevant privileges across sessions, and does not have a Fail-safe period, is a Transient table. Transient tables are designed to provide temporary storage similar to permanent tables but with some reduced storage costs and without the Fail-safe feature, which provides additional data protection for a period beyond the retention time. Transient tables are useful in scenarios where data needs to be temporarily stored for longer than a session but does not require the robust durability guarantees of permanent tables.

The command used to export or unload data from Snowflake to a stage (such as a file in an S3 bucket, Azure Blob Storage, or Google Cloud Storage) is thePUTcommand. ThePUTcommand is designed to upload data files from a local file system (in the case of SnowSQL or other client) or a virtual warehouse to a specified stage. This functionality is critical for scenarios where data needs to be extracted from Snowflake for use in external systems, backups, or further processing.

The syntax for thePUTcommand follows the structure:PUT file:// < local_file_path > @ < stage_name > , where < local_file_path > specifies the path to the file(s) on the localfile system that you wish to upload, and < stage_name > specifies the destination stage in Snowflake.

It ' s important to distinguish that thePUTcommand is used for exporting data out of Snowflake, whereas theCOPY INTO < table > command is used for importing data into Snowflake from a stage. TheGETcommand, on the other hand, is used to download files from a stage to the local file system, essentially the inverse operation of thePUTcommand.

The correct answer is D. Temporary .

A temporary table exists only for the duration of the session in which it was created. It is only visible to the user session that created it and is automatically dropped when the session ends.

Why D is correct:

Temporary tables are useful for session-specific intermediate data. They do not persist beyond the session and are not visible to other users or sessions.

Example:

CREATE TEMPORARY TABLE temp_sales AS

SELECT *

FROM sales

WHERE sales_date = CURRENT_DATE;

Why the other options are incorrect:

A. Hybrid tables are optimized for transactional workloads and are not session-only objects.

B. Dynamic tables are used for declarative, automated data transformation and are persistent database objects.

C. Transient tables persist until explicitly dropped and are visible according to granted privileges. They do not have Fail-safe, but they are not session-only.

Official Snowflake documentation reference:

Snowflake documentation describes temporary tables as existing only within the session in which they are created and being dropped automatically at the end of the session.