Question 480
A hybrid search runs full lexical scans despite an available full-text index and unexpectedly saturates database CPU. A customer-facing search returns identical repetitive passages from multiple copies of the same handbook page. Which response best addresses these needs?
Explanation
Correct Answer
First, text-search predicate choice affects whether the engine can use a dedicated search index. Second, repeated near-identical evidence wastes model tokens and can bias generated answers toward duplicates.
Incorrect Answers
Inspect the query plan and use the appropriate indexed full-text predicates before increasing database size.
Evaluate supported prefiltering or appropriately scoped candidate retrieval before ranking category-specific neighbors; Deduplicate source chunks and apply version-aware grouping before assembling search context: text-search predicate choice affects whether the engine can use a dedicated search index.
Inspect the query plan and use the appropriate indexed full-text predicates before increasing database size; limit candidate count with measured top-k, filtering and reranking while checking answer evidence recall: repeated near-identical evidence wastes model tokens and can bias generated answers toward duplicates.



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