Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Snowflake SnowPro Specialty: Gen AI Exam GES-C02 Question # 5 Topic 1 Discussion

Snowflake SnowPro Specialty: Gen AI Exam GES-C02 Question # 5 Topic 1 Discussion

GES-C02 Exam Topic 1 Question 5 Discussion:
Question #: 5
Topic #: 1

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


Get Premium GES-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.