Snowflake SnowPro® Specialty: Gen AI Certification Sample Questions:

1. A Snowflake Gen AI Specialist is defining a semantic model for Cortex Analyst to improve text-to-SQL accuracy. They are adding entries to the verified _ queries section of their YAML file. Consider the following semantic model snippet and a proposed verified_query entry. Which of the following statements correctly identifies an issue or a best practice not followed in the sql field of the proposed verified_query entry, based on Cortex Analyst VQR guidelines? Semantic Model Snippet:

Proposed verified _ query entry:

A) Option E
B) Option B
C) Option D
D) Option A
E) Option C

2. A data scientist needs to fine-tune a 'mistral-7b' LLM using Snowflake Cortex for a specific text summarization task. They have prepared a training dataset in a Snowflake table, with text in a column named 'source_text' and the desired summaries in a column named 'expected_summary' . They also want to understand the cost implications. Which SQL statement will correctly initiate the fine-tuning job, and how will the cost be primarily calculated?

A) The fine-tuning job is initiated by providing the prompt and completion data directly as arrays within the 'FINETUNE' function call, avoiding the need for a separate training data table, and costs are only for the storage of the fine-tuned model.
B) The fine-tuning job is initiated by:

C) The fine-tuning job is initiated by:

D) The fine-tuning job is initiated by:

E) The fine-tuning job is initiated by:

3. A multi-national corporation uses Snowflake across several AWS regions. Their primary operational Snowflake account is in AWS US East (Ohio), but they need to leverage a specific AI_COMPLETE model, llama4-maverick, which is natively available in AWS US East 1 (N. Virginia) but not in US East (Ohio). To address this, the Snowflake administrator enables cross-region inference for their US East (Ohio) account.

A) The query latency for cross-region inference with AI_COMPLETE is consistently low and predictable, as Snowflake's architecture is designed to completely negate the impact of geographical distance and network variations.
B) The llama4-maverick model is listed as natively available in AWS US East 1 (N. Virginia) and is supported for cross-region inference (AWS US Cross-Region), validating it as a suitable target for inference from US East (Ohio).
C) To enable cross-region inference for the US East (Ohio) account, the administrator would execute the command: ALTER ACCOUNT SET AWS_US' ; to allow inference requests to be processed in any AWS US region where the model is available. CORTEX_ENABLED_CROSS REGION =AWS_US' ;
D) Cross-region inference is fully supported for AI_COMPLETE in U.S. SnowGov regions for both inbound and outbound inference requests, provided the target model is available in the respective SnowGov region.
E) User inputs, service-generated prompts, and the generated outputs from cross-region AI_COMPLETE calls are automatically stored or cached in the remote processing region to optimize performance for subsequent identical requests.

4. An ML engineer is designing a Cortex Agent to provide highly accurate and contextualized responses. They intend for the agent to use state-of-the-art LLMs for orchestration and to maintain a specific brand tone in its outputs. Considering the available models and configurations for Cortex Agents, which statement is true?

A) Cortex Agents are restricted to using only Snowflake Arctic models for orchestration, due to security and governance requirements, and must operate in the account's default region.
B) When an agent utilizes an LLM for orchestration, the system ensures that cross-region inference is automatically enabled without any latency implications, making region selection irrelevant.
C) Cortex Agents primarily interact with data through the Snowflake Model Registry API to retrieve and update fine-tuned model parameters during their iterative planning phase.
D) The agent's 'Planning' component is specifically responsible for evaluating results after each tool use and deciding the subsequent steps in the query resolution process, acting as a feedback loop.
E) To ensure the agent's responses adhere to a desired brand and tone, 'Response instructions' can be configured, which guide the agent's output style and persona.

5. A developer is building a real-time chat application and wants to integrate a Large Language Model (LLM) hosted in Snowflake Cortex using its REST API. They need to send user prompts and receive streaming responses, ensuring secure authentication. Which of the following statements about using the Cortex REST API for the COMPLETE function are correct?

A) Option E
B) Option B
C) Option D
D) Option A
E) Option C

Solutions: