Activate Your Black Friday Offer: 75% Discount on Exam Bundles! Use coupon code below! - Ends in 0d 00h 00m 00s - Coupon code: 75onlydt

GES-C02 Questions and Answers

Question # 6

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;

Full Access
Question # 7

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;

```

Full Access
Question # 8

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

A.

Accuracy

B.

Coherence

C.

Correctness

D.

F1 Score

E.

Precision

Full Access
Question # 9

When working with a multimodal model, what may the SNOWFLAKE.CORTEX.COMPLETE function be used for? (Choose two)

A.

Adding audio to images

B.

Labeling image files

C.

Completing fragmentary images

D.

Classifying landmarks in images

E.

Replacing extracted objects from images

Full Access
Question # 10

Which workflow should be used to analyze data in unstructured documents with Snowflake Cortex AI features, including Retrieval-Augmented Generation (RAG)?

A.

1. Use EMBED_TEXT_768 to extract text from documents.

2. Apply SUMMARIZE directly to the PDF files.

3. Use TRANSLATE to retrieve the data.

B.

1. Use SENTIMENT on binary files.

2. Apply TRANSLATE to generate embedding vectors.

3. Use CLASSIFY_TEXT to extract layout information from the PDF files.

C.

1. Use COMPLETE to summarize documents directly from external URLs.

2. Use COUNT_TOKENS to validate the output size.

3. Store the output in a text file.

D.

1. Use PARSE_DOCUMENT to extract text from documents.

2. Store and vectorize the content using EMBED_TEXT_768.

3. Retrieve data using vector similarity, then use COMPLETE to analyze the data.

Full Access
Question # 11

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;

```

Full Access
Question # 12

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

A.

SAML 2.0

B.

OAuth 2.0

C.

Single Sign-On (SSO)

D.

Key-pair authentication

E.

Multi-Factor Authentication (MFA)

Full Access
Question # 13

To submit a request to the Snowflake Cortex Analyst REST API endpoint, which fields are required in the body of the API request? (Choose three)

A.

Stream

B.

Content

C.

Request ID

D.

Suggestions

E.

Role of the speaker

F.

Path to the semantic model YAML file

Full Access
Question # 14

A Snowflake ACCOUNTADMIN must restrict LLM usage by granting access only to individual roles. For this purpose, they disabled LLM usage for every model in the account.

Which commands enable the GENAI_DEVELOPER role to use the COMPLETE function with the llama3.1–70b model?

SQL

A.

grant execute on SNOWFLAKE.CORTEX.COMPLETE to role GENAI_DEVELOPER;

grant usage on model 'SNOWFLAKE.MODELS.LLAMA3.1-70B' to role GENAI_DEVELOPER;

B.

alter session set CORTEX_MODELS_ALLOWLIST = 'SNOWFLAKE.MODELS.LLAMA3.1-70B';

grant usage on SNOWFLAKE.CORTEX.COMPLETE to role GENAI_DEVELOPER;

C.

grant database role SNOWFLAKE.CORTEX.COMPLETE to role GENAI_DEVELOPER;

alter function SNOWFLAKE.CORTEX.COMPLETE enable model 'SNOWFLAKE.MODELS.LLAMA3.1-70B';

D.

grant database role SNOWFLAKE.CORTEX_USER to role GENAI_DEVELOPER;

grant application role "CORTEX-MODEL-ROLE-LLAMA3.1-70B" to role GENAI_DEVELOPER;

Full Access
Question # 15

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

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

Full Access
Question # 16

Which commands can be used to display the Snowflake Cortex LLM models that are available? (Choose two)

A.

SHOW MODELS;

B.

LS @SNOWFLAKE.CORTEX.LLM;

C.

SHOW MODELS IN SNOWFLAKE.MODELS;

D.

SHOW VERSIONS LIKE 'CORTEX' IN MODEL LLM;

E.

CALL SNOWFLAKE.MODELS.CORTEX_BASE_MODELS_REFRESH();

Full Access
Question # 17

Which of the Snowflake Cortex LLM functions are task-specific? (Choose two)

A.

COMPLETE

B.

COUNT_TOKENS

C.

SUMMARIZE

D.

TRANSLATE

E.

TRY_COMPLETE

Full Access
Question # 18

Which proprietary LLM does Snowflake Document AI use?

A.

Arctic-TILT

B.

deepseek-rl

C.

jamba-instruct

D.

mistral-large2

Full Access
Question # 19

Which Snowflake feature enables application integration to answer questions using structured data in Snowflake?

A.

Document AI

B.

Copilot

C.

Cortex Search

D.

Cortex Analyst

Full Access
Question # 20

The following error is received while attempting to extract details from a document with Snowflake Document AI:

`Request failed for external function DOCUMENT_EXTRACT_FEATURES$V1 with remote service error: 422`

How should this error be resolved?

A.

Publish the model build.

B.

Reduce the number of documents in the query or extend the query expiration time.

C.

Recreate the internal stage specifying the SNOWFLAKE_SSE encryption type.

D.

Grant the CREATE SNOWFLAKE.ML.DOCUMENT_INTELLIGENCE privilege to the role running the extraction query.

Full Access
Question # 21

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)

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;

Full Access
Question # 22

A role lacks the OWNERSHIP privilege on an existing schema.

Which combination of GRANT statements is required to let users with that role create a Streamlit application in Snowflake? (Choose two)

A.

GRANT USAGE ON STAGE streamlit_db.streamlit_schema.my_stage TO ROLE streamlit_creator;

B.

GRANT CREATE STREAMLIT ON SCHEMA streamlit_db.streamlit_schema TO ROLE streamlit_creator;

C.

GRANT CREATE STAGE ON SCHEMA streamlit_db.streamlit_schema TO ROLE streamlit_creator;

D.

GRANT MONITOR ON WAREHOUSE streamlit_wh TO ROLE streamlit_creator;

E.

GRANT CREATE SCHEMA ON DATABASE streamlit_db TO ROLE streamlit_creator;

Full Access
Question # 23

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

]}

```

Full Access
Question # 24

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.

Full Access
Question # 25

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

A.

{

'max_tokens': 512,

'guardrails': true

}

B.

{

'max_tokens': 512,

'guardrails': false

}

C.

{

'max_tokens': 4096,

'guardrails': false

}

D.

{

'max_tokens': 4096,

'guardrails': true

}

```

Full Access