Exam SnowPro Core topic 1 question 864 discussion

Access and download - hence C. GET_PRESIGNED_URL

The correct answer is: C. GET_PRESIGNED_URL --- Explanation: The GET_PRESIGNED_URL function generates a pre-signed URL for downloading unstructured data files from a Snowflake stage. A pre-signed URL provides temporary and secure access to the file without requiring additional authentication, making it ideal for sharing data with users or applications. Key Use Cases: Temporary Access: Allows time-limited access to files in a stage. Unstructured Data: Commonly used for files such as images, videos, or documents stored in stages. Applications and APIs: Can be used by external applications or APIs to retrieve files securely.

GET_PRESIGNED_URL -Used to download or access files without authenticating into Snowflake or passing an authorization token. Pre-signed URLs are open; any user or application can directly access or download the files. Ideal for business intelligence applications or reporting tools that need to display the unstructured file contents.

GET_PRESIGNED_URL - this should be the correct answer.

it's C : https://docs.snowflake.com/en/sql-reference/functions/get_presigned_url

A is correct

BUILD_SCOPED_FILE_URL Ideal for use in custom applications, for providing unstructured data to other accounts through a share, or for downloading and analysis of unstructured data in Snowsight.

C correct - https://docs.snowflake.com/en/user-guide/unstructured-intro