How is unstructured data retrieved from data storage?

Question

Options

• ASQL functions like the GET command can be used to copy the unstructured data to a location on
• BSQL functions can be used to create different types of URLs pointing to the unstructured data.
• CSQL functions can be used to retrieve the data from the query results cache. When the query
• DSQL functions can call on different web extensions designed to display different types of files as a

• A
  3% (1)
• B
  90% (26)
• C
  7% (2)

Explanation

Snowflake provides SQL functions to generate different types of URLs for accessing unstructured data files stored in stages: pre-signed URLs (for unauthenticated temporary access), scoped URLs (for authenticated, time-limited access within Snowflake), and file URLs (for persistent authenticated access). These URL-generating functions allow applications to retrieve and serve the raw unstructured files (images, PDFs, audio, etc.) without loading them into a table. The query results cache (C) is not applicable to unstructured file retrieval. Snowflake does not provide web extension rendering (D) or a GET-style copy command (A) as the primary retrieval mechanism for unstructured data.

No community discussion yet for this question.