DP-800 - Microsoft Certified SQL AI Developer Associate Cheat Sheet

8 practice tests · 333 questions

Pick an answer to see if it was correct and why, then continue.

Test 1
Table Design Fundamentals: Data Types, Indexes, Constraints & Sequences, Specialized Table Types: In-Memory, Temporal, External, Ledger & Graph, JSON Columns, JSON Indexes & Table/Index Partitioning
41 questions
Test 2
Views, Functions, Stored Procedures & Triggers, CTEs, Window Functions & Correlated Queries, JSON Query Functions in T-SQL
41 questions
Test 3
Regular Expression & Fuzzy String Matching Functions, Graph Queries with MATCH & T-SQL Error Handling, AI-Assisted SQL Development: GitHub Copilot & Copilot in Fabric
43 questions
Test 4
Data Encryption, Dynamic Data Masking & Row-Level Security, Object-Level Permissions, Secure Access & Auditing, Securing AI Model, GraphQL, REST & MCP Endpoints
39 questions
Test 5
Database Performance: Isolation Levels, Execution Plans & Deadlocks, SQL Database Projects: Models, SDK-Style Projects & Source Control, Testing Strategy & Schema Drift Detection
41 questions
Test 6
Branching, Pull Requests & Secrets Management, Deploying SQL Database Projects & Pipeline Controls, Data API Builder (DAB): Configuration & Entity Design
35 questions
Test 7
Data API Builder (DAB): Exposing Database Objects & Deployment, Azure Monitor & Change Event Handling, External AI Models in SQL: Evaluation & Management
34 questions
Test 8 · Final
Embeddings: Column Selection, Chunking, Maintenance & Generation, Choosing a Search Strategy & Implementing Full-Text Search, Vector Data Types, Functions & Index Design, Implementing Vector Search, Hybrid Search & Reciprocal Rank Fusion, Retrieval-Augmented Generation (RAG) in SQL
59 questions
+150 XP

Table Design Fundamentals: Data Types, Indexes, Constraints & Sequences, Specialized Table Types: In-Memory, Temporal, External, Ledger & Graph, JSON Columns, JSON Indexes & Table/Index Partitioning

Views, Functions, Stored Procedures & Triggers, CTEs, Window Functions & Correlated Queries, JSON Query Functions in T-SQL

Regular Expression & Fuzzy String Matching Functions, Graph Queries with MATCH & T-SQL Error Handling, AI-Assisted SQL Development: GitHub Copilot & Copilot in Fabric

Data Encryption, Dynamic Data Masking & Row-Level Security, Object-Level Permissions, Secure Access & Auditing, Securing AI Model, GraphQL, REST & MCP Endpoints

Database Performance: Isolation Levels, Execution Plans & Deadlocks, SQL Database Projects: Models, SDK-Style Projects & Source Control, Testing Strategy & Schema Drift Detection

Branching, Pull Requests & Secrets Management, Deploying SQL Database Projects & Pipeline Controls, Data API Builder (DAB): Configuration & Entity Design

Data API Builder (DAB): Exposing Database Objects & Deployment, Azure Monitor & Change Event Handling, External AI Models in SQL: Evaluation & Management

Embeddings: Column Selection, Chunking, Maintenance & Generation, Choosing a Search Strategy & Implementing Full-Text Search, Vector Data Types, Functions & Index Design, Implementing Vector Search, Hybrid Search & Reciprocal Rank Fusion, Retrieval-Augmented Generation (RAG) in SQL

Table Design Fundamentals: Data Types, Indexes, Constraints & Sequences, Specialized Table Types: In-Memory, Temporal, External, Ledger & Graph, JSON Columns, JSON Indexes & Table/Index Partitioning

Views, Functions, Stored Procedures & Triggers, CTEs, Window Functions & Correlated Queries, JSON Query Functions in T-SQL

Regular Expression & Fuzzy String Matching Functions, Graph Queries with MATCH & T-SQL Error Handling, AI-Assisted SQL Development: GitHub Copilot & Copilot in Fabric

Data Encryption, Dynamic Data Masking & Row-Level Security, Object-Level Permissions, Secure Access & Auditing, Securing AI Model, GraphQL, REST & MCP Endpoints

Database Performance: Isolation Levels, Execution Plans & Deadlocks, SQL Database Projects: Models, SDK-Style Projects & Source Control, Testing Strategy & Schema Drift Detection

Branching, Pull Requests & Secrets Management, Deploying SQL Database Projects & Pipeline Controls, Data API Builder (DAB): Configuration & Entity Design

Data API Builder (DAB): Exposing Database Objects & Deployment, Azure Monitor & Change Event Handling, External AI Models in SQL: Evaluation & Management

Embeddings: Column Selection, Chunking, Maintenance & Generation, Choosing a Search Strategy & Implementing Full-Text Search, Vector Data Types, Functions & Index Design, Implementing Vector Search, Hybrid Search & Reciprocal Rank Fusion, Retrieval-Augmented Generation (RAG) in SQL