Weekend Special Sale 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale75best

Free Snowflake GES-C02 Practice Exam with Questions & Answers | Set: 2

Questions 11

A Gen AI Specialist is developing a Gen AI application in Snowflake and must debug a particular record that produced an inaccurate response. The Specialist needs to see, step by step, how the input prompt was processed, what context was retrieved, which tools were called, and how the LLM responded.

Which Snowflake AI observability feature should be used?

Options:
A.

Metrics

B.

Logging

C.

Tracing

D.

Monitoring

Snowflake GES-C02 Premium Access
Questions 12

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;

```

Questions 13

Which parameters in a SNOWFLAKE.CORTEX.COMPLETE function call can be adjusted to control the randomness and diversity of an LLM response? (Choose two)

Options:
A.

guardrails

B.

max_tokens

C.

response_format

D.

temperature

E.

top_p

Questions 14

Which cost categories do Cortex Search Services incur that are tracked in the CORTEX_SEARCH_DAILY_USAGE_HISTORY view? (Choose two)

Options:
A.

Serving compute

B.

Cloud services compute

C.

Virtual warehouse compute

D.

TOKEN_CREDITS

E.

EMBED_TEXT_TOKENS

Questions 15

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?

Options:
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.

Questions 16

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)

Options:
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;

Questions 17

A Gen AI Specialist is writing a Python script that leverages Snowflake Cortex to answer users' questions. The script contains this code:

Python

from snowflake.cortex import CompleteOptions, complete

user_question = < 'Prompt that could generate an unsafe response' >

Regardless of the content of the prompt (user_question) that is passed to snowflake.cortex.complete, the Specialist must ensure that the function filters potentially unsafe or harmful response language.

Which code will accomplish this?

Python

Options:
A.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

options=CompleteOptions(temperature=1),

)

B.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

stream=False,

)

C.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

options=CompleteOptions(guardrails=True),

)

D.

response = complete(

'llama3.1-70b',

[dict(role='user', content=user_question)],

options=CompleteOptions(response_format='safe'),

)

Questions 18

Which view in the ACCOUNT_USAGE schema can query token costs for Snowflake Cortex LLMs aggregated in one-hour increments?

Options:
A.

CORTEX_DOCUMENT_PROCESSING_USAGE_HISTORY

B.

CORTEX_FUNCTIONS_QUERY_USAGE_HISTORY

C.

CORTEX_FUNCTIONS_USAGE_HISTORY

D.

CORTEX_SEARCH_SERVING_USAGE_HISTORY

Questions 19

Which Snowflake data type is returned by the SNOWFLAKE.CORTEX.EMBED_TEXT_768 function?

Options:
A.

VECTOR

B.

VARCHAR

C.

VARIANT

D.

OBJECT

Questions 20

This command is run:

```sqlSELECT SNOWFLAKE.CORTEX.COMPLETE

(

'llama2-70b-chat',

{

'role': 'user',

'content': 'what are the colors of an apple?'

},

{

'temperature': 0.7,

'guardrails': TRUE

}

);

```

This error is returned:

`Invalid argument types for function 'COMPLETES$V6': (VARCHAR(15), OBJECT, OBJECT)`

What causes this error?

Options:
A.

The temperature option cannot be used with the guardrails option.

B.

The options argument must be the second parameter in the function call.

C.

The max_tokens option must be included when using the guardrails option.

D.

The prompt_or_history argument must be an array of objects when using the options argument.