Exam Professional Cloud Database Engineer topic 1 question 168 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 168
Topic #: 1

[All Professional Cloud Database Engineer Questions]

You have a Cloud SQL for MySQL instance with a table of product information including a column of product descriptions. Your application development team is building a customer facing chatbot and would like to find the product that most closely matches a freeform text description provided by the customer. How should you enable this functionality?

A. Create a stored procedure that uses a regular expression to match the customer’s search text to values in the product description column.
B. Create and populate a column of product description embeddings on the product table and perform an approximate nearest neighbor search using the customer’s search text.
C. Use the LIKE operator to match the customer’s search text to the product description and return similar rows.
D. Create a SQL script that compares the product description and the customer’s search text by using the SOUNDEX function.

Show Suggested Answer

Suggested Answer: B 🗳️

by Sai_Vignesh at Aug. 7, 2025, 3:18 a.m.

Comments

Submit Cancel

Sai_Vignesh

1 week, 1 day ago

Selected Answer: D

This is a tough one. My best educated guess is D.

upvoted 1 times

...