Examers.io
ExamsOrganizationsHow it worksPricingHelp & FAQ
Microsoft logo

Microsoft Certified:SQL AI Developer Associate

Domain 3Objective 2

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

Part of the Implement AI capabilities in database solutions domain, which accounts for 25–30% of the DP-800 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~13–24 in this domain), expect 4–8 from this objective — we provide 47 practice questions to prepare you well beyond it. (estimate)

47questions here
10free pages
10concepts
25–30%of the exam

Questions 16–20

  1. 16expert · hard

    A legal research platform stores 10 million document embeddings. Users search for precedents and require exact similarity rankings because a single missing relevant document could change case outcomes. The current ANN index returns results in 200 ms but occasionally misses a true nearest neighbor. The team is willing to accept higher latency for accuracy. What should they do?

    Select an answer first
  2. 17expert · hard

    A team is designing a vector search solution for a dataset of 100 million short text snippets. They need to minimize storage cost while maintaining fast search. They are considering using 256-dimensional embeddings instead of 1536-dimensional embeddings. What is the primary trade-off they should consider?

    Select an answer first
  3. 18expert · hard

    A company wants to implement semantic search over customer feedback. They have a team of data scientists who can generate embeddings, but they are unsure whether to use a pre-trained model or a custom fine-tuned model. The feedback contains industry-specific jargon. What should they consider?

    Select an answer first
  4. 19application · medium

    A job portal searches resumes. Recruiters search for exact skills like 'Python' and also for broader concepts like 'team leadership'. The current full-text search returns exact matches but misses conceptual matches. They want to improve results without losing exact-match capability. What should they implement?

    Select an answer first
  5. 20foundation · easy

    Which metric measures the fraction of relevant documents that are retrieved by a search?

    Select an answer first
Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-800” is a trademark of its owner, used for identification only.