Examers.io
ExamsOrganizationsHow it worksPricingHelp & FAQ
Sign inStart free
MICROSOFT

Microsoft Certified:SQL AI Developer Associate

DP-800SQL AI Developer Associate

The Microsoft Certified: SQL AI Developer Associate certification validates your expertise in designing and developing AI-enabled database solutions across Microsoft SQL platforms. It is ideal for professionals who integrate AI features into scalable enterprise applications. Earning this certification demonstrates your ability to secure, optimize, and deploy database solutions with AI capabilities.

Practice Free Questions

436 practice questions · Updated 2023-10-01

3Domains
11Objectives
104Concepts
436Questions

DP-800 Curriculum

Every domain, objective, and concept the DP-800 exam measures.

Design and implement database objects

17 concepts · 47 questions
  1. Table Design
  2. Index Implementation
  3. In-Memory Tables
  4. Temporal Tables
  5. External Tables
  6. Ledger Tables
  7. Graph Tables
  8. JSON Columns
  9. JSON Indexes
  10. Primary Key Constraints
  11. Foreign Key Constraints
  12. Unique Constraints
  13. Check Constraints
  14. Default Constraints
  15. Sequences
  16. Table Partitioning
  17. Index Partitioning

Implement programmability objects

5 concepts · 32 questions
  1. View Creation
  2. Scalar Function Creation
  3. Table-Valued Function Creation
  4. Stored Procedure Creation
  5. Trigger Creation

Write advanced T-SQL code

8 concepts · 31 questions
  1. Common Table Expressions (CTEs)
  2. Window Functions
  3. JSON Functions
  4. Regular Expressions in SQL
  5. Fuzzy String Matching
  6. Graph Queries with MATCH
  7. Correlated Queries
  8. Error Handling in T-SQL

Design and implement SQL solutions by using AI-assisted tools

7 concepts · 44 questions
  1. Security Impact of AI Tools
  2. Enable GitHub Copilot
  3. Enable Microsoft Copilot
  4. Configure Model Options
  5. Configure MCP Tool Options
  6. Create Copilot Instruction Files
  7. Connect to MCP Server Endpoints

Implement data security and compliance

15 concepts · 55 questions
  1. Data Encryption Design
  2. Always Encrypted Implementation
  3. Column-Level Encryption
  4. Dynamic Data Masking Design
  5. Dynamic Data Masking Implementation
  6. Row-Level Security Design
  7. Row-Level Security Implementation
  8. Object-Level Permissions Design
  9. Object-Level Permissions Implementation
  10. Secure Database Access
  11. Database Auditing Implementation
  12. Secure Model Endpoints
  13. Secure GraphQL Endpoints
  14. Secure REST Endpoints
  15. Secure MCP Endpoints

Optimize database performance

9 concepts · 32 questions
  1. Database Configuration Recommendation
  2. Transaction Isolation Levels
  3. Concurrency Control Mechanisms
  4. Query Execution Plans Analysis
  5. Dynamic Management Views Usage
  6. Query Store Utilization
  7. Query Performance Insight Application
  8. Blocking and Deadlocks Identification
  9. Query Performance Issue Resolution

Implement CI/CD by using SQL Database Projects

14 concepts · 52 questions
  1. Testing Strategy Design
  2. Unit Test Implementation
  3. Integration Test Implementation
  4. Reference Data Management
  5. Database Model Creation
  6. Database Model Validation
  7. Source Control Configuration
  8. Branch Management
  9. Secrets Management Implementation
  10. Schema Drift Detection
  11. Database Project Updates
  12. Deployment Pipeline Controls
  13. Authentication Table Design
  14. Code Ownership Assignment

Integrate SQL solutions with Azure services

7 concepts · 30 questions
  1. Data API Builder Configuration
  2. Entity Configuration for REST and GraphQL
  3. Endpoint Configuration
  4. Database Object Exposure
  5. DAB Deployment
  6. Azure Monitor Configuration
  7. Change Event Streaming

Design and implement models and embeddings

7 concepts · 33 questions
  1. Evaluate External Models
  2. Create External Models
  3. Manage External Models
  4. Embedding Maintenance Methods
  5. Column Selection for Embeddings
  6. Design Embedding Chunks
  7. Generate Embeddings

Design and implement retrieval-augmented generation (RAG)

5 concepts · 33 questions
  1. RAGUseCases
  2. CreatePromptUsingSP
  3. StructuredDataToJSON
  4. SendResultsToModel
  5. ExtractModelResponses
Ready to practice?Test your knowledge with exam-style questions or take an intelligent quiz tailored to your level.
Practice Free Questions

Percentages reflect share of the current practice bank, not official exam weightings — no structured per-skill weight is published for DP-800, so none is invented.