Design and Implement Intelligent Search DP-800 Practice Questions (Page 10)

Questions 46–47

1. 46foundation · easy

   What is the primary trade-off when choosing Approximate Nearest Neighbors (ANN) over Exact Nearest Neighbors (ENN) for vector search?

   • AANN requires more storage than ENN
   • BANN is only available for small datasets
   • CANN provides faster search at the cost of some accuracy
   • DANN provides exact results but is slower
   Reveal Solution Discussion Select an answer first
2. 47application · medium

   A document management system runs hybrid search in Azure SQL Database. The team wants to combine full-text and vector search results into a single ranked list. They are using RRF. What is the correct way to implement RRF in their query?

   • AUse a subquery to compute the sum of the ranks and then divide by two.
   • BUse the RRF function in the ORDER BY clause, passing the full-text rank and vector distance as arguments.
   • CRun both searches separately and average the raw scores in the application layer.
   • DUse UNION to combine results and then ORDER BY the full-text rank only.
   Reveal Solution Discussion Select an answer first