Microsoft Azure Cosmos DB Developer Specialty (DP-420) Cert Prep by Microsoft Press

8h 27mAdvanced2025-04-17

Authors

Microsoft Press

Microsoft

Tim Warner

Technical Trainer and Content Developer

Course details

Cosmos DB is Microsoft Azure's flagship nonrelational database product. It supports multiple application programming interfaces (APIs) that provide compatibility with competing NoSQL databases. Cosmos DB also features five different transaction consistency levels, as well as multimaster global replication. In this course, designed by Microsoft Press, instructor Tim Warner covers the essentials of integrating an enterprise-scale, cloud-based, NoSQL database into your solutions using the powerful features of Cosmos DB. Along the way, develop the core skills required to tackle the Microsoft Azure Cosmos DB Developer Specialty (DP-420) certification exam.

Skills covered

Database DevelopmentDatabase ManagementCert PrepSoftware Development

Concepts

0. Introduction

01 - Exam DP-420 Designing and implementing cloud-native applications using Microsoft Azure Cosmos DB - Introduction

Lesson 1 - Design and Implement a Non-Relational Data Model for Azure Cosmos DB Core API

02 - Learning objectives
03 - Develop a design by storing multiple entity types in the same container
04 - Develop a design by storing multiple related entities in the same document
05 - Develop a design by referencing between documents
06 - Identify primary and unique keys
07 - Identify data and associated access patterns
08 - Specify a default TTL on a container for a transactional store

Lesson 2 - Design a Data-Partitioning Strategy for Azure Cosmos DB Core API

09 - Learning objectives
10 - Choose a partition strategy based on a specific workload
11 - Plan for transactions when choosing a partition key
12 - Calculate and evaluate throughput distribution based on partition key selection
13 - Design partitioning for workloads that require multiple partition keys

Lesson 3 - Plan and Implement Sizing and Scaling for a Database Created with Azure Cosmos DB

14 - Learning objectives
15 - Choose between serverless and provisioned models
16 - Choose when to use database-level provisioned throughput
17 - Design for granular scale units and resource governance
18 - Evaluate the cost of the global distribution of data
19 - Configure throughput for Azure Cosmos DB by using Azure Portal

Lesson 4 - Implement Client Connectivity Options in the Azure Cosmos DB SDK

20 - Learning objectives
21 - Implement a connectivity mode
22 - Create a connection to a database
23 - Enable offline development by using the Azure Cosmos DB emulator
24 - Handle connection errors
25 - Configure client-side threading and parallelism options
26 - Enable SDK logging

Lesson 5 - Implement Data Access by Using the Azure Cosmos DB SQL Language

27 - Learning objectives
28 - Implement queries that use arrays, nested objects, aggregation, and ordering
29 - Implement a correlated subquery
30 - Implement queries that use array and type-checking functions
31 - Implement queries that use mathematical, string, and date functions
32 - Implement queries based on variable data

Lesson 6 - Implement Data Access by Using SQL API SDKs

33 - Learning objectives
34 - Choose when to use a point operation versus a query operation
35 - Implement a point operation that creates, updates, and deletes documents
36 - Implement an update by using a patch operation
37 - Manage multi-document transactions using SDK transactional batch
38 - Perform a multi-document load using SDK bulk
39 - Implement optimistic concurrency control using ETags
40 - Implement session consistency by using session tokens
41 - Implement a query operation that includes pagination
42 - Implement a query operation by using a continuation token
43 - Handle transient errors and 429s
44 - Specify TTL for a document
45 - Retrieve and use query metrics

Lesson 7 - Implement Server-Side Programming in Azure Cosmos DB Core API by Using JavaScript

46 - Learning objectives
47 - Design stored procedures to work with multiple items transactionally
48 - Implement triggers
49 - Implement a user-defined function

Lesson 8 - Design and Implement a Replication Strategy for Azure Cosmos DB

50 - Learning objectives
51 - Choose when to distribute data
52 - Define automatic failover policies for regional failure for Azure Cosmos DB Core API
53 - Perform manual failovers to move single master write regions
54 - Specify application connections to replicated data

Lesson 9 - Design and Implement Multi-Region Writes

55 - Learning objectives
56 - Choose when to use multi-region writes
57 - Implement multi-region write
58 - Implement a custom conflict resolution policy for Azure Cosmos DB Core API

Lesson 10 - Enable Azure Cosmos DB Analytical Workloads

59 - Learning objective
60 - Enable Azure Synapse Link
61 - Choose between Azure Synapse Link and Spark Connector
62 - Enable the analytical store on a container
63 - Write data back to the transactional store from Spark

Lesson 11 - Implement Solutions Across Services

64 - Learning objective
65 - Integrate events with other applications by using Azure Functions and Azure Event Hubs
66 - Denormalize data by using change feed and Azure Functions
67 - Archive data by using change feed and Azure Functions
68 - Implement Azure Cognitive Search for an Azure Cosmos DB solution

Lesson 12 - Optimize Query Performance in Azure Cosmos DB Core API

69 - Learning objective
70 - Adjust indexes on the database
71 - Calculate the cost of the query
72 - Retrieve request unit cost of a point operation or query
73 - Implement Azure Cosmos DB integrated cache

Lesson 13 - Design and Implement Change Feeds for an Azure Cosmos DB Core API

74 - Learning objective
75 - Implement data archiving by using a change feed

Lesson 14 - Define and Implement an Indexing Strategy for an Azure Cosmos DB Core API

76 - Learning objective
77 - Choose when to use a read-heavy versus write-heavy index strategy
78 - Choose an appropriate index type
79 - Configure a custom indexing policy by using the Azure portal
80 - Implement a composite index

Lesson 15 - Monitor and Troubleshoot an Azure Cosmos DB Solution

81 - Learning objective
82 - Evaluate response status code and failure metrics
83 - Monitor data replication in relation to latency and availability
84 - Configure Azure Monitor alerts for Azure Cosmos DB
85 - Implement and query Azure Cosmos DB logs
86 - Monitor distribution of data across partitions
87 - Monitor security by using logging and auditing

Lesson 16 - Implement Backup and Restore for an Azure Cosmos DB Solution

88 - Learning objective
89 - Choose between periodic and continuous backup
90 - Configure periodic backup
91 - Configure continuous backup and recovery
92 - Recover a database or container from a recovery point

Lesson 17 - Implement Security for an Azure Cosmos DB Solution

93 - Learning objective
94 - Choose between service-managed and customer-managed encryption keys
95 - Configure network-level access control for Azure Cosmos DB
96 - Configure data encryption for Azure Cosmos DB
97 - Manage control plane access to Azure Cosmos DB by using Azure role-based access control (RBAC)
98 - Manage data plane access to Azure Cosmos DB by using Azure Active Directory
99 - Configure Cross-Origin Resource Sharing (CORS) settings
100 - Manage account keys by using Azure Key Vault
101 - Implement customer-managed keys for encryption
102 - Implement Always Encrypted

Lesson 18 - Implement Data Movement for an Azure Cosmos DB Solution

103 - Learning objective
104 - Choose a data movement strategy
105 - Move data by using client SDK bulk operations
106 - Move data by using Azure Data Factory and Azure Synapse pipelines
107 - Move data by using a Kafka connector
108 - Move data by using Azure Stream Analytics
109 - Move data by using the Azure Cosmos DB Spark connector

Lesson 19 - Implement a DevOps Process for an Azure Cosmos DB Solution

110 - Learning objective
111 - Choose when to use declarative versus imperative operations
112 - Provision and manage Azure Cosmos DB resources by using Azure Resource Manager templates (ARM templates)
113 - Migrate between standard and autoscale throughput by using PowerShell or Azure CLI
114 - Initiate a regional failover by using PowerShell or Azure CLI
115 - Maintain index policies in production by using ARM templates

Conclusion

116 - Summary