nerdexam
Snowflake

COF-C02 · Question #597

What can be used to process unstructured data?

The correct answer is C. External functions. External functions allow Snowflake to call remote services (e.g., AWS Lambda, Azure Functions, or a custom REST API) to process data that Snowflake cannot handle natively - including unstructured data like images, audio, or PDFs. The external service performs the processing and…

Data Transformations

Question

What can be used to process unstructured data?

Options

  • AExternal tables
  • BThe copy into <table> command
  • CExternal functions
  • DSnowpipe

How the community answered

(35 responses)
  • B
    3% (1)
  • C
    94% (33)
  • D
    3% (1)

Explanation

External functions allow Snowflake to call remote services (e.g., AWS Lambda, Azure Functions, or a custom REST API) to process data that Snowflake cannot handle natively - including unstructured data like images, audio, or PDFs. The external service performs the processing and returns results to Snowflake. External tables (A) expose files in cloud storage as queryable tables but do not process unstructured content. COPY INTO <table> (B) and Snowpipe (D) are data ingestion tools, not data processing tools for unstructured formats.

Topics

#External Functions#Unstructured Data Processing#Extensibility#Serverless Integration

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice