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 492 discussion

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

Which function returns the URL of a stage using the stage name as the input?

  • 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: D 🗳️
by lalit_2k311 at Feb. 21, 2023, 12:17 p.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
bibisa
Highly Voted 2 years, 3 months ago
Selected Answer: D
Retrieves the URL for an external or internal named stage using the stage name as the input.
upvoted 7 times
...
lalit_2k311
Highly Voted 2 years, 4 months ago
Answer id D https://docs.snowflake.com/en/sql-reference/functions/get_stage_location
upvoted 7 times
...
PrasantSadangi
Most Recent 2 months, 3 weeks ago
Selected Answer: D
GET_STAGE_LOCATION Retrieves the URL for an external or internal named stage using the stage name as the input. Syntax GET_STAGE_LOCATION( @<stage_name> )
upvoted 1 times
...
37ceea2
7 months ago
Selected Answer: A
GET STAGED URL does not exist. It is obvious A. Build_Stage_File_URL. I have serious doubts related to the competence and quality of these answers
upvoted 2 times
Shipra123
7 months ago
Get_Stage_Location- Generates the URL using Stage name as input. In the question is asking the same. So answer is Get_Stage_location.
upvoted 1 times
...
...
_yyukta
1 year, 3 months ago
Selected Answer: D
D. GET_STAGE_LOCATION
upvoted 1 times
...
Snow_P
1 year, 10 months ago
Selected Answer: C
The GET_PRESIGNED_URL function in Snowflake is used to obtain a pre-signed URL for a stage object. This URL allows temporary access to the stage object and can be used for operations like copying data into or out of the stage.
upvoted 1 times
akb33
1 year, 4 months ago
GET_PRESIGNED_URL function also gives out the relative path along with the stage name as URL.
upvoted 1 times
...
...
Def21
2 years ago
Selected Answer: C
D) Gives STAGE and uses the STAGE name SELECT GET_STAGE_LOCATION(@images_stage); => s3://photos/national_parks/us/yosemite/ A) Gives file SELECT BUILD_STAGE_FILE_URL(@images_stage,'/us/yosemite/half_dome.jpg'); => https://my_account.snowflakecomputing.com/api/files/MY_DB/PUBLIC/IMAGES_STAGE/us/yosemite/half_dome.jpg https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url https://docs.snowflake.com/en/sql-reference/functions/get_stage_location
upvoted 1 times
...
MultiCloudIronMan
2 years, 2 months ago
Selected Answer: D
Verified
upvoted 1 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