Ticking Clock Black Friday Special: 75% Off! Apply coupon code below to save on all exam bundles! - Ends in 0d 00h 00m 00s - Coupon code: 75epass

Exact2Pass Menu

SnowPro Specialty: Gen AI Exam

Last Update 1 hour ago Total Questions : 85

The SnowPro Specialty: Gen AI Exam content is now fully updated, with all current exam questions added 1 hour ago. Deciding to include GES-C02 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our GES-C02 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these GES-C02 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any SnowPro Specialty: Gen AI Exam practice test comfortably within the allotted time.

Question # 11

Which commands restrict access to Snowflake Cortex functions so that access is provided only to roles with explicitly granted privileges? (Choose two)

A.

REVOKE ROLE SNOWFLAKE.CORTEX_FUNCTIONS FROM ROLE PUBLIC;

B.

REVOKE ROLE SNOWFLAKE.CORTEX_USER FROM ROLE PUBLIC;

C.

REVOKE DATABASE ROLE SNOWFLAKE.CORTEX_USER FROM ROLE PUBLIC;

D.

REVOKE USAGE ON SCHEMA SNOWFLAKE.CORTEX FROM ROLE PUBLIC;

E.

REVOKE IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE FROM ROLE PUBLIC;

Question # 12

A Gen AI Specialist registered a new model in the Snowflake Model Registry and granted the USAGE privilege to a custom role, TRAINEE_ROLE.

When a new user with TRAINEE_ROLE tried to download the model artifacts with the GET command, an error occurred.

What would cause this error?

A.

The role has only USAGE and lacks READ or OWNERSHIP on the model.

B.

The user does not have the USAGE privilege on the schema.

C.

The user is not using the show_models() download method.

D.

The user is not using Snowpark Python FileOperation.get.

Question # 13

A Gen AI Specialist is building a pipeline in Snowflake to gather data that will be used to summarize customer chat messages.

The following table, CHAT_MESSAGES, was created:

| CONVERSATION_ID | MESSAGE_TEXT |

| :--- | :--- |

| 1 | Hi, I need help with my order. |

| 2 | It’s not been delivered yet. |

| 2 | How can I reset my password? |

| 3 | I received the wrong item. |

| 3 | Can I exchange it? |

The Specialist wants to use the Snowflake Cortex COMPLETE function with the llama3-8b model to generate a summary of each conversation. The prompt should begin with: "Summarize this chat:" followed by the full text of all messages in that chat conversation.

Which query will achieve this?

```sql

A.

SELECT

conversation_id,

SNOWFLAKE.CORTEX.COMPLETE('llama3-8b', 'Summarize this chat:' || message_text) AS summary_text

FROM CHAT_MESSAGES;

B.

SELECT

conversation_id,

SNOWFLAKE.CORTEX.COMPLETE('llama3-8b', 'Summarize this chat:' || ARRAY_AGG(message_text)) AS summary_text

FROM CHAT_MESSAGES;

C.

SELECT

conversation_id,

SNOWFLAKE.CORTEX.COMPLETE('llama3-8b', 'Summarize this chat:' || LISTAGG(message_text)) AS summary_text

FROM CHAT_MESSAGES

GROUP BY conversation_id;

D.

SELECT

conversation_id,

SNOWFLAKE.CORTEX.COMPLETE('llama3-8b', message_text) AS summary_text

FROM CHAT_MESSAGES

GROUP BY conversation_id;

```

Question # 14

Which key considerations apply when using the Snowflake Model Registry to manage models? (Choose two)

A.

Once a model is registered, it cannot be updated or deleted.

B.

Models need to be exported to external storage before they are registered.

C.

Models can be deployed and invoked directly using SQL commands in Snowflake.

D.

Models registered in the Model Registry can only be used with Snowpark for Python.

E.

The Model Registry supports versioning so that multiple versions of a model can be tracked.

Question # 15

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?

A.

PARSE_DOCUMENT

B.

EMBED_TEXT_768

C.

SUMMARIZE

D.

COMPLETE

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?

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"}

]}

```

Question # 17

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

A.

SELECT

review_date,

review,

SNOWFLAKE.CORTEX.ENTITY_SENTIMENT(review, ['professionalism', 'cleanliness', 'feel']) AS sentiment_analysis

FROM HOTEL_REVIEWS

WHERE NOT review IS NULL;

B.

SELECT

review_date,

review,

SNOWFLAKE.CORTEX.SENTIMENT(review) AS sentiment_analysis

FROM HOTEL_REVIEWS

WHERE NOT review IS NULL;

C.

SELECT

review_date,

review,

SNOWFLAKE.CORTEX.CLASSIFY_TEXT(review, ['SENTIMENT', 'FEEL']) AS sentiment_analysis

FROM HOTEL_REVIEWS;

D.

SELECT

review_date,

review,

SNOWFLAKE.CORTEX.SUMMARIZE(review) AS sentiment_analysis

FROM HOTEL_REVIEWS;

```

Question # 18

Which APIs or functions can be used to query the Snowflake Cortex Search Service? (Choose three)

A.

Snowflake Python APIs

B.

Snowflake REST APIs

C.

The CORTEX.COMPLETE function

D.

The EMBED_TEXT_768 function

E.

The SEARCH_PREVIEW function

F.

The CORTEX.SUMMARIZE function

Question # 19

A Gen AI Specialist wants to use a Snowflake Cortex LLM function to classify customer questions into two categories: support and food.

The Specialist created a table named QUERIES containing the following values:

| ID | QUERY_TEXT |

| :--- | :--- |

| 1 | How do I reset my account password? |

| 2 | Where’s the best sushi place in town? |

| 3 | I need help with a billing issue. |

Which command should be used?

```sql

A.

SELECT id, SNOWFLAKE.CORTEX.CLASSIFY_TEXT(query_text) AS category

FROM QUERIES;

B.

SELECT id, SNOWFLAKE.CORTEX.CLASSIFY_TEXT(query_text, ['support', 'food']) AS category

FROM QUERIES;

C.

SELECT id, SNOWFLAKE.CORTEX.CLASSIFY_TEXT(['support', 'food'], query_text) AS category

FROM QUERIES;

D.

SELECT id, SNOWFLAKE.CORTEX.CLASSIFY_TEXT(

model = > 'mistral-large',

INPUT = > query_text,

LABELS = > ['support', 'food']

) AS category

FROM QUERIES;

```

Question # 20

What role do event tables serve in the Snowflake Cortex Analyst observability features?

A.

To archive historical versions of semantic models

B.

To generate and store user authentication logs

C.

To maintain a history of virtual warehouse performance metrics

D.

To log data about requests including questions asked and generated SQL

Go to page: