Snowpro Core · Free Practice Question Easy
Question 29
Which of the following SQL functions is used to generate a pre-signed URL for accessing unstructured data in Snowflake?
-
A
BUILD_SCOPED_FILE_URL
-
B
GET_PRE_SIGNED_URL
-
C
BUILD_STAGE_FILE_URL
-
D
GET_FILE_ACCESS_URL
Reveal correct answer
Correct answer: B
A.
BUILD_SCOPED_FILE_URL provides temporary access based on Snowflake's persisted query result period, which is not the same as a configurable pre-signed URL.
B.
The GET_PRE_SIGNED_URL function is used to create a temporary HTTPS URL that can be used to access unstructured data (e.g., files) stored in Snowflake. This URL can be configured with an expiration time.
C.
BUILD_STAGE_FILE_URL generates a permanent URL for a file but does not allow setting expiration like a pre-signed URL.
D.
There is no function named GET_FILE_ACCESS_URL in Snowflake.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
