Azure DP-420 Certification Fact Sheet¶

Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB¶

Comprehensive quick reference guide with embedded documentation links for hands-on developers preparing for the DP-420 certification exam.

Table of Contents¶

1. Exam Overview
2. Azure Cosmos DB Core Concepts
3. Data Modeling for NoSQL
4. Partitioning Strategies
5. Consistency Levels
6. SQL API and Queries
7. Indexing Policies
8. Change Feed
9. SDKs and Development
10. Performance Optimization
11. Global Distribution
12. Security and Access Control
13. Monitoring and Diagnostics
14. Cost Optimization
15. Integration Patterns

Exam Overview¶

Essential Information¶

• Exam Code: DP-420
• Duration: 180 minutes
• Questions: 40-60 questions
• Passing Score: 700/1000
• Cost: $165 USD

Official Exam Resources¶

• 📖 DP-420 Official Exam Page - Complete exam details, registration, and skills measured
• 📖 DP-420 Study Guide - Official study guide with exam objectives
• 📖 DP-420 Learning Path - Microsoft's official training course materials

Exam Domain Breakdown¶

1. Design and Implement Data Models (35-40%) - Data modeling, API selection, document design
2. Design and Implement Data Distribution (5-10%) - Partitioning, global distribution
3. Integrate Azure Cosmos DB Solutions (5-10%) - Change feed, Azure services integration
4. Optimize Azure Cosmos DB Solutions (15-20%) - Performance, cost optimization
5. Maintain Azure Cosmos DB Solutions (25-30%) - Monitoring, security, backup/recovery

Azure Cosmos DB Core Concepts¶

Platform Overview¶

• 📖 Azure Cosmos DB Overview - Introduction to Cosmos DB fundamentals and capabilities
• 📖 Choose an API in Azure Cosmos DB - Guidance on selecting the right API for your workload
• 📖 Multi-Model Database Capabilities - Understanding Cosmos DB's multi-model approach
• 📖 Resource Model - Account, database, container, and item hierarchy

NoSQL API (Core SQL API)¶

• 📖 NoSQL API Overview - Introduction to the native Cosmos DB NoSQL API
• 📖 Getting Started with NoSQL API - Quick start guide for .NET developers
• 📖 NoSQL API Best Practices - Performance and design best practices
• 📖 JSON Document Support - Working with JSON documents in Cosmos DB

Alternative APIs¶

• 📖 MongoDB API - MongoDB compatibility for easy migration
• 📖 Cassandra API - Apache Cassandra compatibility with CQL support
• 📖 Gremlin API - Graph database capabilities with Gremlin query language
• 📖 Table API - Key-value store compatible with Azure Table Storage

Data Modeling for NoSQL¶

Design Principles¶

• 📖 Data Modeling in Azure Cosmos DB - Fundamental principles of NoSQL data modeling
• 📖 Modeling and Partitioning Best Practices - Real-world example of effective data modeling
• 📖 Embed vs Reference Data - When to embed or reference related data
• 📖 Modeling Relationships - Handling one-to-many and many-to-many relationships

Document Design Patterns¶

• 📖 Document Structure Design - Designing effective document structures
• 📖 Denormalization Strategies - When and how to denormalize for performance
• 📖 Handling Large Documents - Working with the 2MB document size limit
• 📖 Modeling Hierarchical Data - Techniques for nested and hierarchical data

Migration and Modeling Tools¶

• 📖 Data Migration Guide - Migrating data to Cosmos DB
• 📖 Azure Data Factory for Cosmos DB - ETL and data migration with ADF

Partitioning Strategies¶

Partition Key Fundamentals¶

• 📖 Partitioning Overview - Complete guide to logical and physical partitioning
• 📖 Choosing a Partition Key - Critical decision factors for partition key selection
• 📖 Partition Key Best Practices - Real-world guidance for effective partition keys
• 📖 Synthetic Partition Keys - Creating composite keys for better distribution

Advanced Partitioning¶

• 📖 Hierarchical Partition Keys - Multi-level partitioning for improved distribution
• 📖 Hot Partition Detection and Mitigation - Identifying and fixing hot partition issues
• 📖 Partition Key Strategies by Workload - Patterns for different application types
• 📖 Cross-Partition Queries - Understanding and optimizing cross-partition operations

Consistency Levels¶

Consistency Model Overview¶

• 📖 Consistency Levels in Azure Cosmos DB - Comprehensive guide to all five consistency levels
• 📖 Consistency Level Trade-offs - Understanding latency vs. consistency trade-offs
• 📖 Choosing the Right Consistency Level - Decision guide for application requirements
• 📖 Consistency Level Guarantees - Formal guarantees for each consistency level

Consistency Configuration¶

• 📖 Configure Default Consistency - Setting account-level consistency defaults
• 📖 Override Consistency Per Request - Request-level consistency configuration in SDKs
• 📖 Session Consistency Deep Dive - Understanding session tokens and read-your-writes
• 📖 Strong Consistency and Multi-Region - Limitations and considerations

SQL API and Queries¶

Query Language Fundamentals¶

• 📖 SQL Query Getting Started - Introduction to Cosmos DB SQL query syntax
• 📖 SQL Query Reference - Complete SQL query language reference
• 📖 Query Execution - Executing queries using SDKs and Azure Portal

Advanced Query Features¶

• 📖 JOIN Operations - Intra-document joins within Cosmos DB
• 📖 Subqueries - Using subqueries for complex filtering
• 📖 Aggregate Functions - COUNT, SUM, AVG, MIN, MAX operations
• 📖 Array and Object Functions - Working with nested arrays and objects
• 📖 String Functions - String manipulation in queries
• 📖 Mathematical Functions - Numeric calculations and operations

Query Optimization¶

• 📖 Query Performance Tuning - Best practices for efficient queries
• 📖 Understanding Query Metrics - Analyzing RU consumption and execution time
• 📖 Parameterized Queries - Using parameters for better performance and security
• 📖 Pagination with Continuation Tokens - Efficiently handling large result sets

Indexing Policies¶

Indexing Fundamentals¶

• 📖 Indexing Overview - How Cosmos DB automatic indexing works
• 📖 Indexing Policies - Configuring and customizing indexing behavior
• 📖 Index Types - Range, spatial, and composite indexes

Advanced Indexing¶

• 📖 Composite Indexes - Optimizing multi-property queries with composite indexes
• 📖 Spatial Indexes - Geospatial queries and location-based indexing
• 📖 Include and Exclude Paths - Fine-tuning indexed properties for cost optimization
• 📖 Indexing Mode Configuration - Consistent vs. none indexing modes
• 📖 Vector Search and Indexing - AI and vector embedding search capabilities

Change Feed¶

Change Feed Fundamentals¶

• 📖 Change Feed Overview - Introduction to real-time change notifications
• 📖 Change Feed Design Patterns - Common architectural patterns using change feed
• 📖 Change Feed Processing - Understanding the change feed processor library

Implementation and Integration¶

• 📖 Change Feed in .NET SDK - Pull and push models for processing changes
• 📖 Azure Functions Trigger for Cosmos DB - Serverless change feed processing
• 📖 Change Feed Estimator - Monitoring change feed lag and health
• 📖 Change Feed All Versions Mode - Capturing all versions and deletes

SDKs and Development¶

.NET SDK¶

• 📖 Azure Cosmos DB .NET SDK v3 - Primary SDK for .NET applications
• 📖 .NET SDK Best Practices - Performance optimization for .NET developers
• 📖 Bulk Operations in .NET - High-throughput batch operations
• 📖 Transactional Batch in .NET - ACID transactions within a partition

Java SDK¶

• 📖 Azure Cosmos DB Java SDK v4 - Modern async SDK for Java developers
• 📖 Java SDK Best Practices - Performance and connection management
• 📖 Java SDK Performance Tips - Optimizing Java applications

Python SDK¶

• 📖 Azure Cosmos DB Python SDK - Python client library for Cosmos DB
• 📖 Python SDK Samples - Code examples for common Python scenarios

JavaScript/Node.js SDK¶

• 📖 Azure Cosmos DB JavaScript SDK - Node.js and browser-based applications
• 📖 JavaScript SDK Samples - Code examples for Node.js developers

SDK Common Patterns¶

• 📖 Connection Management - Singleton client pattern and connection pooling
• 📖 Retry Policies - Building resilient applications with automatic retries
• 📖 Direct vs Gateway Mode - Connectivity modes and performance implications

Performance Optimization¶

Request Units (RU) Management¶

• 📖 Request Units Explained - Understanding RU consumption and calculation
• 📖 Estimating RU Requirements - Capacity planning and RU estimation
• 📖 Provisioned Throughput - Configuring RU/s at database and container level
• 📖 Autoscale Throughput - Automatic scaling based on workload

Throughput Optimization¶

• 📖 Serverless Mode - Pay-per-request pricing for variable workloads
• 📖 Shared Throughput - Sharing RU/s across multiple containers
• 📖 Optimizing RU Consumption - Techniques to reduce request unit usage

Performance Best Practices¶

• 📖 Performance Tips for NoSQL API - General performance optimization strategies
• 📖 Query Performance Optimization - Reducing RU costs in queries
• 📖 Bulk Import Performance - High-performance data ingestion
• 📖 SDK Performance Benchmarks - Understanding SDK performance characteristics

Analytical Store and HTAP¶

• 📖 Azure Synapse Link for Cosmos DB - Hybrid transactional and analytical processing
• 📖 Analytical Store Overview - Column-oriented store for analytics without ETL
• 📖 Query Analytical Store with Spark - Big data analytics on operational data

Global Distribution¶

Multi-Region Configuration¶

• 📖 Global Distribution Overview - Turnkey global distribution capabilities
• 📖 Add and Remove Regions - Configuring multi-region deployments
• 📖 Multi-Region Writes - Enabling write capabilities in all regions
• 📖 Automatic Failover - Configuring failover priorities and policies

Conflict Resolution¶

• 📖 Conflict Resolution Overview - Managing conflicts in multi-region write scenarios
• 📖 Last-Write-Wins Policy - Default timestamp-based conflict resolution
• 📖 Custom Conflict Resolution - User-defined merge procedures

Availability and SLAs¶

• 📖 High Availability in Cosmos DB - Understanding 99.999% availability SLA
• 📖 SLA for Azure Cosmos DB - Comprehensive service level agreements
• 📖 Availability Zones - Zone-redundant deployments

Security and Access Control¶

Authentication and Authorization¶

• 📖 Security Overview - Comprehensive security features and capabilities
• 📖 Azure AD Authentication - Role-based access control with Azure Active Directory
• 📖 Primary and Secondary Keys - Master key authentication and management
• 📖 Resource Tokens - Fine-grained access control for specific resources

Network Security¶

• 📖 Firewall Configuration - IP firewall rules and access restrictions
• 📖 Virtual Network Service Endpoints - Private connectivity from VNets
• 📖 Private Endpoints - Azure Private Link integration
• 📖 Public Network Access Control - Disabling public internet access

Data Encryption¶

• 📖 Encryption at Rest - Transparent data encryption for stored data
• 📖 Customer-Managed Keys - Bring your own key (BYOK) with Azure Key Vault
• 📖 Encryption in Transit - TLS 1.2+ for all connections

Monitoring and Diagnostics¶

Azure Monitor Integration¶

• 📖 Monitoring Cosmos DB - Complete monitoring and observability guide
• 📖 Metrics in Azure Monitor - Available metrics and dimensions
• 📖 Diagnostic Logs - Configuring diagnostic logging to Log Analytics
• 📖 Setting Up Alerts - Proactive monitoring with Azure Monitor alerts

Performance Monitoring¶

• 📖 Query Metrics and Diagnostics - Understanding query execution statistics
• 📖 Server-Side Latency Metrics - Diagnosing latency issues
• 📖 RU Consumption Monitoring - Tracking normalized RU consumption
• 📖 Partition Metrics - Storage and throughput distribution analysis

Troubleshooting¶

• 📖 Troubleshooting Guide - Common issues and resolutions for .NET SDK
• 📖 Rate Limiting (429) Errors - Understanding and fixing throughput exceeded errors
• 📖 Connection Issues - Diagnosing connectivity problems
• 📖 Performance Diagnostics - Using built-in diagnostics tools

Cost Optimization¶

Cost Management¶

• 📖 Understanding Cosmos DB Pricing - Billing components and cost calculation
• 📖 Optimize Throughput Costs - Strategies to reduce RU/s expenses
• 📖 Optimize Storage Costs - Managing data retention and storage usage
• 📖 Choosing Between Provisioned and Serverless - Cost comparison for different workload types

Cost Optimization Strategies¶

• 📖 Time to Live (TTL) - Automatic data expiration to reduce storage costs
• 📖 Reserved Capacity - Pre-purchasing capacity for cost savings
• 📖 Free Tier - 1000 RU/s and 25 GB storage free
• 📖 Cost Analysis and Budgets - Planning and managing Cosmos DB costs

Integration Patterns¶

Azure Services Integration¶

• 📖 Azure Functions Integration - Serverless triggers, input and output bindings
• 📖 Logic Apps Connector - Workflow automation with Cosmos DB
• 📖 Azure Stream Analytics - Real-time streaming data to Cosmos DB
• 📖 Event Grid Integration - Event-driven architectures with change feed

Data Integration¶

• 📖 Azure Data Factory - ETL pipelines and data movement
• 📖 Azure Databricks Integration - Apache Spark connector for Cosmos DB
• 📖 Power BI Integration - Real-time dashboards and reporting

Migration Tools¶

• 📖 Data Migration Tool - Command-line tool for bulk data import
• 📖 Azure Cosmos DB Live Migrator - Zero-downtime migration strategies
• 📖 Spark Connector for Migration - Large-scale data migration using Databricks

Additional Resources¶

Backup and Disaster Recovery¶

• 📖 Backup Overview - Automatic continuous backup
• 📖 Point-in-Time Restore - Restoring data to any point in time
• 📖 Periodic Backup Mode - Traditional scheduled backup approach
• 📖 Restore Cosmos DB Account - Recovery procedures and best practices

Compliance and Governance¶

• 📖 Compliance Certifications - Industry standards and regulatory compliance
• 📖 Azure Policy for Cosmos DB - Governance and compliance policies
• 📖 Audit Logging - Control plane operation logging

Development Best Practices¶

• 📖 Design Patterns - Common architectural patterns catalog
• 📖 Testing Strategies - Using the Cosmos DB emulator for local development
• 📖 Cosmos DB Emulator - Development and testing without Azure costs
• 📖 DevOps and CI/CD - Infrastructure as Code with ARM templates

Community and Learning Resources¶

• 📖 Azure Cosmos DB Blog - Latest features, announcements, and deep dives
• 📖 GitHub Samples Repository - Official code samples for all SDKs
• 📖 Azure Architecture Center - Reference architectures using Cosmos DB

Exam Preparation Checklist¶

Core Competencies to Master¶

• Design appropriate partition keys for various workload types
• Choose the right consistency level based on requirements
• Optimize queries to minimize RU consumption
• Configure indexing policies for cost and performance
• Implement change feed processors for event-driven architectures
• Use SDK best practices for connection management and bulk operations
• Configure global distribution and multi-region writes
• Implement proper authentication and authorization
• Set up monitoring, alerts, and diagnostics
• Optimize costs using autoscale, serverless, and TTL

Hands-On Practice Areas¶

1. Create Cosmos DB accounts with different APIs
2. Design and implement effective data models
3. Write complex SQL queries with joins and aggregations
4. Configure custom indexing policies
5. Implement change feed processors with Azure Functions
6. Perform bulk import operations
7. Configure multi-region deployments
8. Troubleshoot 429 rate limiting errors
9. Analyze query metrics and optimize performance
10. Implement security controls (RBAC, firewall, private endpoints)

Key Documentation to Review¶

• Partitioning and partition key selection
• Consistency levels and their trade-offs
• Request Units calculation and optimization
• Change feed patterns and implementations
• SDK best practices for your primary language
• Query performance tuning techniques
• Security and access control mechanisms
• Monitoring metrics and diagnostic logs

Quick Reference Tables¶

Consistency Levels Comparison¶

Request Unit Guidelines¶

API Selection Guide¶

Summary¶

This fact sheet provides a comprehensive reference for the Azure DP-420 certification exam with 100 embedded documentation links covering all major exam domains:

1. Design and Implement Data Models - NoSQL modeling, APIs, document design
2. Data Distribution - Partitioning strategies, global distribution
3. Integration - Change feed, Azure services, migration
4. Optimization - Performance tuning, RU management, analytical store
5. Maintenance - Monitoring, security, backup/recovery

Study Approach¶

1. Work through each documentation link systematically
2. Create hands-on labs for each major topic
3. Build sample applications using the SDKs
4. Practice query optimization and troubleshooting
5. Understand cost implications of design decisions

Success Tips¶

• Focus on hands-on experience with Cosmos DB
• Understand partition key selection deeply - it appears in many scenarios
• Know when to use each consistency level
• Practice optimizing RU consumption
• Be comfortable with change feed implementation patterns
• Understand the trade-offs between different approaches

Good luck with your DP-420 certification exam!

Last Updated: 2025-10-13 Total Documentation Links: 100 Exam Version: Current as of October 2025