Microsoft Certified:SQL AI Developer Associate
Domain 3Objective 1
Design and Implement Models and Embeddings DP-800 Practice Questions (Page 7)
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 33 practice questions to prepare you well beyond it. (estimate)
33questions here
7free pages
7concepts
25–30%of the exam
Questions 31–33
- 31
When evaluating an external AI model for use in a database solution, which factor is most directly relevant to the model's ability to handle both text and image inputs?
Select an answer first - 32
A retail company stores product descriptions in a SQL database. They want to use an external AI model to generate embeddings for semantic search. The product descriptions are in English, French, and Spanish, and the search must support queries in all three languages. The team also needs the model to return a fixed-size vector for each description. Which model evaluation criterion is most important to verify before selecting the model?
Select an answer first - 33
A support ticketing system stores tickets in a SQL database. The team wants to build a semantic search feature that matches new tickets to historical resolutions. Each ticket has a subject, body, priority, status, and assigned agent. Which columns should be included in the embedding to optimize search relevance?
Select an answer first
Finished these 3 questions?
Review the revealed explanations, or continue through the curriculum.
No more pagesBack to DP-800
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.