Exam SnowPro Core topic 1 question 1002 discussion

The answer should be D - Pre-signed URL. ScopeURL you need access to stage as well.

B: Scoped url (Scoped URL Encoded URL that permits temporary access to a staged file without granting privileges to the stage.

Selected Answer: D the GET_PRESIGNED_URL function to retrieve the pre-signed URLs for a set of staged files. The example specifies 60 seconds for the EXPIRATION_TIME parameter so that the pre-signed URLs will only be accessible for one minute. CREATE OR REPLACE SECURE VIEW images_presigned_v AS SELECT GET_PRESIGNED_URL(@mystage, relative_path, 60) AS presigned_url FROM DIRECTORY(@mystage);

B - Scoped URL

Pre Signed URL need Access tokens but Scoped URL doesnt require access token and expires in 24 Hours

D - Encoded URL that permits temporary access to a staged file without granting privileges to the stage.

Answer is B Scoped URL: Encoded URL that permits temporary access to a staged file without granting privileges to the stage. The URL expires when the persisted query result period ends (i.e. the results cache expires), which is currently 24 hours. Source: https://docs.snowflake.com/en/user-guide/unstructured-intro#:~:text=Scoped%20URL,granting%20privileges%20to%20the%20stage.

D. Pre-Signed URL https://docs.snowflake.com/en/user-guide/unstructured-intro 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. Any person who has the pre-signed URL can access the referenced file for the life of the token.