nerdexam
Snowflake

COF-C02 · Question #393

Which file function gives a user or application access to download unstructured data from a Snowflake stage?

The correct answer is C. GET_PRESIGNED_URL. GET_PRESIGNED_URL generates a temporary, pre-signed URL that allows anyone (including external users and applications) to download a specific file from a Snowflake stage without needing Snowflake credentials or an active session. This makes it ideal for distributing…

Data Loading and Unloading

Question

Which file function gives a user or application access to download unstructured data from a Snowflake stage?

Options

  • ABUILD_SCOPED_FILE_URL
  • BBUILD_STAGE_FILE_URL
  • CGET_PRESIGNED_URL
  • DGET STAGE LOCATION

How the community answered

(54 responses)
  • A
    2% (1)
  • B
    4% (2)
  • C
    93% (50)
  • D
    2% (1)

Explanation

GET_PRESIGNED_URL generates a temporary, pre-signed URL that allows anyone (including external users and applications) to download a specific file from a Snowflake stage without needing Snowflake credentials or an active session. This makes it ideal for distributing unstructured data. BUILD_STAGE_FILE_URL requires Snowflake authentication to use, BUILD_SCOPED_FILE_URL is session-scoped and not suitable for external sharing, and GET_STAGE_LOCATION returns only the base location of a stage rather than a downloadable link to a specific file.

Topics

#Snowflake stages#Unstructured data#Presigned URLs#Data downloading

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice