🚀 Launch Special: $29/mo for life --d --h --m --s Claim Your Price →
DP-420
DP-420 Microsoft Azure

Cosmos DB Developer

The DP-420 training teaches developers how to design, implement, distribute, integrate, optimize, and maintain Azure Cosmos DB solutions, covering data modeling, partitioning, consistency, performance tuning, and operational best practices.

120
Minutes
50
Questions
700/1000
Passing Score
$165
Exam Cost
4
Languages

Who Should Take This

It is intended for software engineers, data engineers, or solution architects who have 1‑2 years of hands‑on Azure Cosmos DB experience and at least two years developing cloud‑native applications. These professionals seek to validate their expertise, deepen specialty‑level knowledge, and confidently deliver high‑performance, globally distributed data solutions.

What's Covered

1 Designing document schemas, implementing partitioning strategies, configuring indexing policies, and modeling data for the Cosmos DB SQL API.
2 Configuring global distribution, consistency levels, multi-region writes, and conflict resolution policies for Azure Cosmos DB.
3 Implementing change feed processing, Azure Functions triggers, and integrating Cosmos DB with Azure Search and other Azure services.
4 Optimizing request unit consumption, implementing caching strategies, tuning queries, and managing throughput with autoscale and provisioned modes.
5 Implementing backup and restore, monitoring with Azure Monitor, configuring diagnostic logging, and managing security with RBAC and encryption.

Exam Structure

Question Types

  • Multiple Choice
  • Multiple Response
  • Case Studies

Scoring Method

Scaled score 100-1000, passing score 700

Delivery Method

Proctored exam, 40-60 questions, 100 minutes

Prerequisites

None required. DP-900 recommended.

Recertification

Renew annually via free Microsoft Learn renewal assessment

What's Included in AccelaStudy® AI

Adaptive Knowledge Graph
Practice Questions
Lesson Modules
Console Simulator Labs
Exam Tips & Strategy
20 Activity Formats

Course Outline

79 learning goals
1 Domain 1: Design and Implement Data Models
6 topics

Design and implement a non-relational data model for Azure Cosmos DB for NoSQL

  • Implement document structure design for Azure Cosmos DB for NoSQL including property selection, data type mapping, nested objects, and array usage to represent application entities in JSON documents.
  • Analyze embedding versus referencing tradeoffs for related data in Cosmos DB documents including read performance impact, write amplification costs, document size limits, and query complexity implications.
  • Evaluate denormalization pattern tradeoffs for Cosmos DB including data duplication cost, fan-out write overhead, materialized view staleness, and consistency maintenance complexity for read-heavy query workloads.
  • Implement hierarchical partition key configurations for Cosmos DB containers including multi-level key paths, synthetic partition keys, and subpartitioning strategies to improve data distribution granularity.
  • Architect data model designs that balance document structure, embedding depth, denormalization scope, and partition alignment to meet complex multi-access-pattern application requirements within Cosmos DB constraints.

Design a data partitioning strategy

  • Implement partition key selection for Cosmos DB containers by evaluating cardinality, access pattern alignment, and storage distribution to achieve balanced logical partitions.
  • Analyze the relationship between logical partitions and physical partitions including partition splitting behavior, storage limits per logical partition, and throughput distribution across physical partitions.
  • Evaluate hot partition detection strategies and mitigation techniques including synthetic partition keys, write-heavy partition avoidance, and partition key redesign approaches for skewed workloads.
  • Analyze cross-partition query performance implications including fan-out query mechanics, RU cost multipliers, continuation token handling, and strategies to minimize cross-partition operations.
  • Architect partitioning strategies that coordinate partition key selection, hierarchical partitioning, and container topology to support evolving multi-tenant and high-throughput application workloads.

Plan and implement sizing and scaling

  • Implement provisioned throughput allocation for Cosmos DB databases and containers including manual RU/s configuration, shared throughput databases, and dedicated container throughput settings.
  • Configure autoscale throughput for Cosmos DB containers including maximum RU/s settings, scale-up and scale-down behavior, and cost implications compared to manual provisioned throughput.
  • Analyze RU consumption patterns for read operations, write operations, and query execution to estimate capacity requirements and identify optimization opportunities using RU charge analysis.
  • Evaluate serverless capacity mode suitability for Cosmos DB workloads by comparing burst traffic patterns, idle periods, cost models, and feature limitations against provisioned and autoscale alternatives.
  • Plan capacity strategies that balance provisioned throughput, autoscale, and serverless modes across multiple containers to optimize cost-performance ratios for production Cosmos DB deployments.

Implement client connectivity options

  • Configure Cosmos DB SDK client instances including connection mode selection (direct versus gateway), preferred regions list, consistency level overrides, and serialization settings for application connectivity.
  • Analyze retry policy and timeout configuration tradeoffs for Cosmos DB SDK operations including transient fault handling strategies, rate-limiting backoff approaches, and region failover sequencing in multi-region deployments.
  • Analyze direct mode versus gateway mode performance tradeoffs including TCP connection management, port requirements, firewall considerations, and latency characteristics for different deployment environments.
  • Recommend SDK configuration strategies that optimize connection pooling, region affinity, consistency overrides, and failover behavior for high-availability multi-region application architectures.

Implement data access with SQL API

  • Implement SQL queries against Cosmos DB containers including SELECT projections, WHERE filters, ORDER BY sorting, TOP/OFFSET-LIMIT pagination, and parameterized query construction for injection prevention.
  • Assess advanced SQL query pattern applicability including aggregate functions (COUNT, SUM, AVG, MIN, MAX), subqueries, intra-document JOINs, array and object navigation, and user-defined function invocation for complex data retrieval scenarios.
  • Analyze query execution metrics including RU charge, index utilization, retrieved document count versus returned document count, and query plan analysis to identify inefficient query patterns.
  • Formulate query design strategies that balance single-partition and cross-partition queries, denormalized reads versus JOIN operations, and client-side versus server-side filtering to optimize RU consumption across diverse access patterns.

Implement server-side programming

  • Implement stored procedures for Cosmos DB using JavaScript including CRUD operations, query execution within procedures, transaction scoping to logical partitions, and bounded execution with continuation patterns.
  • Implement pre-triggers and post-triggers for Cosmos DB containers including trigger registration, execution order, input document modification, and validation logic for enforcing business rules.
  • Implement user-defined functions for Cosmos DB SQL queries including custom computation logic, string manipulation, and mathematical operations to extend query expressiveness.
  • Implement transactional batch operations for Cosmos DB including multi-operation atomic batches within a single logical partition, error handling, and batch size constraints.
  • Recommend server-side programming approaches that select among stored procedures, triggers, UDFs, and transactional batch to determine the optimal execution model for atomic operations and custom logic requirements.
2 Domain 2: Design and Implement Data Distribution
2 topics

Design and implement replication and global distribution

  • Configure global distribution for Cosmos DB accounts including adding and removing regions, setting write region priorities, and configuring automatic failover policies for multi-region deployments.
  • Analyze consistency level tradeoffs across the five Cosmos DB consistency models (strong, bounded staleness, session, consistent prefix, eventual) including latency impact, availability guarantees, and RU cost implications.
  • Evaluate the impact of consistency level selection on application behavior including read staleness windows, write acknowledgment latency, and cross-region read consistency for globally distributed applications.
  • Architect multi-region distribution strategies that balance consistency requirements, read and write latency targets, availability SLAs, and cost constraints for globally distributed Cosmos DB solutions.

Design and implement multi-region write

  • Configure multi-region write (multi-master) for Cosmos DB accounts including enabling multi-write, understanding region-level write acceptance, and configuring SDK preferred write regions.
  • Implement conflict resolution policies for multi-region write scenarios including last-writer-wins using a configurable conflict resolution path, custom stored procedure resolution, and async conflict feed processing.
  • Recommend conflict resolution strategies by evaluating last-writer-wins, custom merge procedures, and manual conflict resolution approaches including data consistency implications and implementation complexity for multi-region applications.
  • Recommend multi-region write architectures that coordinate conflict resolution policies, consistency levels, and application write patterns to achieve low-latency global writes with acceptable conflict rates.
3 Domain 3: Integrate an Azure Cosmos DB Solution
2 topics

Enable Azure Cosmos DB analytical workload

  • Configure Azure Synapse Link for Cosmos DB including enabling analytical store on containers, setting analytical TTL, and establishing Synapse workspace connectivity for hybrid transactional and analytical processing.
  • Analyze the column store schema inference behavior of analytical store including automatic schema representation, data type handling, nested property flattening, and schema evolution implications for analytical queries.
  • Recommend HTAP architecture approaches by evaluating analytical store RU isolation from transactional workloads, synchronization latency, analytical query cost model, and data freshness requirements for real-time analytics scenarios.

Implement solutions across services

  • Implement Azure Functions Cosmos DB trigger and input/output bindings including change feed-driven function invocation, document reading via input bindings, and document writing via output bindings.
  • Evaluate Cosmos DB integration patterns with Azure Cognitive Search including indexer configuration tradeoffs, field mapping strategies, change detection policy selection, and incremental indexing performance for full-text search scenarios.
  • Assess event-driven integration pattern tradeoffs using Cosmos DB change feed with Azure Event Hub and Stream Analytics for real-time event processing and downstream notification pipeline architectures.
  • Architect cross-service integration strategies that coordinate Cosmos DB with Azure Functions, Search, Event Hub, and Synapse Link to build end-to-end data processing and analytics pipelines.
4 Domain 4: Optimize an Azure Cosmos DB Solution
3 topics

Optimize query performance

  • Analyze query metrics including request charge, index lookup count, retrieved document count, output document count, and execution time to diagnose and resolve query performance bottlenecks.
  • Evaluate query optimization techniques including point reads versus queries, partition-key-aligned queries, projection optimization, and query pagination strategies to minimize RU consumption per operation.
  • Devise query performance optimization plans that coordinate indexing policy changes, query rewrites, data model adjustments, and partition strategy alignment to achieve target RU budgets for critical query workloads.

Design and implement change feed

  • Implement the change feed processor library including lease container configuration, host instance management, delegate handler implementation, and processor lifecycle management for consuming document changes.
  • Implement the change feed estimator to monitor processing lag including pending change count retrieval, estimator polling configuration, and lag metric alerting for change feed health monitoring.
  • Determine materialized view design approaches using change feed to maintain denormalized copies, aggregate views, and cross-container projections that support multiple query access patterns from a single source container.
  • Analyze change feed processing patterns including latest version mode versus all versions and deletes mode, start-from-beginning versus start-from-now semantics, and partition-level parallelism behavior.
  • Architect event-driven architectures using Cosmos DB change feed that coordinate materialized views, cross-service notifications, audit logging, and real-time analytics processing for complex application workflows.

Define and implement an indexing strategy

  • Configure indexing policies for Cosmos DB containers including indexing mode selection (consistent versus none), included and excluded property paths, and wildcard path specifications.
  • Implement composite indexes for Cosmos DB including multi-property index definitions, ascending and descending order specifications, and composite index optimization for ORDER BY and equality-plus-range query patterns.
  • Configure spatial indexes and range indexes for Cosmos DB including geography and geometry type indexing, spatial query support, and range index precision configuration for numeric and string properties.
  • Analyze indexing policy tradeoffs including write RU cost of index maintenance, index storage overhead, query performance impact of excluded paths, and index transformation behavior during policy updates.
  • Formulate indexing strategies that balance write performance, storage efficiency, and query optimization by selecting appropriate included paths, composite indexes, and spatial indexes for multi-workload container configurations.
5 Domain 5: Maintain an Azure Cosmos DB Solution
4 topics

Monitor and troubleshoot an Azure Cosmos DB solution

  • Configure Azure Monitor diagnostic settings for Cosmos DB including enabling diagnostic logs, configuring log categories (DataPlaneRequests, QueryRuntimeStatistics, PartitionKeyStatistics), and routing to Log Analytics workspace.
  • Implement Azure Cosmos DB Insights monitoring including throughput utilization dashboards, normalized RU consumption analysis, storage distribution views, and request volume tracking across database accounts.
  • Configure alert rules for Cosmos DB metrics including normalized RU consumption thresholds, server-side latency alerts, total request unit alerts, and storage capacity warning notifications.
  • Analyze rate-limiting (HTTP 429) response patterns including throttled request identification, partition-level throttle diagnosis, and throughput redistribution analysis to resolve request-rate-too-large errors.
  • Troubleshoot high latency issues in Cosmos DB including server-side latency versus client-side latency decomposition, network round-trip analysis, and regional routing diagnosis for multi-region accounts.
  • Devise monitoring strategies that establish performance baselines, detect anomalous patterns, and correlate RU consumption trends with application workload changes for proactive Cosmos DB capacity management.

Implement backup and restore for Azure Cosmos DB

  • Configure continuous backup mode for Cosmos DB accounts including retention period settings, point-in-time restore capabilities, and understanding of continuous backup storage costs and limitations.
  • Compare periodic backup mode configuration options for Cosmos DB accounts including backup interval and retention settings, backup storage redundancy options, and periodic backup restoration procedures through Azure support.
  • Implement point-in-time restore operations for Cosmos DB including restore to a new account, container-level and database-level restore granularity, and restoration of deleted containers within the retention window.
  • Evaluate backup strategy tradeoffs between continuous and periodic backup modes including cost implications, restore granularity, RPO guarantees, self-service versus support-assisted restore, and migration between backup modes.
  • Plan backup and disaster recovery strategies that coordinate backup mode selection, restore procedures, multi-region failover, and data durability requirements for mission-critical Cosmos DB deployments.

Implement security for Azure Cosmos DB

  • Configure Microsoft Entra ID authentication for Cosmos DB including role-based access control (RBAC) with built-in and custom role definitions, service principal authentication, and managed identity integration.
  • Evaluate Cosmos DB account key management practices including primary and secondary key rotation procedures, read-only key usage scenarios, and resource token generation tradeoffs for fine-grained document-level access control.
  • Configure data encryption for Cosmos DB including service-managed encryption at rest, customer-managed keys (CMK) with Azure Key Vault, and encryption-in-transit enforcement via TLS settings.
  • Configure network security for Cosmos DB accounts including IP firewall rules, virtual network service endpoints, private endpoints with Azure Private Link, and public network access restrictions.
  • Analyze authentication approach tradeoffs between account keys, resource tokens, and Microsoft Entra ID RBAC including security posture, operational complexity, and least-privilege granularity for different application scenarios.
  • Evaluate network isolation tradeoffs between IP firewall rules, virtual network service endpoints, and private endpoints including connectivity scope, DNS resolution requirements, and cross-region access implications.
  • Architect defense-in-depth security strategies that coordinate Entra ID RBAC, network isolation, encryption, and audit logging to establish comprehensive security posture for production Cosmos DB environments.

Implement data movement for Azure Cosmos DB

  • Implement data migration to Cosmos DB using Azure Data Factory including Cosmos DB linked service configuration, copy activity mapping, throughput provisioning for migration workloads, and error handling.
  • Implement data movement using the Azure Cosmos DB Spark connector including bulk read and write operations, throughput control configuration, and schema mapping for large-scale data ingestion and extraction.
  • Implement bulk operations using the Cosmos DB SDK bulk executor capabilities including bulk import, bulk update, throughput control during bulk operations, and progress monitoring for high-volume data loading.
  • Recommend data migration tool selection by evaluating Azure Data Factory, Spark connector, bulk executor SDK, and the Cosmos DB data migration tool based on data volume, source format, transformation requirements, and throughput impact.
  • Plan data movement strategies that coordinate migration tooling, throughput provisioning, data validation, and cutover procedures for production Cosmos DB data migration and ongoing data synchronization scenarios.

Hands-On Labs

15 labs ~280 min total Console Simulator

Practice in a simulated cloud console or Python code sandbox — no account needed. Each lab runs entirely in your browser.

Certification Benefits

Salary Impact

$140,000
Average Salary

Related Job Roles

Cosmos DB Developer NoSQL Developer Cloud Database Developer Backend Developer

Industry Recognition

Microsoft Azure certifications are among the most valued in enterprise IT, with Microsoft holding the second-largest cloud market share globally and serving as the dominant platform in enterprise and hybrid cloud environments.

Scope

Included Topics

  • All domains and task statements in the Microsoft Azure Cosmos DB Developer Specialty (DP-420) exam guide: Domain 1 Design and Implement Data Models (35-40%), Domain 2 Design and Implement Data Distribution (5-10%), Domain 3 Integrate an Azure Cosmos DB Solution (5-10%), Domain 4 Optimize an Azure Cosmos DB Solution (15-20%), and Domain 5 Maintain an Azure Cosmos DB Solution (25-30%).
  • Specialty-level Cosmos DB development and architecture decisions for Azure Cosmos DB for NoSQL including data modeling, partition key selection, denormalization patterns, embedding versus referencing, hierarchical partition keys, provisioned throughput and autoscale configuration, serverless mode, RU estimation and capacity planning, SDK configuration, connection modes, SQL queries, server-side programming, global distribution, consistency levels, conflict resolution, multi-region writes, Azure Synapse Link, analytical store, change feed processing, indexing policy optimization, monitoring, backup and restore, security hardening, and data movement strategies.
  • Complex scenario-based tradeoff analysis involving partition strategy design, consistency level selection, RU optimization, indexing policy tuning, change feed architecture, multi-region deployment, security configuration, and integration with Azure Functions, Azure Search, Event Hub, Stream Analytics, Azure Data Factory, and Spark connectors.
  • Key Azure services and features for Cosmos DB developers: Azure Cosmos DB for NoSQL (containers, databases, partition keys, hierarchical partition keys, provisioned throughput, autoscale, serverless), Cosmos DB SDK (.NET, Java, Python, JavaScript), stored procedures, triggers, UDFs, transactional batch, change feed processor, change feed estimator, Azure Synapse Link, analytical store, Azure Functions Cosmos DB bindings, Azure Monitor, diagnostic settings, Azure Cosmos DB insights, continuous backup, periodic backup, point-in-time restore, Microsoft Entra ID, RBAC, resource tokens, data encryption, private endpoints, Azure Data Factory Cosmos DB connector, Spark connector, bulk executor library, and data migration tool.

Not Covered

  • Non-NoSQL API Cosmos DB implementations including Azure Cosmos DB for MongoDB, Apache Cassandra, Apache Gremlin, and Table API beyond brief comparative context for API selection decisions.
  • General Azure platform administration, networking, and subscription management not directly related to Cosmos DB provisioning, configuration, or operations.
  • Application development patterns, microservice architecture, and CI/CD pipeline design that do not directly relate to Cosmos DB data modeling, querying, or operational management.
  • Current Azure pricing specifics, promotional discounts, and region-specific cost values that change frequently over time.
  • Azure SQL Database, Azure SQL Managed Instance, and relational database administration topics covered by the DP-300 certification except where migration or integration with Cosmos DB is relevant.

Official Exam Page

Learn more at Microsoft Azure

Visit

Ready to master DP-420?

Adaptive learning that maps your knowledge and closes your gaps.

Subscribe to Access

Trademark Notice

Microsoft and Azure are registered trademarks of Microsoft Corporation. Microsoft does not endorse this product.

AccelaStudy® and Renkara® are registered trademarks of Renkara Media Group, Inc. All third-party marks are the property of their respective owners and are used for nominative identification only.