COF-C03 Exam Dumps - SnowPro Core Certification 2026 Exam

SPLIT_TO_TABLE() is a table function that splits a string into multiple rows based on a delimiter. To use it correctly in SQL, you must wrap it in a TABLE() clause.

Correct Syntax:

SELECT * FROM TABLE(SPLIT_TO_TABLE( ' a.b.c ' , ' . ' ));

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 A. GET_RELATIVE_PATH .

The GET_RELATIVE_PATH function is used to return the relative path of a staged file. The relative path identifies the file name and path of the file within the stage.

Why A is correct:

A file stored in a stage can be referenced by its relative path. GET_RELATIVE_PATH retrieves that relative path, which includes the file name.

Why the other options are incorrect:

B. GET_STAGE_LOCATION returns the URL or location of a stage, not the filename of a specific staged file.

C. BUILD_STAGE_FILE_URL creates a URL for accessing a staged file, but it is not used simply to retrieve the filename.

D. GET_OBJECT_REFERENCES is related to object references, not staged file names.

Official Snowflake documentation reference:

Snowflake documentation describes GET_RELATIVE_PATH as a function that returns the relative path for a staged file.

For Snowpipe auto-ingest on Amazon S3, cloud event notifications are configured so Snowflake is notified when new files arrive. The pipe must also be created with AUTO_INGEST = TRUE.

Why A and D are correct:

Amazon S3 event notifications can publish file arrival events through Amazon SNS/SQS integration, and Snowpipe uses those notifications when AUTO_INGEST is enabled.