Power Up Your Study Prep: Black Friday 75% Discount! Use coupon code below to save! - Ends in 0d 00h 00m 00s - Coupon code: big75certs

Download Latest GES-C02 Questions

Page: 2 / 6
Total 85 questions

SnowPro Specialty: Gen AI Exam Questions and Answers

Question 5

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)

Options:

A.

Use the SNOWFLAKE.CORTEX.COMPLETE function specifying a RESPONSE_FORMAT in the options argument, and use dot notation to extract the data to put into the three new columns.

B.

Use the SNOWFLAKE.CORTEX.COMPLETE function specifying a TOP_P in the options argument, and parse the value of the CHOICES response key.

C.

Use the SNOWFLAKE.CORTEX.ENTITY_SENTIMENT function in a SELECT statement once for each of the three new columns.

D.

Call the SNOWFLAKE.CORTEX.EXTRACT_ANSWER function in a SELECT statement, and use dot notation to extract data to put into the three new columns.

E.

Call the SNOWFLAKE.CORTEX.EXTRACT_ANSWER function in a SELECT statement once for each of the three new columns.

Question 6

Which authentication methods are supported when accessing the Snowflake Cortex LLM REST API? (Choose two)

Options:

A.

SAML 2.0

B.

OAuth 2.0

C.

Single Sign-On (SSO)

D.

Key-pair authentication

E.

Multi-Factor Authentication (MFA)

Question 7

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

Options:

A.

SELECT...

FROM PRODUCT_SALES AS S

LEFT OUTER JOIN PRODUCTS AS P

ON S.PRODUCT_ID = P.ID;

B.

SELECT...

FROM PRODUCT AS P

LEFT OUTER JOIN PRODUCT_SALES AS PS

ON PS.PRODUCT_SALES = P.PRODUCTS;

C.

SELECT...

FROM PRODUCT_SALES AS S

FULL OUTER JOIN PRODUCT AS P

ON S.PRODUCT_ID = P.ID;

D.

SELECT...

FROM PRODUCT_SALES AS S

FULL OUTER JOIN PRODUCT AS P

WHERE P.ID = S.PRODUCT_ID;

```

Question 8

How can costs that are directly associated with invoking the Snowflake Cortex COMPLETE function be minimized? (Choose two)

Options:

A.

Set max_tokens to limit the number of input tokens.

B.

Set max_tokens to limit the number of output tokens in the response.

C.

Reduce the size of the virtual warehouse used to run the function.

D.

Use an LLM that has more parameters than the current LLM being used.

E.

Use an LLM that has fewer parameters than the current LLM being used.

Page: 2 / 6
Total 85 questions