Black Friday VIP Hour Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75

Pass the Snowflake SnowPro Specialty GES-C02 Questions and answers with Dumpstech

Exam GES-C02 Premium Access

View all detail and faqs for the GES-C02 exam

Practice at least 50% of the questions to maximize your chances of passing.
Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions
Questions # 11:

Which costs are associated with Snowflake Cortex Search Services? (Choose two)

Options:

A.

Data transfer

B.

Mounting volume

C.

Serving compute

D.

Cloud services compute

E.

Image repository storage cost

Questions # 12:

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?');

Questions # 13:

Which proprietary LLM does Snowflake Document AI use?

Options:

A.

Arctic-TILT

B.

deepseek-rl

C.

jamba-instruct

D.

mistral-large2

Questions # 14:

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

Questions # 15:

A Gen AI Specialist is creating metadata for Snowflake Cortex Analyst by creating a semantic model. The relationship between the PRODUCTS and PRODUCT_SALES tables is defined as:

```yaml

relationships:

- name: sales_to_products

join_type: left_outer

relationship_type: many_to_one

left_table: PRODUCT_SALES

relationship_columns:

- left_column: PRODUCT_ID

right_column: ID

right_table: PRODUCTS

```

Which join will Cortex Analyst generate in a query that uses this model?

```sql

Options:

A.

SELECT...

FROM PRODUCT_SALES AS S

LEFT OUTER JOIN PRODUCTS AS P

ON S.PRODUCT_ID = P.ID;

B.

SELECT...

FROM PRODUCT AS P

LEFT OUTER JOIN PRODUCT_SALES AS PS

ON PS.PRODUCT_SALES = P.PRODUCTS;

C.

SELECT...

FROM PRODUCT_SALES AS S

FULL OUTER JOIN PRODUCT AS P

ON S.PRODUCT_ID = P.ID;

D.

SELECT...

FROM PRODUCT_SALES AS S

FULL OUTER JOIN PRODUCT AS P

WHERE P.ID = S.PRODUCT_ID;

```

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:

Which action is supported when using Snowflake Document AI?

Options:

A.

Extracting an entire table in a single query

B.

Processing up to 1000 documents in a single query

C.

Altering a database or a schema where the model build is located

D.

Supporting multiple users working on the same model build at the same time

Questions # 18:

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

Questions # 19:

A team has developed a machine learning model outside of Snowflake using a third-party framework. The model needs to be deployed within Snowflake to support:

* Centralized version control

* Metadata tracking

Which Snowflake feature should be used to meet these requirements?

Options:

A.

ML Observability

B.

Container Runtime for ML

C.

Snowflake Feature Store

D.

Snowflake Model Registry

Questions # 20:

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.

Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions