Home / artificial-intelligence-machine-learning / SnowPro Specialty: Gen AI (GES-C02) / Cheat Sheet
SnowPro Specialty: Gen AI (GES-C02)

GES-C02 Cheat Sheet

GES-C02 Tests Which Cortex Feature Fits the Data — Not Generic LLM Theory

GES-C02 replaced GES-C01 in 2026 and swaps the old Document AI for AI_EXTRACT and AI_PARSE_DOCUMENT. Expect builder and admin scenarios where you pick the Cortex function, role or parameter that fits, inside Snowflake.

Check Your Readiness →
Among the harder certs
Avg: Not published by Snowflake
Pass: 750 / 1000
Most candidates understand SnowPro Specialty: Gen AI (GES-C02) concepts — and still fail. This exam tests how you apply knowledge under pressure.

GES-C02 Domain Map

Weights come from secondary reproductions of the official guide and still need checking against the PDF. Items are short scenarios: identify per-row versus aggregate work, structured versus unstructured data, and whether Cortex hosts the model, then choose the most specific function or the least-privilege control.

  1. 01
    Snowflake Gen AI Functions (38%) — AI_COMPLETE, AI_CLASSIFY, AI_FILTER, AI_AGG, AI_EMBED, pipelines and SPCS-hosted models
  2. 02
    Snowflake Gen AI Governance (29%) — Cortex database roles, model allowlist, Cortex Guard, AI_REDACT, cost views and AI Observability
  3. 03
    Snowflake for Gen AI Overview (18%) — choosing Cortex Search, Analyst, Agents, Snowflake Intelligence, MCP or bring-your-own model
  4. 04
    Snowflake Document Processing (15%) — AI_PARSE_DOCUMENT OCR vs LAYOUT, AI_EXTRACT, stages, directory tables, streams and tasks

Wrong instinct vs correct approach

A chatbot built on AI_COMPLETE forgets what the user said one turn earlier
✕ Wrong instinct

Switch to a larger model with a longer context window

✓ Correct approach

Cortex models are stateless between calls. The application must resend prior turns in the messages array, with roles and content, on every request; a bigger model changes nothing if the history is never passed.

Supplier invoices land in an internal stage all day and only new files should be processed
✕ Wrong instinct

Schedule a nightly task that parses every staged file

✓ Correct approach

Use a stage with server-side encryption and a directory table, put a stream on the directory table, and run a task that calls AI_EXTRACT only on the stream's new rows, writing fields plus file path to a table.

Users hit a model-unavailable error and the company has a strict data residency requirement
✕ Wrong instinct

Enable cross-region inference so requests route elsewhere

✓ Correct approach

Cross-region inference is disabled by default and exists for model availability, but it sends data to other regions. Under a residency rule, choose a model offered in the local region and leave the account setting off.

A team must summarise themes across five million product reviews in one answer
✕ Wrong instinct

Concatenate all rows into one string and call AI_COMPLETE

✓ Correct approach

A single prompt would overflow the context window. AI_AGG with an instruction, or AI_SUMMARIZE_AGG without one, is built to reduce many rows to one insight without being bound by a single context window.

Know these cold

  • ▸ AI_FILTER returns a boolean for WHERE or JOIN; AI_CLASSIFY returns labels per row
  • ▸ Cortex Search for documents, Cortex Analyst for tables, Cortex Agents when both are needed
  • ▸ Cortex Analyst needs a semantic view or YAML model; verified queries lift accuracy on common questions
  • ▸ Never compare embeddings from two different models; rebuild the index when the embedding model changes
  • ▸ TRY_COMPLETE returns NULL on failure instead of stopping a batch; it does not retry
  • ▸ Cortex Search bills refresh warehouse, embedding, indexing and serving; serving grows with indexed data
  • ▸ Model Registry stores versioned models; container images go to an image repository for SPCS
  • ▸ Use SPCS with GPU compute pools only when Cortex does not host the model
  • ▸ GET_PRESIGNED_URL links expire; generate them on demand and never store them as permanent links
  • ▸ Snowflake Intelligence is the business-user agent; developers integrate through SQL, REST APIs or MCP

Can you answer these without checking your notes?

In this scenario: "A chatbot built on AI_COMPLETE forgets what the user said one turn earlier" — what should you do first?
Cortex models are stateless between calls. The application must resend prior turns in the messages array, with roles and content, on every request; a bigger model changes nothing if the history is never passed.
In this scenario: "Supplier invoices land in an internal stage all day and only new files should be processed" — what should you do first?
Use a stage with server-side encryption and a directory table, put a stream on the directory table, and run a task that calls AI_EXTRACT only on the stream's new rows, writing fields plus file path to a table.
In this scenario: "Users hit a model-unavailable error and the company has a strict data residency requirement" — what should you do first?
Cross-region inference is disabled by default and exists for model availability, but it sends data to other regions. Under a residency rule, choose a model offered in the local region and leave the account setting off.

Common Exam Mistakes — What candidates get wrong

Using Cortex Search to answer questions that need exact table aggregates

Cortex Search retrieves text passages with hybrid vector and keyword ranking; it cannot total revenue or count tickets. Numeric questions over governed tables belong to Cortex Analyst, which generates SQL from a semantic view or YAML semantic model, and mixed needs go to a Cortex Agent.

Forgetting that SNOWFLAKE.CORTEX_USER is granted to PUBLIC by default

Granting the database role to one team changes nothing while PUBLIC still holds it. Revoke CORTEX_USER from PUBLIC, grant the narrowest role needed (CORTEX_EMBED_USER, CORTEX_ANALYST_USER or CORTEX_AGENT_USER), and restrict models with the CORTEX_MODELS_ALLOWLIST account parameter.

Writing free-form AI_COMPLETE prompts where a task function already exists

Sentiment, labels and yes/no conditions have dedicated functions: AI_SENTIMENT, AI_CLASSIFY and AI_FILTER return typed output at lower cost with nothing to parse. Fall back to AI_COMPLETE with a JSON-schema structured output only when no task-specific function produces the required result.

Picking OCR mode for documents whose tables and reading order matter

AI_PARSE_DOCUMENT in OCR mode returns plain text; LAYOUT mode preserves tables, headings and reading order, which also chunks better for RAG. When only a few named fields are needed, skip full parsing and call AI_EXTRACT with a response format.

Mixing up Cortex Guard, AI_REDACT and the Cortex cost views

Cortex Guard filters unsafe responses from AI_COMPLETE; AI_REDACT strips personal data from text you pass in. ACCOUNT_USAGE views report token and credit consumption, while answer quality such as groundedness comes from AI Observability evaluations and TruLens traces.

Resources to help you pass SnowPro Specialty: Gen AI on your first attempt

GES-C02 rewards picking the exact Cortex function, role or mode. Find your gaps before exam day.