Snowflake GES-C02 SnowPro Specialty: Gen AI Exam Exam Practice Test
SnowPro Specialty: Gen AI Exam Questions and Answers
Review this metadata from a SNOWFLAKE.CORTEX.COMPLETE function response:
```json
"usage": {
"completion_tokens": 580,
"guardrails_tokens": 565,
"prompt_tokens": 61,
"total_tokens": 1206
}
```
Which model parameters were used in the function?
```json
How does Snowflake Cortex Analyst enable multi-turn conversations while preserving context across user interactions?
Which Snowflake Cortex feature or function lets users ask questions in natural language and get direct responses without having to write SQL code?
A Gen AI Specialist is developing a Streamlit chatbot that uses `snowflake.cortex.complete` to answer user questions with this script:
```python
import streamlit as st
import snowflake.cortex
from snowflake.cortex import CompleteOptions
if prompt := st.chat_input("How can I help you?"):
with st.chat_message(name="User"):
st.write(prompt)
with st.chat_message("assistant"):
response = snowflake.cortex.complete(
"claude-3-5-sonnet",
[dict(role="user", content=prompt)],
)
```
Which parameter should be added to the script so responses display incrementally in small chunks as they are generated?
Which action is supported when using Snowflake Document AI?
A user opened the Snowflake Cortex LLM Playground in the AI & ML Studio within Snowsight, selected gemma-7b from the Standard models drop-down list, and typed "What is Gen AI?" into the dialog box.
Which SQL statement will achieve the same result?
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
A company is organizing an event and asked participants about their food restrictions. The responses have been saved in a table named EVENT_REGISTRATIONS:
| ID | FOOD_RESTRICTIONS |
| :--- | :--- |
| 1 | allergic to nuts |
| 2 | no gluten |
| 3 | no milk or dairy products |
| 4 | no meat |
Which query will compile a list of foods that should not be served?
```sql
When using the SNOWFLAKE.CORTEX.FINETUNE function, which column names must be included in the SQL statement supplied in the training_data_query parameter? (Choose two)
A Gen AI Specialist is creating metadata for Snowflake Cortex Analyst by creating a semantic model. The relationship between the PRODUCTS and PRODUCT_SALES tables is defined as:
```yaml
relationships:
- name: sales_to_products
join_type: left_outer
relationship_type: many_to_one
left_table: PRODUCT_SALES
relationship_columns:
- left_column: PRODUCT_ID
right_column: ID
right_table: PRODUCTS
```
Which join will Cortex Analyst generate in a query that uses this model?
```sql
Which SQL functions are designed and optimized to carry out and automate specific routine tasks within Snowflake Cortex? (Choose two)
A Gen AI Specialist requires a solution that supports asking questions in natural language and receiving answers based on structured data in Snowflake without using SQL.
How can this be achieved? (Choose two)
A table in a pipeline has a VARCHAR column that contains free-form text responses. A Gen AI Specialist must generate three new columns from those text responses.
How should this requirement be fulfilled? (Choose two)
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 available Snowflake Cortex LLM models? (Choose two)
A Gen AI Specialist uploaded a PDF named Timesheet_report.pdf to a Snowflake stage. The PDF includes a table with the following structure:
| Date | Hours | Activity |
| :--- | :--- | :--- |
| 2025-04-01 | 4 | Debugging issue #321 |
| 2025-04-02 | 1 | Updating documentation |
| 2025-04-03 | 2 | Design for feature #958 |
The Specialist then runs a command to extract the document’s content in Markdown format, preserving the table structure:
```sql
SELECT SNOWFLAKE.CORTEX.PARSE_DOCUMENT(
'@document_stage',
'Timesheet_report.pdf',
{'mode': 'LAYOUT'}
):"content";
```
What is the output of this command?
The following error is received while attempting to extract details from a document with Snowflake Document AI:
`Request failed for external function DOCUMENT_EXTRACT_FEATURES$V1 with remote service error: 422`
How should this error be resolved?
Which cost categories do Cortex Search Services incur that are tracked in the CORTEX_SEARCH_DAILY_USAGE_HISTORY view? (Choose two)
Which Snowflake feature supports Retrieval Augmented Generation (RAG) with unstructured data?
A Generative AI Specialist builds a model using Python libraries. After training the model, they log it into a Snowflake Model Registry.
Where is the Model Registry stored within Snowflake?
A Gen AI Specialist is using Snowflake Cortex Analyst to generate natural language responses from product sales data. Occasionally, the LLM makes up metrics that do not exist in the data set.
How should this be addressed?
Which Snowflake Gen AI feature or service provides connectivity through an exposed REST API?
Review the following query:
```sql
SELECT DEMO_DB.DEMO_SCHEMA.EXM_DOC_AI_BUILD!PREDICT(
GET_PRESIGNED_URL(@ < stage_name > , ' < relative_file_path > '),
9
);
```
What output will it produce?
Which governance principles does Snowflake guarantee when its Gen AI features and the underlying models are used? (Choose two)
Which of the Snowflake Cortex LLM functions are task-specific? (Choose two)