Microsoft Certified: SQL AI Developer Associate Questions and Answers
200 questions organized by topic with detailed explanations
Microsoft
DP-800
200 questions
3 topics
Updated May 2026Design and develop database solutions
76 questions20 easy37 medium19 hard~38% of exam
A developer needs to convert JSON text into a rowset that can be joined with relational tables. Which function should be...A developer needs a fuzzy matching function that returns an integer similarity score from 0 to 100 rather than a raw edi...A query must return a JSON array stored at a given path rather than a scalar. Which function should be used?
Secure, optimize, and deploy database solutions
74 questions20 easy38 medium16 hard~37% of exam
A CI/CD pipeline runs `SqlPackage` against Azure SQL Database. Which authentication method is recommended for automated ...An application cancels a long-running statement inside an explicit transaction and leaves the session sleeping with open...A team needs historical Azure SQL Database resource data for approximately the last 14 days. Which view should they quer...
Implement AI capabilities in database solutions
50 questions12 easy25 medium13 hard~25% of exam
What is the default base type used by the `VECTOR` data type when none is specified?A database is running at compatibility level 160. What happens when a developer tries to use `AI_GENERATE_CHUNKS`?A developer wants overlapping fixed-size chunks for retrieval preparation. Which `OVERLAP` value is valid for `AI_GENERA...
All Questions
| # | Question | Topic | Difficulty |
|---|---|---|---|
| 1 | A developer needs to convert JSON text into a rowset that can be joined with relational tables. Whic... | Design and develop database solutions | medium |
| 2 | A CI/CD pipeline runs `SqlPackage` against Azure SQL Database. Which authentication method is recomm... | Secure, optimize, and deploy database solutions | medium |
| 3 | What is the default base type used by the `VECTOR` data type when none is specified? | Implement AI capabilities in database solutions | medium |
| 4 | An application cancels a long-running statement inside an explicit transaction and leaves the sessio... | Secure, optimize, and deploy database solutions | hard |
| 5 | A database is running at compatibility level 160. What happens when a developer tries to use `AI_GEN... | Implement AI capabilities in database solutions | easy |
Sign in to see all 200 questions
Create a free account to browse all questions — completely free during our launch phase.
Ready to test your knowledge?
Take a full Microsoft Certified: SQL AI Developer Associate practice test with timed exam simulation.
Start Practice Test