Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Snowflake SnowPro Specialty: Gen AI Exam GES-C02 Question # 25 Topic 3 Discussion

Snowflake SnowPro Specialty: Gen AI Exam GES-C02 Question # 25 Topic 3 Discussion

GES-C02 Exam Topic 3 Question 25 Discussion:
Question #: 25
Topic #: 3

A Gen AI Specialist is building a pipeline in Snowflake to gather data that will be used to summarize customer chat messages.

The following table, CHAT_MESSAGES, was created:

| CONVERSATION_ID | MESSAGE_TEXT |

| :--- | :--- |

| 1 | Hi, I need help with my order. |

| 2 | It’s not been delivered yet. |

| 2 | How can I reset my password? |

| 3 | I received the wrong item. |

| 3 | Can I exchange it? |

The Specialist wants to use the Snowflake Cortex COMPLETE function with the llama3-8b model to generate a summary of each conversation. The prompt should begin with: "Summarize this chat:" followed by the full text of all messages in that chat conversation.

Which query will achieve this?

```sql


A.

SELECT

conversation_id,

SNOWFLAKE.CORTEX.COMPLETE('llama3-8b', 'Summarize this chat:' || message_text) AS summary_text

FROM CHAT_MESSAGES;


B.

SELECT

conversation_id,

SNOWFLAKE.CORTEX.COMPLETE('llama3-8b', 'Summarize this chat:' || ARRAY_AGG(message_text)) AS summary_text

FROM CHAT_MESSAGES;


C.

SELECT

conversation_id,

SNOWFLAKE.CORTEX.COMPLETE('llama3-8b', 'Summarize this chat:' || LISTAGG(message_text)) AS summary_text

FROM CHAT_MESSAGES

GROUP BY conversation_id;


D.

SELECT

conversation_id,

SNOWFLAKE.CORTEX.COMPLETE('llama3-8b', message_text) AS summary_text

FROM CHAT_MESSAGES

GROUP BY conversation_id;

```


Get Premium GES-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.