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.
Which function calculates the Manhattan distance between two points in a vector space?
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
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?
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)
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?
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
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)
Which authentication methods are supported when accessing the Snowflake Cortex LLM REST API? (Choose two)
Which commands can be used to display the Snowflake Cortex LLM models that are available? (Choose two)
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
Which SQL functions are designed and optimized to carry out and automate specific routine tasks within Snowflake Cortex? (Choose two)
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?
Which strategy should be used to reduce latency when using the SNOWFLAKE.CORTEX.COMPLETE function?
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?

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?
Which view in the ACCOUNT_USAGE schema can query token costs for Snowflake Cortex LLMs aggregated in one-hour increments?
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)
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
Which components are necessary to deploy and run a container with Snowpark Container Services? (Choose two)
Which Snowflake feature simplifies generating vector embeddings and calculating vector similarities, reducing the number of retrieval steps needed in Retrieval Augmented Generation (RAG) pipelines?
Which governance principles does Snowflake guarantee when its Gen AI features and the underlying models are used? (Choose two)
