Microsoft Certified:SQL AI Developer Associate
Domain 3Objective 1
Design and Implement Models and Embeddings DP-800 Practice Questions (Page 2)
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 6–10
- 6
Which embedding maintenance method uses an Azure service that can react to database changes and call a function to regenerate embeddings?
Select an answer first - 7
When designing embeddings for a product catalog, which column is most important to include to capture the product's semantic meaning?
Select an answer first - 8
A healthcare analytics company is building a multilingual patient-support chatbot. The database stores patient education documents in English, Spanish, and French. The team needs to generate embeddings for semantic search. They are evaluating two external embedding models: Model A supports 50 languages and outputs 384-dimensional vectors; Model B supports 10 languages and outputs 1536-dimensional vectors. The team's primary requirement is accurate cross-lingual retrieval, and they have ample storage and compute budget. Which model should they select?
Select an answer first - 9
A company uses an external embedding model for a production search feature. The model vendor announces a new version that improves accuracy but changes the vector dimensionality from 768 to 1024. The team must update without downtime. They have a large corpus of existing embeddings. Which approach best balances accuracy improvement and operational risk?
Select an answer first - 10
A customer support portal stores tickets with the following columns: TicketID, Subject, Description, Status, Priority, CreatedDate, and ResolvedDate. The team wants to generate embeddings to enable semantic search over past tickets. Which columns should be included in the embedding text?
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.