Microsoft's skills measured for DP-800 as of October 19, 2026, mapped to the chapters of Ultra Transcenders DP-800: Developing AI-Enabled Database Solutions.
| Objective | Chapters |
|---|---|
| Design and develop database solutions (35–40%) | |
| Design and implement database objects | 1. Designing tables; 2. Specialised tables, JSON storage and partitioning |
| Implement programmability objects | 3. Programmability objects and error handling |
| Write advanced T-SQL code | 3. Programmability objects and error handling; 4. Advanced T-SQL queries; 5. JSON, regular expression and fuzzy matching functions |
| Design and implement SQL solutions by using AI-assisted tools | 6. AI-assisted SQL development |
| Secure, optimize, and deploy database solutions (35–40%) | |
| Implement data security and compliance | 7. Encryption, masking, row-level security and permissions; 8. Secure access, auditing and securing endpoints |
| Optimize database performance | 9. Optimising performance and concurrency |
| Implement CI/CD by using SQL Database Projects | 10. CI/CD with SQL Database Projects |
| Integrate SQL solutions with Azure services | 11. Data API builder and monitoring; 12. Handling data changes |
| Implement AI capabilities in database solutions (25–30%) | |
| Design and implement models and embeddings | 13. Models and embeddings |
| Design and implement intelligent search | 14. Intelligent search and RAG |
| Design and implement retrieval-augmented generation (RAG) | 14. Intelligent search and RAG |
The full list of tasks under each objective is in the official DP-800 study guide and practice assessment. The book is organised by technology, so one chapter often serves several objectives.