↓ Skip to main content
  1. Certifications/
  2. DP-420 Study Hub/
  3. DP-420 Exam Domains/

Domain 1: Design and develop database solutions

Domain 1 is the foundation of the exam. It covers choosing throughput, consistency, and account settings; initializing SDK clients; point reads, queries with paging, patch, batch, bulk, time to live, and optimistic concurrency; data models, partition keys, hierarchical and synthetic keys, and workload cost; the change feed processor, pull model, lease containers, and container copy jobs; and Agent Kit for AI-assisted Azure Cosmos DB development.

40–45%Of the exam
5Objectives
48Practice questions
8Official exercises

Skills measured

Objectives and skills below are quoted from the official study guide. The count beside each skill is how many exam simulator questions test it.

1.1 Evaluate resource models and SDK solutions

  • Evaluate consistency levels2
  • Evaluate Request Unit (RU) consumption requirements2
  • Evaluating and configuring appropriate throughput3
  • Configure account-level and container-level settings1
  • Create and manage database and containers1
  • Initialize SDK clients and connections2

1.2 Implement database operations

  • Implement queries, parameterized queries, paging, and continuation tokens2
  • Implement point read operations1
  • Implement create, replace, update, patch and delete operations3
  • Implement bulk, batch, and transactional operations4
  • Configure Time to Live (TTL)1
  • Implement concurrency control mechanisms1

1.3 Design and implement data models and partitioning strategies

  • Design data models for access patterns and operational requirements2
  • Design and select partition keys based on cardinality, access patterns, and write distribution requirements2
  • Determine when to embed or reference related data1
  • Evaluate the impact of partition key selection on scalability and performance1
  • Implement hierarchical partition keys (HPKs) and multi-tenant partitioning strategies2
  • Implement synthetic partition keys1
  • Identify partitioning anti-patterns and partitioning issues during solution reviews2
  • Estimate workload cost requirements2

1.4 Implement change feed

  • Implement change feed operations3
  • Differentiate between change feed processor and pull mode models1
  • Configure lease containers1
  • Implement change feed processing using latest mode or all versions and delete2
  • Implement copy container jobs1

1.5 Design and implement Azure Cosmos DB solutions by using AI-assisted tools

  • Implement Agent Kit to follow Azure Cosmos DB development recommended solutions2
  • Implement Agent Kit to accelerate AI application development2

Official training and documentation

Microsoft Learn modules and product documentation for each objective, chosen for the current skills measured. Module durations are Microsoft's estimates.

1.5 Design and implement Azure Cosmos DB solutions by using AI-assisted tools

Documentation

Practice this domain

Related