Snowflake · SF-GAI · Intermediate

SnowPro Specialty: Gen AI (GES-C02) — Practice Questions and Mock Exam

Name: Pass-IT
Author: Pass-IT

The SnowPro Specialty: Gen AI Certification (GES-C02) validates specialized knowledge of generative AI on Snowflake: the Cortex suite of AI features and functions, including Cortex Analyst, Cortex Search and Cortex Code; Gen AI governance across infrastructure, data and cost; document processing; and building and fine-tuning open-source models with Snowpark Container Services and the Snowflake Model Registry.

Practice for free Try a practice question first

Try a practice question first Practice for free

Start practicing SF-GAI free Buy SF-GAI access for $29.99

55Questions per Pass-IT mock exam

85minPass-IT mock exam time limit

Official SF-GAI exam: 750 out of 1000 points to pass.

Checked against Snowflake · August 2026 · Current exam version

Try Pass-IT

See what learning with Pass-IT is like.

Answer a SF-GAI sample question and read the explanation with its source. Right here, with no sign-up.

Snowflake Gen AI Governance1 / 5

By default, the USE AI FUNCTIONS privilege is granted to which role?

AlexFull explanation from Alex

PUBLIC USE AI FUNCTIONS: account-level privilege. Revokable by ACCOUNTADMIN only. Users need BOTH this AND CORTEX_USER or AI_FUNCTIONS_USER database role. Does not apply inside Snowflake native applications. SNOWFLAKE.CORTEX_USER: database role in SNOWFLAKE database. Covers all Covered AI features (Analyst, Search, Fine-tuning, Agent). Cannot be granted directly to users — must be granted to roles.

Sourcedocs.snowflake.com

Snowflake for Gen AI Overview2 / 5

Where are all large language models used by Snowflake Cortex AI Functions hosted?

AlexFull explanation from Alex

Fully hosted within Snowflake's infrastructure, keeping data secure and in place Data never leaves Snowflake's governance boundary. No third-party endpoints or external API calls. Ensures data security, governance, and scalability while keeping data in place. Models from OpenAI, Anthropic, Meta, Mistral, DeepSeek all run within Snowflake. Snowpark Container Services (SPCS): OCI-compliant container runtime in Snowflake.

Sourcedocs.snowflake.com

Snowflake Gen AI Functions3 / 5

A company wants to use Cortex Analyst but needs to ensure that no data or metadata leaves Snowflake's governance boundary. Which statement is correct?

AlexFull explanation from Alex

By default, Cortex Analyst uses Snowflake-hosted LLMs, ensuring no data leaves Snowflake's govern... All Cortex AI models are fully hosted within Snowflake infrastructure. Data never leaves Snowflake's governance boundary. No third-party endpoints or external API calls. Ensures data security, governance, and scalability while keeping data in place. Models from OpenAI, Anthropic, Meta, Mistral, DeepSeek all run within Snowflake.

Sourcedocs.snowflake.com

Snowflake for Gen AI Overview5 / 5

A data engineer needs to build a RAG pipeline in Snowflake that processes PDF documents, indexes them for semantic search, and generates contextual responses. Which sequence of Cortex AI functions and services should they use?

AlexFull explanation from Alex

A Snowflake RAG pipeline generally converts source documents into searchable text, retrieves relevant chunks, and passes that context to an LLM. For PDFs in Snowflake, AI_PARSE_DOCUMENT handles extraction, Cortex Search Service indexes and retrieves relevant content, and AI_COMPLETE generates contextual answers. The other sequences use functions for classification, sentiment, extraction, summarization, filtering, or redaction rather than the core RAG flow.

Sourcedocs.snowflake.com

Create a free account

How to prepare for SF-GAI with Pass-IT.

Currently 437 practice questions for SF-GAI, with new ones added regularly. Focus on what you still need to learn.

Get past difficult questions.

Understand why an answer is correct. Alex explains the concepts and answers your follow-up questions so you can apply what you learn to the next task.

Meet Alex →

Conversation preview · SF-GAI

AI function access

You
Which role receives USE AI FUNCTIONS by default?
Alex · AI tutor
PUBLIC.
Read the Snowflake documentation ↗
You
Does that make reviewing the privilege unnecessary?
Alex · AI tutor
No. It means you should understand the default grant when deciding who may use AI functions.
Read the Snowflake documentation ↗

Make your study time count.

Practice at your level.
For new practice sessions, Pass-IT adjusts the difficulty based on your previous answers.

Learn from mistakes.
Incorrect answers automatically become flashcards. When you review them, you rate how confidently you remember; Pass-IT schedules the next review.

See how focused practice works →

Animated feature preview

Turn your mistakes into knowledge you can rely on.

How Pass-IT works

Your review

Answered a question incorrectly?

Pass-IT saves it for your review.

SF-GAI · Question excerpt

AI function access

View the full question

By default, the USE AI FUNCTIONS privilege is granted to which role?

Understand the correct answer.

PUBLIC

USE AI FUNCTIONS is granted to PUBLIC by default; review that grant as part of access governance.

Read the Snowflake documentation ↗

How confidently do you remember?

During review, you assess how well you still know the answer.

Correct after hesitating

Pass-IT schedules your next review.

The date depends on your self-assessment and previous reviews.

Simplified demonstration. No learning progress is saved.

Practice for the moment that counts.

Take a full mock exam with a time limit and find out whether you can finish in time.

Your SF-GAI mock exam

Questions: 55
Minutes: 85

Illustration of an exam session

Start
Answer questions
Finish

Length and time limit of the Pass-IT mock exam.

Go into your exam with more confidence.

Your Readiness Score helps you assess whether you are ready for the exam. Results by exam domain show you where you should keep practicing.

Your money back if you fail despite 80% Readiness.
If your Readiness Score is at least 80% when you take the exam and you still fail, we refund the Pass-IT purchase price for this certification.

For active, paid access. Submit proof of failing within 14 days.

Further guarantee conditions

You need at least 80% Readiness and active, paid access to the certification when you take the exam. Take the exam within your access period and submit official proof of failing within 14 days after the exam.

For purchases through Apple or Google, refunds are handled by the respective store. See the full terms for further details.

Read the guarantee terms →

The Readiness Score describes your practice progress, not a probability of passing.

Guarantee requirement

80%

At least 80% Readiness
when you take the exam

Money back if you fail

Question counts and mock exam settings from the current Pass-IT catalog.

Exam domains

What you practice for SF-GAI.

Exam topics, relevant practice and sources you can check.

Gen AI capabilities and interfacesSee the guide for weighting76 QuestionsPass-IT questions

Understand the roles of Snowflake’s AI services and how applications use them.

Explain the roles of Cortex AI functions, Cortex Search for retrieval-augmented generation, Cortex Analyst for text-to-SQL, Cortex Agents, Snowflake Intelligence and Cortex Code.
Describe prompting, embeddings, context windows and semantic views, including verified queries and custom instructions; explain cross-region inference, access requirements and integration through REST APIs or MCP.
Distinguish interfaces such as AI Studio, SQL, Snowsight and the Cortex Code CLI, and explain options for fine-tuning and bringing custom models into Snowflake with Model Registry and Snowpark Container Services.

Official Snowflake objectives

AI functions, analysis and applicationsSee the guide for weighting159 QuestionsPass-IT questions

Use Snowflake AI functions and models to analyze data and build applications.

Apply Cortex AI, vector and helper functions for tasks such as completion, classification, extraction and similarity; use them in SQL pipelines to extract, enrich, augment and transform data.
Analyze structured and unstructured data with LLMs, Cortex Search and Cortex Analyst; choose models and retrieval settings, and build or use chat interfaces with the required privileges and conversation history.
Run third-party models with Snowpark Container Services and Model Registry, including environment setup, container images, specifications, compute pools, image repositories, model registration and invocation.

Official Snowflake objectives

AI access, costs and observabilitySee the guide for weighting136 QuestionsPass-IT questions

Control access to AI services and understand their cost and behavior.

Configure model access controls, grant and revoke roles and privileges for Cortex services, and apply safeguards for sensitive data, cross-region inference, REST authentication, hallucinations and bias.
Monitor and optimize Cortex and container-service costs through usage histories, token limits, quotas and tags, accounting for compute, indexing and serving costs.
Use AI observability tools, including evaluation metrics, comparisons, traces, logs, event tables and the TruLens SDK, to examine application behavior.

Official Snowflake objectives

Document extraction and processingSee the guide for weighting66 QuestionsPass-IT questions

Prepare documents, extract their content and automate processing with Cortex AI.

Prepare and upload documents within format and size requirements; parse them with AI_PARSE_DOCUMENT using OCR or LAYOUT and page options, and extract requested fields with AI_EXTRACT using prompts and response formats.
Build automated document-processing pipelines by coordinating Cortex AI with Snowflake Streams and Tasks.
Troubleshoot extraction query errors and GET_PRESIGNED_URL requirements and privileges, and optimize document processing through cost-aware practices and fine-tuning of arctic-extract models.

Official Snowflake objectives

Question formats you can practice

Multiple Choice: Select one answer.
Multiple Response: Select multiple applicable answers.

These are Pass-IT practice formats. Check the Snowflake certification page for the official exam information.

How we review questions

Source check: The answer, answer options and explanation are checked against official documentation. We call this canonical validation.

Adversarial review: An additional AI reviewer specifically looks for factual errors, ambiguous answers and weaknesses in the explanation.

Learning objectives: We count specific exam topics with clearly linked exercises. Subheadings are not counted separately.

The figures refer to available questions in each SF-GAI exam domain. The additional review count includes matching review logs for the current question version, even if errors were found. It is not an error-free rate.

The date shows the latest matching evidence or log entry in each domain. An import or transfer of an existing review result can update this entry. This does not mean the entire question pool has been reviewed again.

Review methods and criteria in detail

Frequently asked questions

Your preparation

How much study time should I plan for SF-GAI?

For planning, Pass-IT estimates roughly 30–75 hours. Relevant experience may put you toward the lower end; starting from scratch may put you toward the higher end. Your needs may fall outside this range. This is not a time requirement from Snowflake or a promise that you will be exam-ready within that time.

What do you need before the SnowPro Specialty: Gen AI exam?

No certification is required first. Snowflake recommends a year or more of Gen AI work with Snowflake in an enterprise environment, and assumes you already bring data engineering and SQL knowledge. Python helps, because the blueprint covers building and fine-tuning open-source models with Snowpark Container Services and the Model Registry.

Using Pass-IT

What language are Pass-IT questions in?

Questions in the app are currently in English. Translations of the sample questions on this page apply only to this preview. Check with Snowflake for the languages available for the official exam.

How long does my SF-GAI access last?

Access covers this certification for 12 months. You pay once, with no automatic renewal.

When does the money-back guarantee apply?

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days. Guarantee terms

About the SF-GAI exam

Where can I take the SF-GAI exam?

Online proctored or onsite testing centers.

How long is the SnowPro Specialty: Gen AI (GES-C02) exam?

The SnowPro Specialty: Gen AI (GES-C02) exam has 55 questions and a 85-minute time limit.

How is the SnowPro Specialty: Gen AI exam structured?

55 questions in 85 minutes, multiple choice and multiple select, scored from 0 to 1000 with 750 to pass. That is roughly a minute and a half per question, which is tight for scenario items that describe a whole pipeline before they ask anything. Snowflake delivers it online with a proctor or at a testing centre, in English.

How long does SnowPro Specialty: Gen AI stay valid?

Two years from the issue date. You recertify through Snowflake's continuing education programme: an eligible instructor-led course, or an equivalent or higher-level SnowPro certification. That route is only open while your certification is still valid, so the two-year date is the one to diarise.

Your preparation for SF-GAI

$29.99one-time

12 months of access for SF-GAI · No automatic renewal

Buy SF-GAI access

Questions in the app are currently in English.

Try 20 questions for freeFree account required. No credit card.

Already have an account? Log in

Prefer a subscription? View subscriptions →

Money back if you fail with at least 80% Readiness, for eligible purchases under the guarantee terms.

Guarantee terms

Full guarantee terms →