Black Friday VIP Hour Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75

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

Exam GES-C02 Premium Access

View all detail and faqs for the GES-C02 exam

Practice at least 50% of the questions to maximize your chances of passing.
Viewing page 3 out of 3 pages
Viewing questions 21-30 out of questions
Questions # 21:

Which view in the ACCOUNT_USAGE schema can query token costs for Snowflake Cortex LLMs aggregated in one-hour increments?

Options:

A.

CORTEX_DOCUMENT_PROCESSING_USAGE_HISTORY

B.

CORTEX_FUNCTIONS_QUERY_USAGE_HISTORY

C.

CORTEX_FUNCTIONS_USAGE_HISTORY

D.

CORTEX_SEARCH_SERVING_USAGE_HISTORY

Questions # 22:

A Gen AI Specialist needs to determine whether feedback from a recent survey was generally positive, negative, or neutral. The Specialist wants the assessment reported as either a floating-point number from –1 to +1 (inclusive) or an object with a categories field.

Which statements will produce the desired results? (Choose two)

Options:

A.

SNOWFLAKE.CORTEX.CLASSIFY_TEXT (SURVEY_TEXT)

B.

SNOWFLAKE.CORTEX.COMPLETE (SURVEY_TEXT)

C.

SNOWFLAKE.CORTEX.ENTITY_SENTIMENT (SURVEY_TEXT, [‘positive’, ‘negative’, ‘neutral'])

D.

SNOWFLAKE.CORTEX.FINETUNE (SURVEY_TEXT);

E.

SNOWFLAKE.CORTEX.SENTIMENT (SURVEY_TEXT)

Questions # 23:

How are Snowflake Cortex Guard usage and costs calculated?

Options:

A.

Compute charges are based on the number of rows scanned in a table.

B.

Compute charges are based on the number of input tokens processed.

C.

Charges are based on the number of users accessing the date.

D.

Charges are based on the total number of billable tokens processed when queries use data in the from_text and question fields.

Questions # 24:

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;

```

Questions # 25:

Which commands can be used to display the Snowflake Cortex LLM models that are available? (Choose two)

Options:

A.

SHOW MODELS;

B.

LS @SNOWFLAKE.CORTEX.LLM;

C.

SHOW MODELS IN SNOWFLAKE.MODELS;

D.

SHOW VERSIONS LIKE 'CORTEX' IN MODEL LLM;

E.

CALL SNOWFLAKE.MODELS.CORTEX_BASE_MODELS_REFRESH();

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