Black Friday Mega Drop - Up to 75% Off Best Sellers - Ends in 0d 00h 00m 00s - Coupon code: certbig75

GES-C02 Exam Dumps - Snowflake SnowPro Specialty Questions and Answers

Question # 24

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)

Options:

A.

GRANT DATABASE ROLE SNOWFLAKE.ML_USER TO ROLE FNR_DEVELOP_ROLE;

B.

GRANT DATABASE ROLE SNOWFLAKE.DOCUMENT_INTELLIGENCE_CREATOR TO ROLE FNR_DEVELOP_ROLE;

C.

GRANT ROLE SNOWFLAKE.DOCUMENT_INTELLIGENCE_CREATOR TO ROLE FNR_DEVELOP_ROLE;

D.

GRANT CREATE SNOWFLAKE.ML.DOCUMENT_INTELLIGENCE ON SCHEMA . TO ROLE FNR_DEVELOP_ROLE;

E.

GRANT CREATE SNOWFLAKE.MODELS.DOCUMENT_INTELLIGENCE ON SCHEMA .;

F.

GRANT CREATE MODEL ON SCHEMA . TO ROLE FNR_DEVELOP_ROLE;

Buy Now
Question # 25

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.

Buy Now
Question # 26

Which components are necessary to deploy and run a container with Snowpark Container Services? (Choose two)

Options:

A.

A compute pool to run the container

B.

An external stage linked to Amazon S3

C.

A schedule task assigned to a virtual warehouse

D.

A file format registered for JSON or CSV data ingestion

E.

A service specification that defines the container behavior

Buy Now
Question # 27

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?

Options:

A.

The prompt fails without giving any response.

B.

The prompt fails because it is missing a CLASSIFY_TEXT function.

C.

The prompt gives a response but with hallucinated values.

D.

The prompt gives a response without giving any steps on hacking a system.

Buy Now
Question # 28

A company is organizing an event and asked participants about their food restrictions. The responses have been saved in a table named EVENT_REGISTRATIONS:

| ID | FOOD_RESTRICTIONS |

| :--- | :--- |

| 1 | allergic to nuts |

| 2 | no gluten |

| 3 | no milk or dairy products |

| 4 | no meat |

Which query will compile a list of foods that should not be served?

```sql

Options:

A.

SELECT SNOWFLAKE.CORTEX.COMPLETE(

'llama3.3-70b',

'Which foods must be avoided based on the customer provided food restrictions (respond with only a list of foods): '

|| food_restrictions

)

FROM EVENT_REGISTRATIONS;

B.

SELECT SNOWFLAKE.CORTEX.SENTIMENT(

'The customer provided these food restrictions:'

|| food_restrictions

|| '.Which foods must be avoided'

)

FROM EVENT_REGISTRATIONS;

C.

SELECT SNOWFLAKE.CORTEX.CLASSIFY_TEXT(

'The customer provided these food restrictions:'

|| food_restrictions

|| '.Which foods must be avoided',

['foods', 'diets']

)

FROM EVENT_REGISTRATIONS;

D.

SELECT SNOWFLAKE.CORTEX.SUMMARIZE(

'Which foods must be avoided based on the customer provided food restrictions:'

|| food_restrictions

)

FROM EVENT_REGISTRATIONS;

```

Buy Now
Exam Code: GES-C02
Exam Name: SnowPro Specialty: Gen AI Exam
Last Update: Nov 21, 2026
Questions: 85
GES-C02 pdf

GES-C02 PDF

$22.5  $89.99
GES-C02 Engine

GES-C02 Testing Engine

$25  $99.99
GES-C02 PDF + Engine

GES-C02 PDF + Testing Engine

$35  $139.99