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

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

How is unstructured data retrieved from data storage?

  • A. SQL functions like the GET command can be used to copy the unstructured data to a location on the client.
  • B. SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.
  • C. SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client. the unstructured data will be output to the client as files.
  • D. SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by EmiB at March 10, 2023, 8:54 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
_yyukta
9 months, 3 weeks ago
Selected Answer: B
B. SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client
upvoted 1 times
...
0e504b5
10 months, 3 weeks ago
Selected Answer: B
https://docs.snowflake.com/en/user-guide/unstructured-intro Scoped URL File URL Pre-signed URL
upvoted 1 times
...
MultiCloudIronMan
1 year, 5 months ago
Selected Answer: B
correct
upvoted 1 times
...
KnightVictor
1 year, 7 months ago
Selected Answer: B
both A & B are making sense. But since GET is not a SQL function, so A is ruled out. Hence , correct answer is B
upvoted 4 times
...
KarBiswa
1 year, 9 months ago
Selected Answer: B
Correcting the vote to B agree its the right option
upvoted 1 times
...
OTE
1 year, 9 months ago
Selected Answer: B
Should be B (Presigned, Scoped and File-URLs)
upvoted 1 times
...
KarBiswa
1 year, 9 months ago
Selected Answer: A
I will go for A because very simplistically it is telling the method to get the job done https://docs.snowflake.com/en/user-guide/unstructured-intro
upvoted 1 times
ShagunMittal
1 year, 9 months ago
GET is a REST API not a SQL Function, so A is definitely incorrect
upvoted 1 times
KarBiswa
1 year, 9 months ago
may be the language is not proper but to get the data we need to use SQL functions like GET_PRESIGNED_URL and then url will be fetched for the object
upvoted 1 times
...
...
...
EmiB
1 year, 9 months ago
Selected Answer: B
B - is correct
upvoted 2 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