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 # 14

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?

Options:

A.

Use a WHERE clause in the SQL prompt

B.

Ensure the model has been verified_at within the last 30 days.

C.

Add a VERIFIED_QUERIES section to the semantic model.

D.

Train the Cortex LLM model with additional sample outputs using fine-tuning commands.

Buy Now
Question # 15

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?

Options:

A.

Use Snowflake Cortex Search to limit the number of context documents.

B.

Use Snowflake Cortex Agents to ensure the base model is concise

C.

Use Snowflake Cortex Fine-tuning on a different base model

D.

Provide a semantic model to ensure the LLM is able to interpret the prompts

Buy Now
Question # 16

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?

Options:

A.

Timesheet report

Date Hours Activity

2025-04-01 4 Debugging issue #321

2025-04-02 1 Updating documentation

2025-04-03 2 Design for feature #958

Code snippet

B.

```markdown

Timesheet report

|Date|Hours|Activity|

| :---: | :---: | :---: |

|2025-04-01|4|Debugging issue #321|

|2025-04-02|1|Updating documentation|

|2025-04-03|2|Design for feature #958|

```

C.

"Timesheet report"

"Date", "Hours", "Activity"

"2025-04-01", 4, "Debugging issue #321"

"2025-04-02", 1, "Updating documentation"

"2025-04-03", 2, "Design for feature #958"

Code snippet

D.

```json

{"Timesheet_report": [

{"Date": "2025-04-01", "Hours": 4, "Activity": "Debugging issue #321"},

{"Date": "2025-04-02", "Hours": 1, "Activity": "Updating documentation"},

{"Date": "2025-04-03", "Hours": 2, "Activity": "Design for feature #958"}

]}

```

Buy Now
Question # 17

Which Snowflake Cortex AI observability metrics are used to evaluate LLM-generated responses? (Choose two)

Options:

A.

Accuracy

B.

Coherence

C.

Correctness

D.

F1 Score

E.

Precision

Buy Now
Question # 18

Which action can minimize costs for Snowflake Cortex Search Services?

Options:

A.

Make frequent but small updates to the source data.

B.

Split the text search columns into chunks of no more than 612 tokens.

C.

Reduce the target lag from 5 minutes to 1 minute for real-time indexing.

D.

Suspend serving when it is not necessary to run the service.

Buy Now
Question # 19

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)

Buy Now
Question # 20

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)

Options:

A.

Snowpipe

B.

Streams and tasks

C.

External access integration

D.

Cortex SENTIMENT function

E.

Cortex TRY_COMPLETE function

F.

Dynamic tables using incremental refreshes

Buy Now
Question # 21

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.

Buy Now
Question # 22

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?

Options:

A.

SELECT SNOWFLAKE.CORTEX.CLASSIFY_TEXT('gemma-7b', 'What is Gen AI?');

B.

SELECT SNOWFLAKE.CORTEX.COMPLETE('gemma-7b', 'What is Gen AI?');

C.

SELECT SNOWFLAKE.CORTEX.EXTRACT_ANSWER('gemma-7b', 'What is Gen AI?');

D.

SELECT SNOWFLAKE.CORTEX.SUMMARIZE('gemma-7b', 'What is Gen AI?');

Buy Now
Question # 23

Which Snowflake feature supports Retrieval Augmented Generation (RAG) with unstructured data?

Options:

A.

Cortex Analyst

B.

Cortex Search

C.

Cortex LLM Playground

D.

Semantic views

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