Snowflake GES-C02: SnowPro Specialty: Gen AI

Last checked October 22, 2026 against the official Snowflake exam page.

1. Question 1Cortex LLM functions

   A data engineer wants to generate a text summary of each customer review directly in a SQL query using a hosted model. Which Snowflake Cortex function is designed for this?

   1. AGET_DDL
   2. BSHOW TABLES
   3. CSNOWFLAKE.CORTEX.EMBED_TEXT only
   4. DSNOWFLAKE.CORTEX.COMPLETE
   Show answer and explanationHide answer

   Correct answer: D

   CORTEX.COMPLETE calls a hosted language model from SQL to generate text such as summaries. EMBED_TEXT creates embeddings, SHOW TABLES lists tables, and GET_DDL returns object definitions.

2. Question 2Cortex Search and retrieval

   A team wants to build a search service over support articles that returns results by meaning and keeps the index updated as articles change. Which Snowflake feature fits?

   1. AA materialized view of article titles only
   2. BAn external spreadsheet filter
   3. CCortex Search service on the source table
   4. DA manual full-text index rebuilt once a year
   Show answer and explanationHide answer

   Correct answer: C

   Cortex Search provides managed semantic and keyword retrieval over tables and keeps its index refreshed. Yearly rebuilds, title-only views, and spreadsheet filters do not provide meaning-based search with updates.

3. Question 3Generative AI governance and security

   A company must ensure that a Cortex AI function does not expose data outside the organization's region. Which consideration applies?

   1. AUse whichever region the developer prefers when setting up the Cortex function
   2. BChoose a model and deployment available in a compliant region and review data handling terms
   3. CIgnore regions because Cortex models are global and served from one shared endpoint in each account
   4. DCopy the data to a public region so that a cross-region replication job can serve analysts much faster
   Show answer and explanationHide answer

   Correct answer: B

   Choosing compliant regions and reviewing data handling terms addresses residency and privacy. Ignoring regions, copying data publicly, and personal choices violate that requirement.

4. Question 4Cortex Analyst and agents

   Business users want to ask natural-language questions of a governed semantic model and receive SQL-backed answers. Which Snowflake capability fits?

   1. AAsking an administrator to write each ad hoc SQL query
   2. BA printed data dictionary of table columns
   3. CExporting the tables to spreadsheets for offline review
   4. DCortex Analyst using a semantic model definition
   Show answer and explanationHide answer

   Correct answer: D

   Cortex Analyst translates natural language into SQL against a governed semantic model. Printed dictionaries, spreadsheet exports, and manual query requests do not provide governed self-service answers.

5. Question 5Generative AI fundamentals

   A team wants a language model to answer questions using its own sales documents stored in Snowflake. Which pattern is most appropriate?

   1. AAsking the model to recall the sales documents from its pretraining data at answer time
   2. BRetrieval-augmented generation that searches the documents and passes relevant passages to the model
   3. CCopying the text of every sales document into the model prompt on each request, regardless of relevance to the question
   4. DFine-tuning a model on the company documents before it answers each incoming user question
   Show answer and explanationHide answer

   Correct answer: B

   Retrieval-augmented generation finds relevant passages and includes them in the prompt, which keeps answers grounded and current. Fine-tuning per question, full-document prompts, and relying on training memory do not meet the need efficiently or reliably.