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

Free Snowflake GES-C02 Practice Exam with Questions & Answers

Questions 1

A Gen AI Specialist creates the following table:

SQL

CREATE TABLE vectors (a VECTOR(FLOAT, 3), b VECTOR(FLOAT, 3));INSERT INTO vectors SELECT [1.1,2.2,3]::VECTOR (FLOAT, 3), [1,1,1] ::VECTOR (FLOAT, 3);INSERT INTO vectors SELECT [1,2.2,3]::VECTOR(FLOAT, 3), [4,6,8] ::VECTOR(FLOAT, 3);

```

Which function measures the relationship between vectors without considering their magnitudes?

Options:
A.

VECTOR_L1_DISTANCE

B.

VECTOR_L2_DISTANCE

C.

VECTOR_INNER_PRODUCT

D.

VECTOR_COSINE_SIMILARITY

Snowflake GES-C02 Premium Access
Questions 2

Which proprietary LLM does Snowflake Document AI use?

Options:
A.

Arctic-TILT

B.

deepseek-rl

C.

jamba-instruct

D.

mistral-large2

Questions 3

A table in a pipeline has a VARCHAR column that contains free-form text responses. A Gen AI Specialist must generate three new columns from those text responses.

How should this requirement be fulfilled? (Choose two)

Options:
A.

Use the SNOWFLAKE.CORTEX.COMPLETE function specifying a RESPONSE_FORMAT in the options argument, and use dot notation to extract the data to put into the three new columns.

B.

Use the SNOWFLAKE.CORTEX.COMPLETE function specifying a TOP_P in the options argument, and parse the value of the CHOICES response key.

C.

Use the SNOWFLAKE.CORTEX.ENTITY_SENTIMENT function in a SELECT statement once for each of the three new columns.

D.

Call the SNOWFLAKE.CORTEX.EXTRACT_ANSWER function in a SELECT statement, and use dot notation to extract data to put into the three new columns.

E.

Call the SNOWFLAKE.CORTEX.EXTRACT_ANSWER function in a SELECT statement once for each of the three new columns.

Questions 4

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

Questions 5

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?

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

Questions 6

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

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

Questions 7

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)

Questions 8

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

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

Questions 9

Which components are necessary to deploy and run a container with Snowpark Container Services? (Choose two)

Options:
A.

A compute pool to run the container

B.

An external stage linked to Amazon S3

C.

A schedule task assigned to a virtual warehouse

D.

A file format registered for JSON or CSV data ingestion

E.

A service specification that defines the container behavior

Questions 10

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

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