Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 503

How is unstructured data retrieved from data storage?

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

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.

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.

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.

Correct Answer: B

SQL functions can create different types of URLs that point to the unstructured data. These URLs can be used to download the data to a client. This is the most accurate method for retrieving unstructured data, as modern databases often use pre-signed URLs or similar mechanisms to secure and facilitate the transfer of unstructured data.

Discussion

KnightVictorOption: 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

EmiBOption: B

B - is correct

_yyuktaOption: 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

0e504b5Option: B

https://docs.snowflake.com/en/user-guide/unstructured-intro Scoped URL File URL Pre-signed URL

MultiCloudIronManOption: B

correct

KarBiswaOption: B

Correcting the vote to B agree its the right option

OTEOption: B

Should be B (Presigned, Scoped and File-URLs)

KarBiswaOption: 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

ShagunMittal

GET is a REST API not a SQL Function, so A is definitely incorrect

KarBiswa

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