Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Pass the Snowflake SnowPro Specialty GES-C02 Questions and answers with CertsForce

Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

Which Snowflake Gen AI feature or service provides connectivity through an exposed REST API?

Options:

A.

Copilot


B.

Cortex LLM Playground


C.

A SNOWFLAKE.CORTEX.COMPLETE SQL function


D.

A snowflake.cortex.complete Python function


Expert Solution
Questions # 2:

A Gen AI Specialist requires a solution that supports asking questions in natural language and receiving answers based on structured data in Snowflake without using SQL.

How can this be achieved? (Choose two)

Options:

A.

Create a custom data model, apply the data model to a database, and ask questions from the Snowflake Document AI option in the AI & ML Studio in Snowsight.


B.

Create a custom data model, enhance the model with cross-region inference, and ask questions in a custom-built application that calls the Snowflake Cortex Agent API.


C.

Create a semantic model, upload the semantic model to a stage, and ask questions from the Snowflake Cortex Analyst option in the AI & ML Studio in Snowsight.


D.

Create a semantic model, upload the semantic model to a stage, and ask questions in a custom-built application that calls the Snowflake Cortex Analyst API.


E.

Create a Snowflake Cortex Agent in Snowsight, extract data from the database, and ask questions by fine-tuning an LLM with the extracted data.


Expert Solution
Questions # 3:

Which proprietary LLM does Snowflake Document AI use?

Options:

A.

Arctic-TILT


B.

deepseek-rl


C.

jamba-instruct


D.

mistral-large2


Expert Solution
Questions # 4:

When using the SNOWFLAKE.CORTEX.FINETUNE function, which column names must be included in the SQL statement supplied in the training_data_query parameter? (Choose two)

Options:

A.

BASE_MODEL


B.

COMPLETION


C.

INFERENCE


D.

PROMPT


E.

TRAINING


Expert Solution
Questions # 5:

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

Options:

A.

SELECT


B.

*,

VECTOR_INNER_PRODUCT(a.parts_description, b.parts_description) AS score

FROM Parts_A a, Parts_B b

WHERE a.part_id = b.part_id;


C.

SELECT


D.

*,

VECTOR_L1_DISTANCE(a.parts_description, b.parts_description) AS score

FROM Parts_A a, Parts_B b

WHERE a.part_id = b.part_id;


E.

SELECT


F.

*,

VECTOR_COSINE_SIMILARITY(a.parts_description, b.parts_description) AS score

FROM Parts_A a, Parts_B b

WHERE a.part_id = b.part_id;


G.

SELECT


Expert Solution
Questions # 6:

A Gen AI Specialist is developing an automated content generator in Snowflake that produces customized product descriptions. The descriptions will be based on columns in a products table, including brand, category, and features.

Which Snowflake Cortex LLM function should be used to generate the descriptions?

Options:

A.

PARSE_DOCUMENT


B.

EMBED_TEXT_768


C.

SUMMARIZE


D.

COMPLETE


Expert Solution
Questions # 7:

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?

Options:

A.

The query will produce structured data from a document stored in a Snowflake internal stage using Document AI with a model-version identifier


B.

The query will produce structured data from a document stored in a Snowflake external stage using Document AI with a model-version identifier


C.

The query will produce semi-structured data from a document stored in a Snowflake internal stage using Document AI with a model-version identifier


D.

The query will produce semi-structured data from a document stored in a Snowflake external stage using Document AI with a model-version identifier


Expert Solution
Questions # 8:

Review this metadata from a SNOWFLAKE.CORTEX.COMPLETE function response:

```json

"usage": {

"completion_tokens": 580,

"guardrails_tokens": 565,

"prompt_tokens": 61,

"total_tokens": 1206

}

```

Which model parameters were used in the function?

```json

Options:

A.

{

'max_tokens': 512,

'guardrails': true

}


B.

{

'max_tokens': 512,

'guardrails': false

}


C.

{

'max_tokens': 4096,

'guardrails': false

}


D.

{

'max_tokens': 4096,

'guardrails': true

}

```


Expert Solution
Questions # 9:

A user needs to enable cross-region inference in a Snowflake account that is located in the AWS us-east-1 (N. Virginia) region, so that they can access LLM models available in other AWS regions.

What considerations should be made before enabling cross-region inference in the Snowflake account? (Choose three)

Options:

A.

The user needs to use the ORGADMIN role.


B.

The user needs to use the ACCOUNTADMIN role.


C.

Credits related to the inference requests will be consumed based on the price per service consumption rates in the AWS us-east-1 region.


D.

Credits related to the inference will be consumed based on the price per service consumption rates in the region where the LLM is located.


E.

The data required for the inference request will stay within the AWS global network.


F.

The data required for the inference request will stay within the requesting region.


Expert Solution
Questions # 10:

A Gen AI Specialist is writing a Python script that leverages Snowflake Cortex to answer users' questions. The script contains this code:

Python

from snowflake.cortex import CompleteOptions, complete

user_question = < 'Prompt that could generate an unsafe response' >

Regardless of the content of the prompt (user_question) that is passed to snowflake.cortex.complete, the Specialist must ensure that the function filters potentially unsafe or harmful response language.

Which code will accomplish this?

Python

Options:

A.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

options=CompleteOptions(temperature=1),

)


B.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

stream=False,

)


C.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

options=CompleteOptions(guardrails=True),

)


D.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

options=CompleteOptions(response_format='safe'),

)


Expert Solution
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions