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
- 16
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 - 17
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 - 18
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 - 19
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 - 20
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.