Redeem Your Black Friday Code: 75% Off All Exam Bundles! Use coupon code below! - Ends in 0d 00h 00m 00s - Coupon code: discactive

Snowflake GES-C02 SnowPro Specialty: Gen AI Exam Exam Practice Test

Page: 1 / 9
Total 85 questions

SnowPro Specialty: Gen AI Exam Questions and Answers

Question 1

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

Options:

A.

{

'max_tokens': 512,

'guardrails': true

}

B.

{

'max_tokens': 512,

'guardrails': false

}

C.

{

'max_tokens': 4096,

'guardrails': false

}

D.

{

'max_tokens': 4096,

'guardrails': true

}

```

Question 2

How does Snowflake Cortex Analyst enable multi-turn conversations while preserving context across user interactions?

Options:

A.

By storing previous interactions in a separate database

B.

By using a session-based memory feature to track user queries

C.

By passing full conversation histories to each LLM agent in the workflow

D.

By using a summarization agent to rewrite questions based on conversation histories

Question 3

Which Snowflake Cortex feature or function lets users ask questions in natural language and get direct responses without having to write SQL code?

Options:

A.

Cortex Search

B.

Cortex Analyst

C.

The Cortex CLASSIFY_TEXT function

D.

The Cortex PARSE_DOCUMENT function

Question 4

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?

Options:

A.

deadline=5

B.

stream=True

C.

options=CompleteOptions(max_tokens=5)

D.

options=CompleteOptions(response_format="incremental")

Question 5

Which action is supported when using Snowflake Document AI?

Options:

A.

Extracting an entire table in a single query

B.

Processing up to 1000 documents in a single query

C.

Altering a database or a schema where the model build is located

D.

Supporting multiple users working on the same model build at the same time

Question 6

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?

Options:

A.

SELECT SNOWFLAKE.CORTEX.CLASSIFY_TEXT('gemma-7b', 'What is Gen AI?');

B.

SELECT SNOWFLAKE.CORTEX.COMPLETE('gemma-7b', 'What is Gen AI?');

C.

SELECT SNOWFLAKE.CORTEX.EXTRACT_ANSWER('gemma-7b', 'What is Gen AI?');

D.

SELECT SNOWFLAKE.CORTEX.SUMMARIZE('gemma-7b', 'What is Gen AI?');

Question 7

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;

```

Question 8

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

Options:

A.

SELECT SNOWFLAKE.CORTEX.COMPLETE(

'llama3.3-70b',

'Which foods must be avoided based on the customer provided food restrictions (respond with only a list of foods): '

|| food_restrictions

)

FROM EVENT_REGISTRATIONS;

B.

SELECT SNOWFLAKE.CORTEX.SENTIMENT(

'The customer provided these food restrictions:'

|| food_restrictions

|| '.Which foods must be avoided'

)

FROM EVENT_REGISTRATIONS;

C.

SELECT SNOWFLAKE.CORTEX.CLASSIFY_TEXT(

'The customer provided these food restrictions:'

|| food_restrictions

|| '.Which foods must be avoided',

['foods', 'diets']

)

FROM EVENT_REGISTRATIONS;

D.

SELECT SNOWFLAKE.CORTEX.SUMMARIZE(

'Which foods must be avoided based on the customer provided food restrictions:'

|| food_restrictions

)

FROM EVENT_REGISTRATIONS;

```

Question 9

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)

Options:

A.

BASE_MODEL

B.

COMPLETION

C.

INFERENCE

D.

PROMPT

E.

TRAINING

Question 10

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

Options:

A.

SELECT...

FROM PRODUCT_SALES AS S

LEFT OUTER JOIN PRODUCTS AS P

ON S.PRODUCT_ID = P.ID;

B.

SELECT...

FROM PRODUCT AS P

LEFT OUTER JOIN PRODUCT_SALES AS PS

ON PS.PRODUCT_SALES = P.PRODUCTS;

C.

SELECT...

FROM PRODUCT_SALES AS S

FULL OUTER JOIN PRODUCT AS P

ON S.PRODUCT_ID = P.ID;

D.

SELECT...

FROM PRODUCT_SALES AS S

FULL OUTER JOIN PRODUCT AS P

WHERE P.ID = S.PRODUCT_ID;

```

Question 11

Which SQL functions are designed and optimized to carry out and automate specific routine tasks within Snowflake Cortex? (Choose two)

Options:

A.

ANOMALY_DETECTION

B.

CLASSIFICATION

C.

FORECAST

D.

PARSE_DOCUMENT

E.

SENTIMENT

Question 12

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)

Options:

A.

Create a custom data model, apply the data model to a database, and ask questions from the Snowflake Document AI option in the AI & ML Studio in Snowsight.

B.

Create a custom data model, enhance the model with cross-region inference, and ask questions in a custom-built application that calls the Snowflake Cortex Agent API.

C.

Create a semantic model, upload the semantic model to a stage, and ask questions from the Snowflake Cortex Analyst option in the AI & ML Studio in Snowsight.

D.

Create a semantic model, upload the semantic model to a stage, and ask questions in a custom-built application that calls the Snowflake Cortex Analyst API.

E.

Create a Snowflake Cortex Agent in Snowsight, extract data from the database, and ask questions by fine-tuning an LLM with the extracted data.

Question 13

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)

Options:

A.

Use the SNOWFLAKE.CORTEX.COMPLETE function specifying a RESPONSE_FORMAT in the options argument, and use dot notation to extract the data to put into the three new columns.

B.

Use the SNOWFLAKE.CORTEX.COMPLETE function specifying a TOP_P in the options argument, and parse the value of the CHOICES response key.

C.

Use the SNOWFLAKE.CORTEX.ENTITY_SENTIMENT function in a SELECT statement once for each of the three new columns.

D.

Call the SNOWFLAKE.CORTEX.EXTRACT_ANSWER function in a SELECT statement, and use dot notation to extract data to put into the three new columns.

E.

Call the SNOWFLAKE.CORTEX.EXTRACT_ANSWER function in a SELECT statement once for each of the three new columns.

Question 14

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;

```

Question 15

Which commands can be used to display the available Snowflake Cortex LLM models? (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();

Question 16

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?

Options:

A.

Timesheet report

Date Hours Activity

2025-04-01 4 Debugging issue #321

2025-04-02 1 Updating documentation

2025-04-03 2 Design for feature #958

Code snippet

B.

```markdown

Timesheet report

|Date|Hours|Activity|

| :---: | :---: | :---: |

|2025-04-01|4|Debugging issue #321|

|2025-04-02|1|Updating documentation|

|2025-04-03|2|Design for feature #958|

```

C.

"Timesheet report"

"Date", "Hours", "Activity"

"2025-04-01", 4, "Debugging issue #321"

"2025-04-02", 1, "Updating documentation"

"2025-04-03", 2, "Design for feature #958"

Code snippet

D.

```json

{"Timesheet_report": [

{"Date": "2025-04-01", "Hours": 4, "Activity": "Debugging issue #321"},

{"Date": "2025-04-02", "Hours": 1, "Activity": "Updating documentation"},

{"Date": "2025-04-03", "Hours": 2, "Activity": "Design for feature #958"}

]}

```

Question 17

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?

Options:

A.

Publish the model build.

B.

Reduce the number of documents in the query or extend the query expiration time.

C.

Recreate the internal stage specifying the SNOWFLAKE_SSE encryption type.

D.

Grant the CREATE SNOWFLAKE.ML.DOCUMENT_INTELLIGENCE privilege to the role running the extraction query.

Question 18

Which cost categories do Cortex Search Services incur that are tracked in the CORTEX_SEARCH_DAILY_USAGE_HISTORY view? (Choose two)

Options:

A.

Serving compute

B.

Cloud services compute

C.

Virtual warehouse compute

D.

TOKEN_CREDITS

E.

EMBED_TEXT_TOKENS

Question 19

Which Snowflake feature supports Retrieval Augmented Generation (RAG) with unstructured data?

Options:

A.

Cortex Analyst

B.

Cortex Search

C.

Cortex LLM Playground

D.

Semantic views

Question 20

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?

Options:

A.

In a Snowflake stage as a scoped XML file

B.

In the image repository of a container compute pool

C.

In the model monitoring area of the model details page

D.

In a database and schema as a first-class Snowflake object

Question 21

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?

Options:

A.

Use a WHERE clause in the SQL prompt

B.

Ensure the model has been verified_at within the last 30 days.

C.

Add a VERIFIED_QUERIES section to the semantic model.

D.

Train the Cortex LLM model with additional sample outputs using fine-tuning commands.

Question 22

Which Snowflake Gen AI feature or service provides connectivity through an exposed REST API?

Options:

A.

Copilot

B.

Cortex LLM Playground

C.

A SNOWFLAKE.CORTEX.COMPLETE SQL function

D.

A snowflake.cortex.complete Python function

Question 23

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?

Options:

A.

The query will produce structured data from a document stored in a Snowflake internal stage using Document AI with a model-version identifier

B.

The query will produce structured data from a document stored in a Snowflake external stage using Document AI with a model-version identifier

C.

The query will produce semi-structured data from a document stored in a Snowflake internal stage using Document AI with a model-version identifier

D.

The query will produce semi-structured data from a document stored in a Snowflake external stage using Document AI with a model-version identifier

Question 24

Which governance principles does Snowflake guarantee when its Gen AI features and the underlying models are used? (Choose two)

Options:

A.

Snowflake customer data is never made available to other customers or model developers.

B.

Snowflake enforces Role-Based Access Control (RBAC) to ensure appropriate model access.

C.

Snowflake allows customers to create fine-tuned models that can be shared with other customers.

D.

Snowflake only allows third-party models to access Snowflake accounts using the Snowflake Model Registry.

E.

Snowflake mandates the use of Cortex Guard in the Cortex COMPLETE function to filter unsafe responses from a model.

Question 25

Which of the Snowflake Cortex LLM functions are task-specific? (Choose two)

Options:

A.

COMPLETE

B.

COUNT_TOKENS

C.

SUMMARIZE

D.

TRANSLATE

E.

TRY_COMPLETE

Page: 1 / 9
Total 85 questions