Answer-first summary for fast verification
Answer: 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.
The correct answer is B because Snowflake provides SQL functions like GET_PRESIGNED_URL, BUILD_SCOPED_FILE_URL, and BUILD_STAGE_FILE_URL that generate URLs to access unstructured data stored in stages. These URLs can then be used to download the data to a client. Option A is incorrect because GET is a REST API command, not a SQL function. Option C is wrong as query results cache doesn't contain unstructured data files for download. Option D is incorrect because web extensions are not the primary mechanism for downloading unstructured data files in Snowflake.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How is unstructured data accessed after it has been stored?
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.