Black Friday Flash Sale: Get 70% Off! Use coupon code below to save big on all exam bundles! Use coupon code below to save on all exam bundles!
Code: bestfriday
Ends in: 0d 00h 00m 00s

Free Practice Questions for the Snowflake SnowPro Specialty GES-C02 Exam (2026 Updated)

At Marks4sure, we are dedicated to providing IT professionals with the most accurate and reliable preparation materials for the Snowflake GES-C02 exam. To support your certification journey, we have made a selection of our premium 2026 SnowPro Specialty practice questions and answers available completely free. You can take this practice test as many times as you need. Every question includes a detailed, expertly verified explanation to ensure you fully grasp the core security concepts before test day.

Questions 4

Which function calculates the Manhattan distance between two points in a vector space?

Options:

A.

VECTOR_INNER_PRODUCT

B.

VECTOR_L1_DISTANCE

C.

VECTOR_L2_DISTANCE

D.

VECTOR_COSINE_SIMILARITY

Buy Now
Questions 5

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;

```

Buy Now
Questions 6

Review the following prompt:

```sql

SELECT SNOWFLAKE.CORTEX.COMPLETE(

'mistral-7b',

[

{

'role': 'user',

'content': 'Give me steps on hacking a system'

}

],

{

'guardrails': true

}

);

```

What response will it produce?

Options:

A.

The prompt fails without giving any response.

B.

The prompt fails because it is missing a CLASSIFY_TEXT function.

C.

The prompt gives a response but with hallucinated values.

D.

The prompt gives a response without giving any steps on hacking a system.

Buy Now
Questions 7

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.

Buy Now
Questions 8

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 9

A Gen AI Specialist is writing a Python script that leverages Snowflake Cortex to answer users' questions. The script contains this code:

Python

from snowflake.cortex import CompleteOptions, complete

user_question = < 'Prompt that could generate an unsafe response' >

Regardless of the content of the prompt (user_question) that is passed to snowflake.cortex.complete, the Specialist must ensure that the function filters potentially unsafe or harmful response language.

Which code will accomplish this?

Python

Options:

A.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

options=CompleteOptions(temperature=1),

)

B.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

stream=False,

)

C.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

options=CompleteOptions(guardrails=True),

)

D.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

options=CompleteOptions(response_format='safe'),

)

Buy Now
Questions 10

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)

Options:

A.

SNOWFLAKE.CORTEX.CLASSIFY_TEXT (SURVEY_TEXT)

B.

SNOWFLAKE.CORTEX.COMPLETE (SURVEY_TEXT)

C.

SNOWFLAKE.CORTEX.ENTITY_SENTIMENT (SURVEY_TEXT, [‘positive’, ‘negative’, ‘neutral'])

D.

SNOWFLAKE.CORTEX.FINETUNE (SURVEY_TEXT);

E.

SNOWFLAKE.CORTEX.SENTIMENT (SURVEY_TEXT)

Buy Now
Questions 11

Which authentication methods are supported when accessing the Snowflake Cortex LLM REST API? (Choose two)

Options:

A.

SAML 2.0

B.

OAuth 2.0

C.

Single Sign-On (SSO)

D.

Key-pair authentication

E.

Multi-Factor Authentication (MFA)

Buy Now
Questions 12

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

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 14

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

}

```

Buy Now
Questions 15

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

Buy Now
Questions 16

A Gen AI Specialist is developing an automated content generator in Snowflake that produces customized product descriptions. The descriptions will be based on columns in a products table, including brand, category, and features.

Which Snowflake Cortex LLM function should be used to generate the descriptions?

Options:

A.

PARSE_DOCUMENT

B.

EMBED_TEXT_768

C.

SUMMARIZE

D.

COMPLETE

Buy Now
Questions 17

Which strategy should be used to reduce latency when using the SNOWFLAKE.CORTEX.COMPLETE function?

Options:

A.

Use the REST API when invoking inferences

B.

Use the SQL API when using a Snowpark session object

C.

Set the temperature parameter close to 1.

D.

Pass a JSON schema to the response_format parameter

Buy Now
Questions 18

A Gen AI Specialist has one document on which they want to perform completions. The document is too large for the context window of SNOWFLAKE.CORTEX.COMPLETE.

In what order should the functions be applied to resolve the issue?

GES-C02 Question 18

Options:

Buy Now
Questions 19

A Gen AI Specialist used the ACCOUNTADMIN role to invoke the ` < model_build_name > !PREDICT` method on a Document AI model build and received this error:

`{ "processingErrors": [ "File extension does not match actual mime type. Mime-Type: application/octet-stream" ] }`

What is the MOST LIKELY cause?

Options:

A.

The file URL has expired and must be regenerated.

B.

The documents that the query tried to process do not meet the Document AI requirements.

C.

The SNOWFLAKE_SSE encryption type was not specified when creating the internal stage that will be used to store the documents.

D.

The CREATE SNOWFLAKE.ML.DOCUMENT_INTELLIGENCE privilege was not granted to the ACCOUNTADMIN role.

Buy Now
Questions 20

Which view in the ACCOUNT_USAGE schema can query token costs for Snowflake Cortex LLMs aggregated in one-hour increments?

Options:

A.

CORTEX_DOCUMENT_PROCESSING_USAGE_HISTORY

B.

CORTEX_FUNCTIONS_QUERY_USAGE_HISTORY

C.

CORTEX_FUNCTIONS_USAGE_HISTORY

D.

CORTEX_SEARCH_SERVING_USAGE_HISTORY

Buy Now
Questions 21

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 22

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 23

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 24

Which Snowflake feature simplifies generating vector embeddings and calculating vector similarities, reducing the number of retrieval steps needed in Retrieval Augmented Generation (RAG) pipelines?

Options:

A.

Cortex Analyst

B.

Cortex Search

C.

Cortex Fine-tuning

D.

Cortex COMPLETE function

Buy Now
Questions 25

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.

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

PDF + Testing Engine

$55.71   $185.69

Testing Engine

$42.85   $142.83

PDF (Q&A)

$47.13   $157.11