SnowPro Core Certification — Question 554

How is unstructured data retrieved from data storage?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer, B, highlights that SQL functions can create URLs that link to unstructured data, which can be downloaded. Option A is incorrect because the GET command is not typically used for copying unstructured data in this context. Option C misrepresents how unstructured data is handled, as it does not simply output files from a cache. Option D speaks to web extensions but does not address the retrieval of unstructured data properly.