Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 699

Which function generates a Snowflake hosted file URL to a staged file using the stage name and relative file path as inputs?

    Correct Answer: A

    The correct function to generate a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs is BUILD_STAGE_FILE_URL. This function is specifically designed to create a URL for accessing files in a Snowflake stage, ensuring that users can retrieve the file using the provided stage name and file path.

Discussion
ukpinoOption: A

BUILD_STAGE_FILE_URL Generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs. A file URL permits prolonged access to a specified file. That is, the file URL does not expire.

Learner21525Option: A

Build stage file url BUILD_STAGE_FILE_URL( @<stage_name> , '<relative_file_path>' ) BUILD_SCOPED_FILE_URL BUILD_SCOPED_FILE_URL( @<stage_name> , '<relative_file_path>' ) GET_PRESIGNED_URL GET_PRESIGNED_URL( @<stage_name> , '<relative_file_path>' , [ <expiration_time> ] ) GET_ABSOLUTE_PATH GET_ABSOLUTE_PATH( @<stage_name> , '<relative_file_path>' ) GET_RELATIVE_PATH GET_RELATIVE_PATH( @<stage_name> , '<absolute_file_path>' ) GET_STAGE_LOCATION GET_STAGE_LOCATION( @<stage_name> )

0e504b5

Thank you, this is helpful. Source docs: https://docs.snowflake.com/en/sql-reference/functions-file

kayuhanbidukOption: A

It's File URL

happykeieiekekOption: A

Answer is A BUILD_STAGE_FILE_URL( @<stage_name> , '<relative_file_path>' )

pvskbrodOption: B

https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url

pvskbrod

BUILD_SCOPED_FILE_URL: Generates a scoped Snowflake-hosted URL to a staged file using the stage name and relative file path as inputs BUILD_STAGE_FILE_URL Generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs when I went through both I am willing to change my mind to A. The descriptions are almost like but not the same

MultiCloudIronManOption: B

https://www.bing.com/search?q=Which+function+generates+a+Snowflake+hosted+file+URL+to+a+staged+file+using+the+stage+name+and+relative+file+path+as+inputs%3F&qs=n&form=QBRE&sp=-1&lq=1&pq=which+function+generates+a+snowflake+hosted+file+url+to+a+staged+file+using+the+stage+name+and+relative+file+path+as+inputs%3F&sc=1-124&sk=&cvid=5528116F9D4748FBB98781BDF20E3EBA&ghsh=0&ghacc=0&ghpl=

MultiCloudIronMan

Its "A" sorry