Grab 75% Off This Black Friday: Use coupon code below to save on all exam bundles! - Ends in 0d 00h 00m 00s - Coupon code: 75only

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

Questions 4

A Gen AI Specialist creates the following table:

SQL

CREATE TABLE vectors (a VECTOR(FLOAT, 3), b VECTOR(FLOAT, 3));INSERT INTO vectors SELECT [1.1,2.2,3]::VECTOR (FLOAT, 3), [1,1,1] ::VECTOR (FLOAT, 3);INSERT INTO vectors SELECT [1,2.2,3]::VECTOR(FLOAT, 3), [4,6,8] ::VECTOR(FLOAT, 3);

```

Which function measures the relationship between vectors without considering their magnitudes?

Options:

A.

VECTOR_L1_DISTANCE

B.

VECTOR_L2_DISTANCE

C.

VECTOR_INNER_PRODUCT

D.

VECTOR_COSINE_SIMILARITY

Buy Now
Questions 5

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;

```

Buy Now
Questions 6

A Gen AI Specialist is creating a semantic model for Snowflake Cortex Analyst and must supply details for every field. One field holds complex, high-cardinality data.

Which technique keeps the semantic model concise?

Options:

A.

Include custom_instructions to truncate the field.

B.

Reference the search optimization service on this field.

C.

Reference a Snowflake Cortex Search Service on this field.

D.

Reference a Snowflake Cortex Analyst Verified Query Repository (VQR) on this field

Buy Now
Questions 7

Which workflow should be used to analyze data in unstructured documents with Snowflake Cortex AI features, including Retrieval-Augmented Generation (RAG)?

Options:

A.

1. Use EMBED_TEXT_768 to extract text from documents.

2. Apply SUMMARIZE directly to the PDF files.

3. Use TRANSLATE to retrieve the data.

B.

1. Use SENTIMENT on binary files.

2. Apply TRANSLATE to generate embedding vectors.

3. Use CLASSIFY_TEXT to extract layout information from the PDF files.

C.

1. Use COMPLETE to summarize documents directly from external URLs.

2. Use COUNT_TOKENS to validate the output size.

3. Store the output in a text file.

D.

1. Use PARSE_DOCUMENT to extract text from documents.

2. Store and vectorize the content using EMBED_TEXT_768.

3. Retrieve data using vector similarity, then use COMPLETE to analyze the data.

Buy Now
Questions 8

A Gen AI Specialist registered a new model in the Snowflake Model Registry and granted the USAGE privilege to a custom role, TRAINEE_ROLE.

When a new user with TRAINEE_ROLE tried to download the model artifacts with the GET command, an error occurred.

What would cause this error?

Options:

A.

The role has only USAGE and lacks READ or OWNERSHIP on the model.

B.

The user does not have the USAGE privilege on the schema.

C.

The user is not using the show_models() download method.

D.

The user is not using Snowpark Python FileOperation.get.

Buy Now
Questions 9

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 10

A Gen AI Specialist is developing a Gen AI application in Snowflake and must debug a particular record that produced an inaccurate response. The Specialist needs to see, step by step, how the input prompt was processed, what context was retrieved, which tools were called, and how the LLM responded.

Which Snowflake AI observability feature should be used?

Options:

A.

Metrics

B.

Logging

C.

Tracing

D.

Monitoring

Buy Now
Questions 11

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.

Buy Now
Questions 12

Which parameters in a SNOWFLAKE.CORTEX.COMPLETE function call can be adjusted to control the randomness and diversity of an LLM response? (Choose two)

Options:

A.

guardrails

B.

max_tokens

C.

response_format

D.

temperature

E.

top_p

Buy Now
Questions 13

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;

```

Buy Now
Questions 14

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

Buy Now
Questions 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();

Buy Now
Questions 16

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
Questions 17

Which privileges are needed to run a model fine-tuning job? (Choose two)

Options:

A.

READ or WRITE on the stage that contains the model

B.

USAGE on the database used to query the training and validation data

C.

OPERATE on the database used to query the training and validation data

D.

USAGE on the schema where the fine-tuned model will be saved

E.

CREATE MODEL or OWNERSHIP on the schema where the fine-tuned model will be saved

Buy Now
Questions 18

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

Buy Now
Questions 19

A Snowflake ACCOUNTADMIN must restrict LLM usage by granting access only to individual roles. For this purpose, they disabled LLM usage for every model in the account.

Which commands enable the GENAI_DEVELOPER role to use the COMPLETE function with the llama3.1–70b model?

SQL

Options:

A.

grant execute on SNOWFLAKE.CORTEX.COMPLETE to role GENAI_DEVELOPER;

grant usage on model 'SNOWFLAKE.MODELS.LLAMA3.1-70B' to role GENAI_DEVELOPER;

B.

alter session set CORTEX_MODELS_ALLOWLIST = 'SNOWFLAKE.MODELS.LLAMA3.1-70B';

grant usage on SNOWFLAKE.CORTEX.COMPLETE to role GENAI_DEVELOPER;

C.

grant database role SNOWFLAKE.CORTEX.COMPLETE to role GENAI_DEVELOPER;

alter function SNOWFLAKE.CORTEX.COMPLETE enable model 'SNOWFLAKE.MODELS.LLAMA3.1-70B';

D.

grant database role SNOWFLAKE.CORTEX_USER to role GENAI_DEVELOPER;

grant application role "CORTEX-MODEL-ROLE-LLAMA3.1-70B" to role GENAI_DEVELOPER;

Buy Now
Questions 20

A Gen AI Specialist needs to present end users with a complete set of predefined, answerable questions using Cortex Analyst.

How should the Verified Query Repository (VQR) be configured? (Choose two)

Options:

A.

Use the use_as_onboarding_question flag to true for each desired question.

B.

Add [Suggested Questions] in Markdown at the end of each desired question.

C.

Use questions that are complete sentences that end in question marks.

D.

Use the names of the physical tables and columns that are defined in the underlying data set in the SQL queries.

E.

Use the names of the logical tables and columns that are defined in the semantic model in the SQL queries.

Buy Now
Questions 21

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 22

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 23

For which Snowflake Cortex LLM functions is usage calculated from both input and output tokens? (Choose three)

Options:

A.

SUMMARIZE

B.

SENTIMENT

C.

TRANSLATE

D.

EMBED_TEXT_768

E.

EMBED_TEXT_1024

F.

CLASSIFY_TEXT

Buy Now
Questions 24

A Gen AI Specialist is designing a Gen AI-powered data pipeline in Snowflake that must meet these requirements:* Download PDFs from a website every hour.* Load the PDFs into an internal stage.* Extract text from the PDFs and load that text into a Snowflake table.* Use prompt engineering to generate an opinion on the text based on a given persona.* Automate the pipeline for maximum efficiency.

Which Snowflake features are required to create this data pipeline with stored procedures? (Choose three)

Options:

A.

Snowpipe

B.

Streams and tasks

C.

External access integration

D.

Cortex SENTIMENT function

E.

Cortex TRY_COMPLETE function

F.

Dynamic tables using incremental refreshes

Buy Now
Questions 25

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
Exam Code: GES-C02
Exam Name: SnowPro Specialty: Gen AI Exam
Last Update: Nov 21, 2026
Questions: 87

PDF + Testing Engine

$42.5  $169.99

Testing Engine

$32.5  $129.99
buy now GES-C02 testing engine

PDF (Q&A)

$27.5  $109.99
buy now GES-C02 pdf
dumpsmate guaranteed to pass

24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 22 Nov 2026