Microsoft · DP-420
Write efficient queries, create indexing policies, manage, and provision resources in the SQL API and SDK with Microsoft Azure Cosmos DB.
Practice Questions
677
≈ 13 practice exams
Duration
120 minutes
Passing Score
700/1000
Difficulty
SpecialtyLast Updated
Sep 2026
The DP-420 exam is weighted toward five skill areas, and the 677-question CertCompanion bank is built to match that split. Design and implement data models is the largest area at 35 to 40 percent, covering non-relational modeling, partition key selection, hierarchical and synthetic keys, SQL queries, SDK CRUD and patch operations, and server-side JavaScript. Maintain an Azure Cosmos DB solution follows at 25 to 30 percent (monitoring, backup and restore, and security), then Optimize an Azure Cosmos DB solution at 15 to 20 percent (query tuning, RU cost, indexing, and change feed). Design and implement data distribution and Integrate an Azure Cosmos DB solution round out the exam at 5 to 10 percent each. Note that Microsoft renames and restructures this exam on October 6, 2026, so confirm which version you are booking (details below).
Expect 40 to 60 questions in a 120-minute proctored session delivered through Pearson VUE, online or at a test center. Question formats include multiple choice, drag-and-drop, build-list, case studies, and interactive lab components, and Microsoft does not publish the exact count in advance. Scoring runs on a scale of 100 to 1000, and you need 700 or higher to pass. Most questions target general availability features, though commonly used preview features can appear. If you take a localized version of the exam, you can request an extra 30 minutes.
Microsoft sets no formal prerequisites, but candidates are expected to have hands-on experience developing Azure applications with the Azure Cosmos DB for NoSQL API, including writing SQL queries, tuning indexing policies, and using the C#, Java, or Python SDK. The exam costs about 165 USD, varying by country or region, and the certification expires after one year. Renewal is free through an online assessment on Microsoft Learn, so there is no re-exam fee to stay current. From October 6, 2026, the credential becomes Microsoft Certified: Azure Cosmos DB AI Developer Associate, adding vector search, RAG, and agent memory topics. Start with the 30 free questions, then work through the full 677-question bank until your accuracy holds steady across all five domains.
The Microsoft Certified: Azure Cosmos DB Developer Specialty (DP-420) validates subject matter expertise in designing, implementing, and monitoring cloud-native applications that store and manage data using Azure Cosmos DB. The certification covers the full development lifecycle: modeling non-relational data, selecting partition keys, managing throughput and scaling, implementing the SQL API and .NET/Java SDKs, writing server-side JavaScript (stored procedures, triggers, user-defined functions), and integrating Cosmos DB with other Azure services such as Azure Functions, Azure Synapse Link, and Event Hubs.
The exam was last updated on January 27, 2025, and reflects current platform capabilities including hierarchical partition keys, the integrated cache, Always Encrypted, and Azure Synapse Link with Change Data Capture. Candidates are assessed on their ability to optimize query performance through indexing strategies and cost analysis, implement change feeds, configure backup and restore, enforce security controls using Microsoft Entra ID and Azure RBAC, and automate operations using Azure Resource Manager templates and PowerShell/CLI.
This certification is intended for developers and data engineers with hands-on experience building Azure applications that rely on Azure Cosmos DB for NoSQL as their primary data store. Suitable job titles include Azure Developer, Cloud Application Developer, and Data Engineer. Candidates typically have two or more years of experience working with Azure services and are comfortable reading C# or Java application code, writing SQL queries for the Cosmos DB NoSQL API, and interpreting JSON documents.
Professionals pursuing this certification often work in roles where they are responsible for both the data modeling decisions and the operational health of a Cosmos DB solution—including security, availability, resilience, and performance. It is particularly relevant for those building globally distributed, high-throughput applications such as IoT platforms, e-commerce systems, and real-time analytics pipelines.
Microsoft does not enforce formal prerequisites for DP-420, but candidates are expected to have practical experience developing applications for Azure and working with Azure Cosmos DB database technologies. Specifically, candidates should be proficient with the Azure Cosmos DB for NoSQL API, able to write efficient SQL queries against it, create and tune indexing policies, and use the Azure Cosmos DB SDK (C# or Java). Familiarity with JSON structure and the ability to write server-side JavaScript for stored procedures and triggers is also required.
A solid understanding of Azure fundamentals—including resource provisioning, Azure role-based access control (RBAC), Azure Monitor, and ARM templates—is strongly recommended. Candidates who have completed the AZ-900 (Azure Fundamentals) or AZ-204 (Azure Developer Associate) certification will find much of this background knowledge directly applicable. Microsoft's free learning path DP-420T00 (Design and Implement Cloud-Native Applications with Azure Cosmos DB) is the official preparatory course.
Exam DP-420 is a proctored assessment delivered through Pearson VUE, available both online (remote proctored) and at Pearson VUE test centers. Candidates are given 100 minutes to complete the exam. The number of questions is not publicly disclosed and may vary, but the exam may include multiple question types such as multiple choice, drag-and-drop, build-list, case studies, and interactive lab components. A score of 700 or higher on a scale of 100–1000 is required to pass.
The exam is available in English, Japanese, Chinese (Simplified), Chinese (Traditional), Korean, German, French, Spanish, Portuguese (Brazil), and Italian. If taking the exam in a non-English localization, candidates may request an additional 30 minutes. The certification expires annually and can be renewed at no cost by passing a free online assessment on Microsoft Learn. The exam price is approximately $165 USD, varying by country or region of the testing location.
Earning the Azure Cosmos DB Developer Specialty positions professionals for roles such as Senior Azure Developer, Cloud-Native Application Architect, and Data Platform Engineer—positions that command premium salaries due to the specialized nature of globally distributed database design. According to industry surveys, Azure-certified developers with specialty credentials typically earn between $120,000 and $165,000 USD annually in North American markets, with variation by region and total experience. Demand for Cosmos DB expertise is driven by enterprises building IoT, gaming, retail, and financial services applications that require low-latency, multi-region access at scale.
Compared to the broader AZ-204 (Azure Developer Associate), DP-420 demonstrates deep, focused expertise in a specific high-value technology—making it particularly compelling on a resume for organizations heavily invested in the Azure data platform. The certification is recognized globally and renewable annually at no cost, ensuring that credential holders remain current with platform evolution. It also pairs well with certifications such as DP-203 (Azure Data Engineer Associate) for professionals who straddle application development and data engineering responsibilities.
5 sample questions with answers and explanations. The full bank has 677 questions, enough for 13 full-length practice exams.
Preview — answers shown1. Your application at TechFlow Industries needs to import the Azure Cosmos DB SDK namespace to use the CosmosClient and related classes. Which using statement should they add to their C# code files?
Explanation
The correct namespace for the Azure Cosmos DB SDK for .NET is Microsoft.Azure.Cosmos. This using statement allows you to use types like CosmosClient, Database, Container, and other SDK classes without having to fully qualify them. This is the namespace for the current version 3 SDK for Azure Cosmos DB for NoSQL.
2. Your application at SecureData Systems needs to handle large result sets efficiently. You want to configure the query to return 1000 items per page instead of the default. Which QueryRequestOptions property should you configure?
Explanation
MaxItemCount controls the number of items returned in each page of query results. The default is 100 items per page, but you can set it to 1000 to retrieve more items per page, reducing the number of round trips. You can also set it to -1 for dynamic page sizing, but you must ensure the total response doesn't exceed the 4 MB service limit for response size.
3. At DataProcessing Corp, you want to configure the Azure Cosmos DB SDK to use dynamic page sizing for query results instead of the default 100 items per page. What value should you set for MaxItemCount?
Explanation
Setting MaxItemCount to -1 enables dynamic page sizing, allowing the service to determine the optimal number of items per page based on various factors. However, you must ensure that the total response size doesn't exceed the service limit of 4 MB. The default value is 100 items per page if not specified.
4. ReadOptimize Corp has an Azure Cosmos DB for NoSQL account with read-heavy workloads. They want to implement integrated caching to improve read performance. What should they do first?
Explanation
Creating a dedicated gateway is the mandatory first step for enabling Azure Cosmos DB integrated cache. The dedicated gateway provides the infrastructure layer where the integrated cache operates, intercepting read requests and serving cached responses when possible. The integrated cache is built into the dedicated gateway service and cannot function without it. Azure Synapse Link enables analytical capabilities but doesn't provide transactional read caching. Azure Cache for Redis is a separate caching service and not the same as Cosmos DB's integrated cache feature. Multi-region reads improve availability and performance but don't provide the same request-level caching benefits as the integrated cache. The dedicated gateway is the foundational requirement for integrated caching functionality.
5. At InnovateData Corp, the development team wants to understand the main classes in the Microsoft.Azure.Cosmos namespace. Which class serves as the primary entry point and logical representation of the Azure Cosmos DB account?
Explanation
The CosmosClient class is the primary entry point and logical client-side representation of an Azure Cosmos DB account in the Microsoft.Azure.Cosmos namespace. It's the main class used to initialize the SDK connection and provides access to database and container operations. Database and Container classes are used for specific resource operations, while AccountProperties holds account metadata.
The DP-420 exam has 40 to 60 questions with a 120-minute time limit. Microsoft does not publish the exact number, and it can vary between test forms.
You need 700 on a scale of 100 to 1000 to pass. The score is scaled, not a simple percentage of questions answered correctly.
The exam costs about 165 USD, though the price varies by country or region. You schedule and pay through Pearson VUE.
Design and implement data models is 35 to 40 percent, Maintain is 25 to 30 percent, Optimize is 15 to 20 percent, and data distribution and integration are 5 to 10 percent each. These weights apply to the exam version before October 6, 2026.
No formal prerequisites are required. Microsoft expects hands-on experience with the Azure Cosmos DB for NoSQL API, SQL queries, indexing, and the C#, Java, or Python SDK.
The certification is valid for one year. You renew for free by passing an online assessment on Microsoft Learn, with no re-exam fee.
Yes. On October 6, 2026, Microsoft renames it to Azure Cosmos DB AI Developer Associate and restructures the outline into three areas that add vector search, RAG, and agent memory. Confirm which version you are booking.
Expect multiple choice, drag-and-drop, build-list, case studies, and interactive lab components. Most questions cover general availability features, with some commonly used preview features.
Microsoft Certified: Azure AI Engineer Associate (AI-102)
AI-102 · 1392 questions
Microsoft Certified: Azure AI Fundamentals (AI-900)
AI-900 · 464 questions
Microsoft Azure AI Fundamentals (AI-901)
AI-901 · 600 questions
Microsoft Certified: Azure Data Fundamentals (DP-900)
DP-900 · 381 questions
Microsoft Certified: Azure Data Scientist Associate (DP-100)
DP-100 · 987 questions
Microsoft Certified: Azure Database Administrator Associate (DP-300)
DP-300 · 389 questions
$17.99
One-time access to this exam