SnowPro Specialty Gen AI GES-C01

By Snowflake · Question Mode

QuestionQ21

VerifiedSnowflake Gen AI & LLM Functions

A table in a pipeline has a VARCHAR column that contains free-form text responses. A Ger AI Specialist must generate three new columns from those text responses.

How should this requirement be fulfilled?

Choose two
Explanation

SNOWFLAKE.CORTEX.COMPLETE supports a response_format JSON schema, allowing a completion to return a structured object whose three named properties can be projected into separate columns. SNOWFLAKE.CORTEX.EXTRACT_ANSWER returns a string answer to one specified question from a text document, so one invocation per requested value can populate three separate columns.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!