A user opened the Snowflake Cortex LLM Playground in the AI & ML Studio within Snowsight, selected gemma-7b from the Standard models drop-down list, and typed "What is Gen AI?" into the dialog box.
Which SQL statement will achieve the same result?
This use case retrieves auto-part details from two data systems:
Datasource A:
Table Name - Parts_A
Columns Name - Parts_description, part_id
Datasource B:
Table Name - Parts_B
Columns Name - Parts_description, part_id
Code snippet
Which query compares the part descriptions across the two data sources?
```sql
Review the following query:
```sql
SELECT DEMO_DB.DEMO_SCHEMA.EXM_DOC_AI_BUILD!PREDICT(
GET_PRESIGNED_URL(@ < stage_name > , ' < relative_file_path > '),
9
);
```
What output will it produce?
What consideration should be made when using the Snowflake Cortex COMPLETE function?
Which key considerations apply when using the Snowflake Model Registry to manage models? (Choose two)
A Gen AI Specialist is developing a Streamlit chatbot that uses `snowflake.cortex.complete` to answer user questions with this script:
```python
import streamlit as st
import snowflake.cortex
from snowflake.cortex import CompleteOptions
if prompt := st.chat_input("How can I help you?"):
with st.chat_message(name="User"):
st.write(prompt)
with st.chat_message("assistant"):
response = snowflake.cortex.complete(
"claude-3-5-sonnet",
[dict(role="user", content=prompt)],
)
```
Which parameter should be added to the script so responses display incrementally in small chunks as they are generated?
Which Snowflake feature supports Retrieval Augmented Generation (RAG) with unstructured data?
Which Snowflake Cortex feature or function lets users ask questions in natural language and get direct responses without having to write SQL code?
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)
To submit a request to the Snowflake Cortex Analyst REST API endpoint, which fields are required in the body of the API request? (Choose three)
Which arguments are required for the SNOWFLAKE.CORTEX.COMPLETE function? (Choose two)
What type of costs are incurred when you use the Snowflake Cortex Search Service?
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?
What role do event tables serve in the Snowflake Cortex Analyst observability features?
A Gen AI Specialist is using Snowflake Cortex Analyst to generate natural language responses from product sales data. Occasionally, the LLM makes up metrics that do not exist in the data set.
How should this be addressed?
When working with Snowflake Cortex, which design factors have the MOST effect on model performance per credit? (Choose two)
Which components are necessary to deploy and run a container with Snowpark Container Services? (Choose two)
Which Snowflake Gen AI feature or service provides connectivity through an exposed REST API?
When creating a Snowflake Document AI model, which object must have the CREATE SNOWFLAKE.ML.DOCUMENT_INTELLIGENCE privilege?
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