SnowPro Specialty: Gen AI Exam Questions and Answers
Which APIs or functions can be used to query the Snowflake Cortex Search Service? (Choose three)
A Gen AI Specialist uploaded a PDF named Timesheet_report.pdf to a Snowflake stage. The PDF includes a table with the following structure:
| Date | Hours | Activity |
| :--- | :--- | :--- |
| 2025-04-01 | 4 | Debugging issue #321 |
| 2025-04-02 | 1 | Updating documentation |
| 2025-04-03 | 2 | Design for feature #958 |
The Specialist then runs a command to extract the document’s content in Markdown format, preserving the table structure:
```sql
SELECT SNOWFLAKE.CORTEX.PARSE_DOCUMENT(
'@document_stage',
'Timesheet_report.pdf',
{'mode': 'LAYOUT'}
):"content";
```
What is the output of this command?
A Gen AI Specialist needs to determine whether feedback from a recent survey was generally positive, negative, or neutral. The Specialist wants the assessment reported as either a floating-point number from –1 to +1 (inclusive) or an object with a categories field.
Which statements will produce the desired results? (Choose two)
Which action can minimize costs for Snowflake Cortex Search Services?
Which Snowflake Cortex feature or function lets users ask questions in natural language and get direct responses without having to write SQL code?
A Gen AI Specialist is designing a Gen AI-powered data pipeline in Snowflake that must meet these requirements:* Download PDFs from a website every hour.* Load the PDFs into an internal stage.* Extract text from the PDFs and load that text into a Snowflake table.* Use prompt engineering to generate an opinion on the text based on a given persona.* Automate the pipeline for maximum efficiency.
Which Snowflake features are required to create this data pipeline with stored procedures? (Choose three)
A Gen AI Specialist has deployed a base model as an LLM in a production environment for a proof of concept. The model is larger and more expensive than other base models.
How can the Specialist lower production costs without affecting performance for the limited tasks needed to support the proof of concept?
Review this query:
```sql
SELECT SNOWFLAKE.CORTEX.CLASSIFY_TEXT(
'I love morning walks',
[
{
'label': 'travel',
'description': 'Hobbies related to going from one place to another',
'examples': ['I like flying to Europe', 'I love beaches']
},
{
'label': 'cooking',
'examples': ['I like learning about new ingredients', 'You must bring your soul to the recipe', 'Baking is my therapy']
},
{
'label': 'fitness',
'description': 'Hobbies related to being active and healthy'
}
],
{ 'task_description': 'Return a classification of the Hobby identified in the text' }
);
```
What will be the result of this query?
Which components are necessary to deploy and run a container with Snowpark Container Services? (Choose two)
A table in a pipeline has a VARCHAR column that contains free-form text responses. A Gen AI Specialist must generate three new columns from those text responses.
How should this requirement be fulfilled? (Choose two)
Review the following prompt:
```sql
SELECT SNOWFLAKE.CORTEX.COMPLETE(
'mistral-7b',
[
{
'role': 'user',
'content': 'Give me steps on hacking a system'
}
],
{
'guardrails': true
}
);
```
What response will it produce?
A Gen AI Specialist is developing an internal company chatbot that uses Streamlit and Snowflake Cortex Analyst to interpret and answer user queries against Snowflake data.
Team members need to be able to ask a question such as:
*Can you provide the sales trend for the last 6 months?*
The tool must also be able to answer follow-up questions such as:
*Can you break that down by region?*
*What factors contributed to the dip in February?*
To ensure the tool correctly interprets follow-up questions, what must be included in the API request to Cortex Analyst?
Which of the Snowflake Cortex LLM functions are task-specific? (Choose two)
Which privileges must be granted to a user with the FNR_DEVELOP role so that the user can use Document AI on an existing pipeline? (Choose three)
A team has developed a machine learning model outside of Snowflake using a third-party framework. The model needs to be deployed within Snowflake to support:
* Centralized version control
* Metadata tracking
Which Snowflake feature should be used to meet these requirements?
Which Snowflake Cortex AI observability metrics are used to evaluate LLM-generated responses? (Choose two)
A Gen AI Specialist has one document on which they want to perform completions. The document is too large for the context window of SNOWFLAKE.CORTEX.COMPLETE.
In what order should the functions be applied to resolve the issue?

A Gen AI Specialist has configured a pipeline to process hotel guest reviews. The reviews must be classified according to customer sentiment:
| REVIEW_DATE | REVIEW |
| :--- | :--- |
| 2024-04-12 | THE CUSTOMER SERVICE WAS VERY WELCOMING AND THE ROOMS ARE PRETTY CLEAN |
| 2024-06-01 | OUR ROOM WASN'T CLEANED AND TOWELS WERE MISSING. HOWEVER THE STAFF WERE HELPFUL |
Which statement satisfies this requirement?
```sql
How does Snowflake Cortex Analyst enable multi-turn conversations while preserving context across user interactions?
Which cost categories do Cortex Search Services incur that are tracked in the CORTEX_SEARCH_DAILY_USAGE_HISTORY view? (Choose two)
A role lacks the OWNERSHIP privilege on an existing schema.
Which combination of GRANT statements is required to let users with that role create a Streamlit application in Snowflake? (Choose two)
Which arguments are required when you use the log_model method to log a model in the Snowflake Model Registry? (Choose two)
Which commands restrict access to Snowflake Cortex functions so that access is provided only to roles with explicitly granted privileges? (Choose two)
How can costs that are directly associated with invoking the Snowflake Cortex COMPLETE function be minimized? (Choose two)
A Gen AI Specialist is creating metadata for Snowflake Cortex Analyst by creating a semantic model. The relationship between the PRODUCTS and PRODUCT_SALES tables is defined as:
```yaml
relationships:
- name: sales_to_products
join_type: left_outer
relationship_type: many_to_one
left_table: PRODUCT_SALES
relationship_columns:
- left_column: PRODUCT_ID
right_column: ID
right_table: PRODUCTS
```
Which join will Cortex Analyst generate in a query that uses this model?
```sql
