Explanation:
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.
Ultimate access to all questions.
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.
No comments yet.