nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #188

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #188: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #188. The question stem and answer options stay visible for context.

Designing and Implementing Database Solutions

Question

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-

Options

  • ACreate a stored procedure that uses a regular expression to match the customer's search text to
  • BCreate and populate a column of product description embeddings on the product table and
  • CUse the LIKE operator to match the customer's search text to the product description and return
  • DCreate a SQL script that compares the product description and the customer's search text by using

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Database Design#Text Embeddings#Semantic Search#Cloud SQL
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions