← DP-800 study guideNext domain
Domain 2 – Secure, Optimize, and Deploy Database Solutions (35–40%)
8 lessons, each ending with a practice scenario (Pro)
Log in to save your progress.
- ✓2.1 — Data Encryption: Always Encrypted and Column-Level EncryptionEncryption questions turn on one point: who must not be able to read the data. Database administrators? Someone who steals the files? Someone sniffing the network? Each answer points to a different feature.Scenario: Pro
- ✓2.2 — Dynamic Data Masking, Row-Level Security and Object-Level PermissionsThese three features control what an authenticated user sees: masked values, a subset of rows, or only certain objects. They complement encryption (lesson 2.1).Scenario: Pro
- ✓2.3 — Passwordless Access, Auditing and Securing EndpointsAI-enabled databases talk to applications, AI model endpoints and APIs (REST, GraphQL, MCP). Every one of those connections needs an identity, least privilege, and an audit trail. Passwords and keys in connection strings are the anti-pattern.Scenario: Pro
- ✓2.4 — Database Configuration, Isolation Levels and ConcurrencyPerformance and correctness both depend on how the database is configured and how transactions see each other's changes. Questions ask for the setting that fixes a symptom, such as blocking, inconsistent reads or slow parallel queries.Scenario: Pro
- ✓2.5 — Evaluate Query Performance and Resolve Blocking and DeadlocksYou need to know which tool shows what, how to read an execution plan, and how to tell blocking from deadlocks.Scenario: Pro
- ✓2.6 — CI/CD with SQL Database ProjectsSQL Database Projects turn a database schema into source code: one .sql file per object, built into a .dacpac and deployed by comparing it with the target. DP-800 tests the whole lifecycle, from repository to production.Scenario: Pro
- ✓2.7 — Expose Data with Data API Builder (REST and GraphQL)Data API builder (DAB) turns tables, views and stored procedures into secure REST and GraphQL endpoints, and optionally MCP tools, from a single configuration file, with no API code. It runs as a container or process, and it also powers Fabric's API for GraphQL.Scenario: Pro
- ✓2.8 — Azure Monitor and Handling Data ChangesProduction SQL solutions need observability (Azure Monitor) and a reliable way to react when data changes, for example to refresh embeddings, sync caches or feed analytics. DP-800 lists five change-handling options. Know when each one fits.Scenario: Pro
Domain recapQuick overview of all lessons
- Encrypt data with Always Encrypted and column-level encryption, and mask, filter and permission it with DDM, RLS and object-level permissions
- Implement passwordless access, auditing, and secure AI model, REST, GraphQL and MCP endpoints
- Recommend configurations, isolation levels and concurrency controls
- Evaluate performance with execution plans, DMVs, Query Store and Query Performance Insight, and resolve blocking and deadlocks
- Implement CI/CD with SQL Database Projects: build, test, reference data, drift detection, branching and pipeline controls
- Expose data with Data API builder, monitor with Azure Monitor, and handle changes with CES, CDC, Change Tracking, Functions and Logic Apps
Domain 3: Implement AI capabilities in database solutions →