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

Pass the Snowflake SnowPro Specialty GES-C02 Questions and answers with CertsForce

Viewing page 3 out of 3 pages
Viewing questions 21-30 out of questions
Questions # 21:

Which function calculates the Manhattan distance between two points in a vector space?

Options:

A.

VECTOR_INNER_PRODUCT


B.

VECTOR_L1_DISTANCE


C.

VECTOR_L2_DISTANCE


D.

VECTOR_COSINE_SIMILARITY


Expert Solution
Questions # 22:

Which Snowflake Cortex AI observability metrics are used to evaluate LLM-generated responses? (Choose two)

Options:

A.

Accuracy


B.

Coherence


C.

Correctness


D.

F1 Score


E.

Precision


Expert Solution
Questions # 23:

A Gen AI Specialist wants to use a Snowflake Cortex LLM function to classify customer questions into two categories: support and food.

The Specialist created a table named QUERIES containing the following values:

| ID | QUERY_TEXT |

| :--- | :--- |

| 1 | How do I reset my account password? |

| 2 | Where’s the best sushi place in town? |

| 3 | I need help with a billing issue. |

Which command should be used?

```sql

Options:

A.

SELECT id, SNOWFLAKE.CORTEX.CLASSIFY_TEXT(query_text) AS category

FROM QUERIES;


B.

SELECT id, SNOWFLAKE.CORTEX.CLASSIFY_TEXT(query_text, ['support', 'food']) AS category

FROM QUERIES;


C.

SELECT id, SNOWFLAKE.CORTEX.CLASSIFY_TEXT(['support', 'food'], query_text) AS category

FROM QUERIES;


D.

SELECT id, SNOWFLAKE.CORTEX.CLASSIFY_TEXT(

model = > 'mistral-large',

INPUT = > query_text,

LABELS = > ['support', 'food']

) AS category

FROM QUERIES;

```


Expert Solution
Questions # 24:

Which Cortex functions support a parameterized option that can be used to filter unsafe and harmful responses from LLMs? (Choose two)

Options:

A.

TRANSLATE()


B.

CLASSIFY_TEXT()


C.

SUMMARIZE()


D.

TRY_COMPLETE()


E.

COMPLETE()


Expert Solution
Questions # 25:

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

Options:

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;

```


Expert Solution
Viewing page 3 out of 3 pages
Viewing questions 21-30 out of questions