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
Which view in the ACCOUNT_USAGE schema can query token costs for Snowflake Cortex LLMs aggregated in one-hour increments?
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)
How are Snowflake Cortex Guard usage and costs calculated?
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
Which commands can be used to display the Snowflake Cortex LLM models that are available? (Choose two)