SnowPro Specialty: Gen AI (GES-C02) is Snowflake's AI-focused Specialty certification. It validates your ability to build generative AI on Snowflake using Cortex AI, LLM Functions, Vector Search, the RAG pattern, and document processing. This article breaks down each exam domain and the key points to study for every technology covered.
The Gen AI Specialty exam is a Specialty-level certification that validates your ability to apply generative AI and LLMs on the Snowflake platform. It tests your knowledge of Snowflake's rapidly expanding Cortex AI ecosystem.
| Item | Details |
|---|---|
| Exam Code | GES-C02 |
| Questions | 55 questions (may include unscored items) |
| Duration | 85 minutes |
| Passing Score | 750/1000 |
| Cost | $225 USD |
| Prerequisites | None (SnowPro Core certification is not required) |
| Question Format | Multiple choice (single and multiple response) |
| Language | English |
| Delivery | Pearson VUE (online proctored or test center) |
| Domain | Weight | Key Topics |
|---|---|---|
| 1.0 Snowflake for Gen AI Overview | 18% | The Cortex AI landscape (AI functions, Cortex Search, Cortex Analyst, Cortex Agents), Snowflake Intelligence, cross-region inference, bringing your own models with Model Registry and Snowpark Container Services |
| 2.0 Snowflake Gen AI Functions | 38% | AI functions (AI_COMPLETE, AI_CLASSIFY, AI_EXTRACT, and more) and vector functions, analysis with Cortex Search and Cortex Analyst, chat apps in Streamlit in Snowflake, use in data pipelines, running third-party models in Snowpark Container Services |
| 3.0 Snowflake Gen AI Governance | 29% | Model access controls, RBAC and roles such as CORTEX_USER, guardrails and sensitive data handling (AI_REDACT), monitoring and optimizing Cortex costs, AI Observability |
| 4.0 Snowflake Document Processing | 15% | AI_PARSE_DOCUMENT (OCR/LAYOUT mode), AI_EXTRACT, document processing pipelines with Streams and Tasks, troubleshooting |
About the NicheeLab question bank: In November 2026 we rebuilt NicheeLab's Gen AI question bank for the GES-C02 outline (4 domains, 15 objectives): 400 practice questions and 5 mock exams of 100 questions each. Domain 4.0 (Snowflake Document Processing) has 135 questions, and items added in GES-C02, such as Cortex Code, MCP, AI_TRANSCRIBE, AI_REDACT, and AI_FILTER, are covered too. Each answer was checked against the official Snowflake documentation.
Cortex AI Functions are a set of SQL functions for calling LLMs directly from inside Snowflake. Their biggest advantage is that no external API keys or extra infrastructure are needed - you can use LLMs entirely under Snowflake's governance. The AI_* functions such as AI_COMPLETE are now the main interface. The official reference pages say that the older SNOWFLAKE.CORTEX.COMPLETE and similar legacy functions will be deprecated by the end of 2026, and the GES-C02 Study Guide also lists most AI functions by their AI_* names.
The most basic LLM call function, used for most generative AI tasks. It takes a model name and a prompt as arguments and returns the generated text (it replaces the legacy SNOWFLAKE.CORTEX.COMPLETE).
-- Basic AI_COMPLETE call
SELECT AI_COMPLETE(
'llama3.3-70b',
'List three benefits of Snowflake's micro-partitions'
) AS llm_response;
-- Batch process table data
SELECT
product_name,
AI_COMPLETE(
'llama3.3-70b',
CONCAT('Summarize the following product review: ', review_text)
) AS review_summary
FROM product_reviews
LIMIT 100;Beyond AI_COMPLETE, there are functions built for specific tasks. The exam asks you to decide when to use them versus AI_COMPLETE (the official Study Guide's sample questions include this).
Cortex Search brings semantic search (meaning-based search) over text data to Snowflake. It surfaces semantic similarities that traditional keyword search (LIKE / CONTAINS) cannot capture.
Converts text (or images) into an embedding vector (it replaces the legacy EMBED_TEXT_768 and EMBED_TEXT_1024). The number of dimensions depends on the model; e5-base-v2 produces 768. You store these vectors in VECTOR-typed columns and search them via cosine similarity.
-- Embed text and store vectors
CREATE TABLE knowledge_base (
doc_id INT,
content VARCHAR,
content_vector VECTOR(FLOAT, 768)
);
INSERT INTO knowledge_base
SELECT
doc_id,
content,
AI_EMBED('e5-base-v2', content) AS content_vector
FROM raw_documents;-- Semantic search via cosine similarity
SELECT
doc_id,
content,
VECTOR_COSINE_SIMILARITY(
content_vector,
AI_EMBED('e5-base-v2', 'Snowflake pricing model')
) AS similarity_score
FROM knowledge_base
ORDER BY similarity_score DESC
LIMIT 5;RAG (Retrieval-Augmented Generation) is an architecture pattern that gives an LLM domain-specific knowledge. The Gen AI exam puts heavy emphasis on implementing RAG on Snowflake.
With Cortex Search Service, you get a managed semantic search endpoint instead of having to hand-build the embed → vector store → similarity search pipeline yourself. It also handles automatic index refreshes and hybrid search (keyword + semantic).
-- Create a Cortex Search Service
CREATE CORTEX SEARCH SERVICE product_search
ON content
WAREHOUSE = compute_wh
TARGET_LAG = '1 hour'
AS (
SELECT product_id, content, category
FROM product_docs
);Cortex Analyst converts natural-language questions into SQL and generates answers against Snowflake data. The official Study Guide lists semantic views and their YAML specification, verified queries, and custom instructions.
Streamlit in Snowflake (SiS) lets you run Python Streamlit apps inside Snowflake. The Gen AI exam covers patterns for building chatbots and RAG apps with SiS.
Governance is non-negotiable when generative AI moves into production use. Domain 3.0 (29%) of the official Study Guide lists items like these.
SnowPro Specialty: Gen AI
Question 1
When building a RAG (Retrieval-Augmented Generation) pipeline on Snowflake, which function is most appropriate for converting documents into vectors?
Correct answer: A
AI_EMBED converts text (or images) into an embedding vector and is required for the retrieval phase of a RAG pipeline (it replaces the legacy EMBED_TEXT_768). AI_COMPLETE is for text generation, AI_SUMMARIZE is for summarization, and AI_TRANSLATE is for translation - none of those are used for vectorization.
Are there Python coding questions on the SnowPro Specialty Gen AI exam?
There are no questions that make you write code (the question types are multiple choice and multiple select). However, the sample questions in the official Study Guide include SQL statements as answer options, and the objectives cover calling Cortex from application code in Streamlit in Snowflake and logging and calling models with Model Registry. Make sure you know the call syntax for Cortex AI Functions such as AI_COMPLETE.
Which Snowflake Edition is required to use Cortex AI features?
The official documentation pages for Cortex AI Functions, Cortex Search, and Cortex Analyst do not list an edition requirement such as Enterprise Edition or higher. The conditions they do list are regional availability (use cross-region inference if your region is not supported) and privileges (the USE AI FUNCTIONS privilege plus a database role such as CORTEX_USER). Note that AI features are disabled by default on free trial accounts; you need to add a credit card to turn them on.
How deeply does the exam cover the RAG pattern?
Beyond conceptual understanding of Retrieval-Augmented Generation (RAG), the exam tests Snowflake-specific implementation patterns. The typical flow is to retrieve relevant documents with Cortex Search and inject the retrieved context into an AI_COMPLETE prompt. Embedding model choice and chunk sizing are also objectives in the official Study Guide (2.2).
Practice with certification-focused question sets
Try free questionsNicheeLab Editorial Team
NicheeLab editorial team focused on data engineering and cloud certification learning. Content is structured around practical study needs and official exam domains.
Snowflake Certifications: All 11 Exams Explained (2026)
Every SnowPro certification on Snowflake's official list — C...
Snowflake Exam Difficulty Ranking: All 11 Certs Compared (2026)
All 11 SnowPro exams compared by difficulty in a ranking and...
Snowflake Study Guide: Fastest Pass Route by Exam (2026)
How to pass SnowPro certifications efficiently — official ma...
SnowPro Core (COF-C03): Complete Exam Guide (2026)
Pass the SnowPro Core exam — five domains, scope, sample que...
SnowPro Associate Platform (SOL-C01): Current Status & What to Take Next (2026)
As of October 2026, SnowPro Associate: Platform (SOL-C01) is...