nerdexam
Snowflake

COF-C02 · Question #406

A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access. Which file function should be used?

The correct answer is C. GET_PRESIGNED_URL. The GET_PRESIGNED_URL function in Snowflake generates a presigned URL for a file stored in an internal stage, allowing direct access to the file without requiring Snowflake access. This feature is particularly useful for sharing unstructured data with external applications or…

Data Protection and Data Sharing

Question

A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access. Which file function should be used?

Options

  • ABUILD_SCOPED_FILE_URL
  • BBUILD_STAGE_FILE_URL
  • CGET_PRESIGNED_URL
  • DGET STAGE LOCATION

How the community answered

(22 responses)
  • B
    5% (1)
  • C
    91% (20)
  • D
    5% (1)

Explanation

The GET_PRESIGNED_URL function in Snowflake generates a presigned URL for a file stored in an internal stage, allowing direct access to the file without requiring Snowflake access. This feature is particularly useful for sharing unstructured data with external applications or tools that do not have direct access to Snowflake. The presigned URL provides temporary access to the file, making it an ideal solution for securely sharing unstructured data from an internal stage with a reporting tool or any other external application.

Topics

#Presigned URL#Unstructured Data#Internal Stage#External Sharing

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice