Black Friday Early Access - 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save75geek

GES-C02 SnowPro Specialty: Gen AI Exam Questions and Answers

Questions 4

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?');

Buy Now
Questions 5

This use case retrieves auto-part details from two data systems:

Datasource A:

Table Name - Parts_A

Columns Name - Parts_description, part_id

Datasource B:

Table Name - Parts_B

Columns Name - Parts_description, part_id

Code snippet

Which query compares the part descriptions across the two data sources?

```sql

Options:

A.

SELECT

B.

*,

VECTOR_INNER_PRODUCT(a.parts_description, b.parts_description) AS score

FROM Parts_A a, Parts_B b

WHERE a.part_id = b.part_id;

C.

SELECT

D.

*,

VECTOR_L1_DISTANCE(a.parts_description, b.parts_description) AS score

FROM Parts_A a, Parts_B b

WHERE a.part_id = b.part_id;

E.

SELECT

F.

*,

VECTOR_COSINE_SIMILARITY(a.parts_description, b.parts_description) AS score

FROM Parts_A a, Parts_B b

WHERE a.part_id = b.part_id;

G.

SELECT

Buy Now
Questions 6

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

Buy Now
Questions 7

What consideration should be made when using the Snowflake Cortex COMPLETE function?

Options:

A.

The COMPLETE function can only be used with the Snowflake Arctic model

B.

The COMPLETE function can only process single string prompts

C.

The COMPLETE function will retain the state between one call and the next.

D.

The COMPLETE function will generate a response using a specified language model based on a given prompt.

Buy Now
Questions 8

Which key considerations apply when using the Snowflake Model Registry to manage models? (Choose two)

Options:

A.

Once a model is registered, it cannot be updated or deleted.

B.

Models need to be exported to external storage before they are registered.

C.

Models can be deployed and invoked directly using SQL commands in Snowflake.

D.

Models registered in the Model Registry can only be used with Snowpark for Python.

E.

The Model Registry supports versioning so that multiple versions of a model can be tracked.

Buy Now
Questions 9

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")

Buy Now
Questions 10

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

Buy Now
Questions 11

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

Buy Now
Questions 12

A role lacks the OWNERSHIP privilege on an existing schema.

Which combination of GRANT statements is required to let users with that role create a Streamlit application in Snowflake? (Choose two)

Options:

A.

GRANT USAGE ON STAGE streamlit_db.streamlit_schema.my_stage TO ROLE streamlit_creator;

B.

GRANT CREATE STREAMLIT ON SCHEMA streamlit_db.streamlit_schema TO ROLE streamlit_creator;

C.

GRANT CREATE STAGE ON SCHEMA streamlit_db.streamlit_schema TO ROLE streamlit_creator;

D.

GRANT MONITOR ON WAREHOUSE streamlit_wh TO ROLE streamlit_creator;

E.

GRANT CREATE SCHEMA ON DATABASE streamlit_db TO ROLE streamlit_creator;

Buy Now
Questions 13

To submit a request to the Snowflake Cortex Analyst REST API endpoint, which fields are required in the body of the API request? (Choose three)

Options:

A.

Stream

B.

Content

C.

Request ID

D.

Suggestions

E.

Role of the speaker

F.

Path to the semantic model YAML file

Buy Now
Questions 14

Which arguments are required for the SNOWFLAKE.CORTEX.COMPLETE function? (Choose two)

Options:

A.

model

B.

top_p

C.

response_format

D.

max_tokens

E.

prompt_or_history

Buy Now
Questions 15

What type of costs are incurred when you use the Snowflake Cortex Search Service?

Options:

A.

Compute pool

B.

Serving compute

C.

Serverless compute

D.

Data transfer

Buy Now
Questions 16

Review this query:

```sql

SELECT SNOWFLAKE.CORTEX.CLASSIFY_TEXT(

'I love morning walks',

[

{

'label': 'travel',

'description': 'Hobbies related to going from one place to another',

'examples': ['I like flying to Europe', 'I love beaches']

},

{

'label': 'cooking',

'examples': ['I like learning about new ingredients', 'You must bring your soul to the recipe', 'Baking is my therapy']

},

{

'label': 'fitness',

'description': 'Hobbies related to being active and healthy'

}

],

{ 'task_description': 'Return a classification of the Hobby identified in the text' }

);

```

What will be the result of this query?

Options:

A.

{"label": "travel"}

B.

{"label": "fitness"}

C.

"fitness"

D.

{'label': 'fitness', 'description': 'Hobbies related to being active and healthy'}

Buy Now
Questions 17

What role do event tables serve in the Snowflake Cortex Analyst observability features?

Options:

A.

To archive historical versions of semantic models

B.

To generate and store user authentication logs

C.

To maintain a history of virtual warehouse performance metrics

D.

To log data about requests including questions asked and generated SQL

Buy Now
Questions 18

Which action can minimize costs for Snowflake Cortex Search Services?

Options:

A.

Make frequent but small updates to the source data.

B.

Split the text search columns into chunks of no more than 612 tokens.

C.

Reduce the target lag from 5 minutes to 1 minute for real-time indexing.

D.

Suspend serving when it is not necessary to run the service.

Buy Now
Questions 19

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.

Buy Now
Questions 20

When working with Snowflake Cortex, which design factors have the MOST effect on model performance per credit? (Choose two)

Options:

A.

The size of the data set

B.

The complexity of the queries

C.

The number of concurrent users

D.

The availability of compute resources

E.

The availability region where the model resides

Buy Now
Questions 21

Which components are necessary to deploy and run a container with Snowpark Container Services? (Choose two)

Options:

A.

A compute pool to run the container

B.

An external stage linked to Amazon S3

C.

A schedule task assigned to a virtual warehouse

D.

A file format registered for JSON or CSV data ingestion

E.

A service specification that defines the container behavior

Buy Now
Questions 22

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

Buy Now
Questions 23

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

Buy Now
Questions 24

When creating a Snowflake Document AI model, which object must have the CREATE SNOWFLAKE.ML.DOCUMENT_INTELLIGENCE privilege?

Options:

A.

Virtual warehouse

B.

Database

C.

Schema

D.

Stage

Buy Now
Questions 25

A Gen AI Specialist has configured a pipeline to process hotel guest reviews. The reviews must be classified according to customer sentiment:

| REVIEW_DATE | REVIEW |

| :--- | :--- |

| 2024-04-12 | THE CUSTOMER SERVICE WAS VERY WELCOMING AND THE ROOMS ARE PRETTY CLEAN |

| 2024-06-01 | OUR ROOM WASN'T CLEANED AND TOWELS WERE MISSING. HOWEVER THE STAFF WERE HELPFUL |

Which statement satisfies this requirement?

```sql

Options:

A.

SELECT

review_date,

review,

SNOWFLAKE.CORTEX.ENTITY_SENTIMENT(review, ['professionalism', 'cleanliness', 'feel']) AS sentiment_analysis

FROM HOTEL_REVIEWS

WHERE NOT review IS NULL;

B.

SELECT

review_date,

review,

SNOWFLAKE.CORTEX.SENTIMENT(review) AS sentiment_analysis

FROM HOTEL_REVIEWS

WHERE NOT review IS NULL;

C.

SELECT

review_date,

review,

SNOWFLAKE.CORTEX.CLASSIFY_TEXT(review, ['SENTIMENT', 'FEEL']) AS sentiment_analysis

FROM HOTEL_REVIEWS;

D.

SELECT

review_date,

review,

SNOWFLAKE.CORTEX.SUMMARIZE(review) AS sentiment_analysis

FROM HOTEL_REVIEWS;

```

Buy Now
Exam Code: GES-C02
Exam Name: SnowPro Specialty: Gen AI Exam
Last Update: Nov 21, 2026
Questions: 85
GES-C02 pdf

GES-C02 PDF

$22.5  $89.99
GES-C02 Engine

GES-C02 Testing Engine

$28.75  $114.99
GES-C02 PDF + Engine

GES-C02 PDF + Testing Engine

$35  $139.99