ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 699 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 699
Topic #: 1
[All SnowPro Core Questions]

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

  • A. BUILD_STAGE_FILE_URL
  • B. BUILD_SCOPED_FILE_URL
  • C. GET_PRESIGNED_URL
  • D. GET_STAGE_LOCATION
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by happykeieiekek at July 14, 2023, 6:49 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
ukpino
Highly Voted 1 year, 3 months ago
Selected Answer: 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.
upvoted 5 times
...
Learner21525
Most Recent 11 months, 3 weeks ago
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> )
upvoted 3 times
0e504b5
9 months ago
Thank you, this is helpful. Source docs: https://docs.snowflake.com/en/sql-reference/functions-file
upvoted 2 times
...
...
kayuhanbiduk
1 year ago
Selected Answer: A
It's File URL
upvoted 3 times
...
pvskbrod
1 year, 2 months ago
Selected Answer: B
https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url
upvoted 1 times
pvskbrod
1 year, 2 months ago
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
upvoted 1 times
...
...
MultiCloudIronMan
1 year, 3 months ago
Selected Answer: 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=
upvoted 1 times
MultiCloudIronMan
1 year, 3 months ago
Its "A" sorry
upvoted 1 times
...
...
happykeieiekek
1 year, 4 months ago
Answer is A BUILD_STAGE_FILE_URL( @<stage_name> , '<relative_file_path>' )
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago