Question 370
A catalogue search returns all records containing the word 'premium' but cannot rank them by actual product description relevance. Which action best addresses the database requirement?
Explanation
Correct Answer
Search relevance needs an explicit ranking method beyond simple presence of one common term.
Incorrect Answers
Implement or combine full-text search for exact terms and test identifier recall against representative queries: implement or combine full-text search for exact terms and test identifier recall against representative queries: lexical search can preserve token matching that semantic embeddings may not rank highly.
Evaluate appropriate exact-match filtering or tokenization settings for structured identifiers: identifier retrieval can require exact key search when natural-language tokenization changes the term.
Evaluate SQL full-text indexing and supported CONTAINS or related predicates for the intended language behavior: evaluate SQL full-text indexing and supported CONTAINS or related predicates for the intended language behavior: full-text indexes support token-based search at scale more effectively than indiscriminate wildcard scans.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests