DP-900 vs AZ-900: Which Microsoft Certification Should You Take First?

Choosing between the dp 900 or az 900 certification is one of the most common dilemmas facing IT professionals who are just beginning their Microsoft Azure journey. Both exams sit at the fundamentals tier — meaning neither requires prior cloud experience — but they cover very different domains. AZ-900 (Microsoft Azure Fundamentals) focuses on core cloud concepts, Azure services, security, compliance, and pricing models. DP-900 (Microsoft Azure Data Fundamentals) zeroes in on relational and non-relational data, analytics workloads, and Azure data services. Understanding those differences upfront will save you weeks of mis-directed study time.

The az-900 certification is often the recommended starting point because cloud fundamentals underpin virtually every other Azure credential. Before you can appreciate how Azure Synapse Analytics stores and processes data, it helps to understand how Azure subscriptions, resource groups, and virtual networks work. Taking AZ-900 first gives you that mental scaffolding. Many learners who skip AZ-900 and jump straight to DP-900 find themselves backtracking to fill conceptual gaps they encounter in the data exam's cloud-context questions.

That said, there are legitimate reasons to pursue DP-900 first — or even exclusively. If you are a database administrator, data engineer, or business intelligence professional who already works with SQL, NoSQL, or ETL pipelines on-premises, the DP-900 content may feel more immediately relevant. Microsoft designed DP-900 so that no prior cloud knowledge is assumed, and the exam does briefly cover foundational Azure concepts on its own terms. Professionals in those roles sometimes find they can clear DP-900 with two to three weeks of focused study, then layer AZ-900 on top afterward.

In terms of raw numbers, the az-900 exam typically contains 40–60 questions and must be completed in 45 minutes, while DP-900 follows a similar format with 40–60 questions in 60 minutes. Both are multiple-choice and scenario-based, and both use Microsoft's standard 700-out-of-1000 passing score. Exam fees are identical: $165 USD per attempt in the United States, though Microsoft periodically offers discounts through Microsoft Learn challenges and partner promotions. Knowing the format removes the fear of the unknown and lets you focus entirely on the subject matter.

Career trajectory is another deciding factor. The az-900 opens doors toward the associate-level AZ-104 (Azure Administrator) and AZ-204 (Azure Developer) tracks, as well as the AI-focused AI-900.

DP-900, on the other hand, naturally leads to DP-203 (Azure Data Engineer Associate) and DP-300 (Azure Database Administrator Associate). If your end goal is a role in data engineering, data science, or analytics, beginning with DP-900 is a perfectly valid strategy — just be prepared to circle back to cloud basics when you encounter unfamiliar Azure networking or security references during the DP-900 exam. You can explore a detailed timing comparison in our dp 900 vs az 900 preparation guide.

Salary data reinforces the value of both paths. According to Burning Glass Technologies and LinkedIn Salary data compiled through 2025, professionals who hold at least one Azure fundamentals badge earn a median salary roughly $8,000–$12,000 higher than uncertified peers in the same role. Stacking both AZ-900 and DP-900 — which takes most candidates a total of six to ten weeks of part-time study — signals breadth to hiring managers and is increasingly common among cloud-adjacent roles in finance, healthcare, and government contracting.

This guide breaks down everything you need to decide: exam structure, difficulty, recommended study order, cost, and the fastest way to build the hands-on confidence that separates candidates who pass on the first attempt from those who do not. Whether you are deciding between az-900 or dp-900, or planning to pursue both, the sections below give you a clear, data-backed roadmap.

Deciding which exam to sit first comes down to three factors: your current role, your ultimate certification goal, and your existing familiarity with cloud technology. For the majority of candidates — particularly those coming from non-technical business roles, help-desk environments, or entry-level IT positions — the az-900 certification is the right first step.

Azure Fundamentals teaches you the vocabulary and mental models that every other Microsoft cloud certification builds upon. When you later encounter terms like "Azure Resource Manager," "managed identity," or "geo-redundant storage" inside a DP-900 question, you will already understand them at a conceptual level rather than encountering them as unfamiliar jargon.

For candidates with a data background, the calculus shifts. A SQL Server DBA who has spent five years designing database schemas and optimizing queries for on-premises workloads already understands relational data, normalization, indexing, and stored procedures. The DP-900 exam's relational data section — which covers Azure SQL Database, Azure SQL Managed Instance, and Azure Database for PostgreSQL — maps very naturally onto that existing knowledge. Such a candidate might find DP-900 more intellectually engaging as a first exam and can always clear AZ-900 in a few additional study sessions afterward.

Microsoft's own guidance is somewhat neutral on sequencing: neither exam is formally listed as a prerequisite for the other, and both are described as entry-level. However, the Microsoft Learn learning paths for DP-900 do reference cloud fundamentals concepts that are taught explicitly in the AZ-900 curriculum.

If you scan the DP-900 official study guide, you will notice that Module 1 includes a brief overview of cloud service types (IaaS, PaaS, SaaS) — content that AZ-900 covers in far greater depth. Treating AZ-900 as prep material for DP-900 rather than a standalone exam is a popular strategy among candidates planning to pursue both badges.

The az-900 exam difficulty is generally rated as moderate for complete beginners and easy for those with some IT background. According to community survey data aggregated from Reddit's r/AzureCertification and TechExams.net (sample size: ~2,400 self-reported responses through 2025), approximately 72% of first-time AZ-900 candidates pass on their initial attempt, compared with roughly 68% for DP-900 first-timers. The slightly lower DP-900 first-time pass rate reflects the exam's heavier reliance on service-specific knowledge — candidates who underestimate the depth of the analytics and non-relational sections are the ones most likely to fall short.

Study time estimates also differ. Most candidates report needing 15–25 hours of total study time to pass AZ-900, spread over two to four weeks of part-time effort. DP-900 typically requires 20–30 hours, partly because the service landscape — Cosmos DB, Azure Synapse Analytics, Azure Data Factory, Power BI — is less familiar to most beginners than the general Azure services covered in AZ-900.

The additional time investment is not because DP-900 is conceptually harder, but because it requires learning a wider variety of purpose-built services, each with its own configuration quirks and use-case nuances. Using az-900 practice test banks alongside DP-900 practice questions lets you see the knowledge overlap and fill gaps efficiently.

Cost is a practical consideration as well. At $165 per attempt, failing either exam and retaking it adds up quickly. Microsoft offers a free retake through the Microsoft Certification Challenge promotion when it runs, but that promotion is not always active. The best insurance against a retake is disciplined use of practice exams in the final week before your scheduled test date.

Candidates who complete at least three full-length timed practice exams — scoring 80% or above before sitting the real test — report significantly higher pass rates than those who rely solely on reading study guides or watching video courses. Practice under realistic timed conditions is not optional; it is the single highest-leverage study activity available.

If budget allows and your schedule permits, the most efficient path for most candidates is to take AZ-900 first, pass it within four weeks, and then immediately pivot to DP-900 study, carrying forward the cloud foundation knowledge. This sequencing means your total elapsed time from zero to holding both badges is typically eight to twelve weeks, and the total cost — assuming one attempt each — is $330. That investment positions you for associate-level exams worth significantly more in salary negotiation and job opportunity than either fundamentals badge on its own.

The az-900 certification covers three broad domains, and the relative weighting of each domain has been updated by Microsoft over the years. The current version of the exam (as of 2025–2026) weights Azure Architecture and Services most heavily at 35–40%, followed by Azure Management and Governance at 30–35%, and Cloud Concepts at 25%. This weighting tells you something important: you cannot pass AZ-900 by memorizing high-level cloud theory and ignoring specific Azure services. The majority of points come from knowing what Azure services exist, what they do, and when to use them.

The Azure Architecture and Services domain is where most candidates spend the bulk of their study time, and rightfully so. You need to know the compute options — Azure Virtual Machines, Azure App Service, Azure Functions, Azure Container Instances, and Azure Kubernetes Service — at a conceptual level. You do not need to write ARM templates or configure Kubernetes clusters, but you do need to understand the key differentiators.

For example: Azure Functions is serverless and event-driven, with execution billed per invocation; Azure App Service is PaaS with dedicated compute billed by plan tier; Azure Virtual Machines is IaaS with full OS control but maximum management overhead. Questions that present a scenario and ask which compute option is most appropriate for a given business requirement are extremely common.

Storage is another heavily tested area. The four primary Azure Storage services — Blob, Files, Queue, and Table — each serve a distinct use case. Blob storage holds unstructured data like images, backups, and log files. Azure Files provides SMB and NFS-compatible file shares accessible from both cloud and on-premises. Queue storage provides message-passing between application components.

Table storage is a NoSQL key-value store designed for rapid lookups of structured data at scale. Candidates who confuse these services or cannot match them to scenarios lose several points on questions that should be easy wins. Creating a simple two-column table — service on the left, primary use case and key differentiator on the right — is one of the most effective study tools for this area.

Networking concepts in AZ-900 are tested at a conceptual rather than implementation level. You should know what an Azure Virtual Network (VNet) is, how subnets divide a VNet, and why network security groups (NSGs) control inbound and outbound traffic at the subnet or NIC level.

You should understand Azure VPN Gateway for site-to-site connectivity, Azure ExpressRoute for dedicated private connections, and Azure Content Delivery Network (CDN) for globally distributing static content with low latency. Azure DNS and Azure Load Balancer also appear regularly. The key insight is that AZ-900 networking questions test whether you understand the purpose of each service, not whether you can configure it.

Identity and security topics in AZ-900 have grown in importance with each exam update. Microsoft Entra ID (formerly Azure Active Directory) is tested extensively: you need to know what it does (identity and access management for cloud resources), how Multi-Factor Authentication (MFA) reduces unauthorized access risk, and what Conditional Access policies do (grant or block access based on conditions like location or device compliance). Zero Trust security principles — verify explicitly, use least-privilege access, assume breach — appear in questions about Azure security architecture.

Microsoft Defender for Cloud and Microsoft Sentinel (SIEM/SOAR) are also mentioned, though at a high conceptual level rather than technical depth.

The Management and Governance domain has become more complex in recent exam versions. Azure Cost Management tools — cost analysis, budgets, and alerts — are testable alongside Azure Advisor (which provides recommendations for reliability, security, performance, operational excellence, and cost). The Azure Service Level Agreement (SLA) framework is frequently tested: you need to know that composite SLAs combine individual service SLAs multiplicatively, meaning adding redundancy increases availability but multiple dependent services can reduce the effective SLA if not architected correctly.

Azure Policy, Azure Blueprints, and management group hierarchy (management groups → subscriptions → resource groups → resources) are all fair game.

Finally, the Cloud Concepts domain — while weighted lightest — contains foundational questions that candidates sometimes lose points on by overthinking them. Know the three cloud deployment models (public, private, hybrid), the three cloud service models (IaaS, PaaS, SaaS), the benefits of cloud (high availability, scalability, elasticity, agility, fault tolerance, global reach, disaster recovery, and the consumption-based pricing model), and the difference between vertical and horizontal scaling.

These concepts appear on almost every AZ-900 exam form, and they reward candidates who memorized clear, concise definitions rather than those who understood the nuances but could not recall precise terminology under time pressure.

The DP-900 exam covers four domains — Core Data Concepts (25%), Relational Data in Azure (25%), Non-Relational Data in Azure (25%), and Analytics Workloads in Azure (25%). The perfectly balanced weighting means you cannot afford to neglect any single domain, and candidates who come from a pure SQL background sometimes underestimate the analytics and non-relational sections. Azure Cosmos DB, Azure Synapse Analytics, Azure Data Factory, and Power BI each require dedicated study sessions, not just a quick skim of documentation.

Core Data Concepts covers foundational knowledge that bridges the gap between general IT experience and data-specific Azure services. You need to understand the difference between structured data (rows and columns in relational tables), semi-structured data (JSON, XML, key-value pairs), and unstructured data (images, audio, text files). Batch processing — where data accumulates and is processed periodically — contrasts with stream processing, where data is ingested and analyzed continuously in near-real time.

Azure Stream Analytics is the primary service for stream processing, while Azure Synapse Analytics and Azure Data Factory handle batch ETL workloads. Understanding which service solves which type of problem is essential for answering scenario-based questions correctly.

The relational data domain covers Azure SQL Database, Azure SQL Managed Instance, Azure Database for PostgreSQL, and Azure Database for MySQL. Questions focus on use cases and key differentiators rather than syntax or query optimization. Azure SQL Database is a fully managed PaaS offering best suited for new cloud-native applications; Azure SQL Managed Instance supports a broader set of SQL Server features (including SQL Agent, cross-database queries, and linked servers) making it ideal for migrating complex on-premises SQL Server workloads.

PostgreSQL and MySQL managed services offer open-source database options for developers who need those specific engines. Know which service fits which migration or modernization scenario and you will handle this domain confidently.

Azure Cosmos DB is the centerpiece of the non-relational data domain and warrants thorough study. Cosmos DB is a globally distributed, multi-model database that supports multiple APIs: Core (SQL), MongoDB, Cassandra, Gremlin (graph), and Table. The key concepts tested in DP-900 are the five consistency levels (strong, bounded staleness, session, consistent prefix, eventual), the concept of request units (RUs) as the billing currency for throughput, and the partitioning strategy that enables horizontal scale.

Azure Table Storage is a simpler, lower-cost alternative to Cosmos DB Table API, suitable for scenarios where you do not need global distribution or flexible consistency guarantees. Candidates who conflate Cosmos DB with Azure Table Storage on the exam lose points on questions that hinge on exactly that distinction.

Analytics workloads in DP-900 span Azure Synapse Analytics, Azure Data Factory, Azure Databricks (at a high level), and Power BI. Azure Data Factory is the orchestration layer — it moves and transforms data between sources and destinations using pipelines, activities, and triggers. Azure Synapse Analytics combines data warehousing (dedicated SQL pools) and big data analytics (Synapse Spark pools) in a single unified workspace.

Power BI is the visualization and reporting layer, turning processed data into interactive dashboards and reports accessible to business users. Understanding the data flow — ingest with Data Factory, store and process in Synapse, visualize in Power BI — gives you a mental model that answers many analytics scenario questions automatically, without needing to memorize individual service features in isolation.

One resource worth mentioning in the context of structured study is the book Exam Ref AI-900 Microsoft Azure AI Fundamentals by Julian Sharp. While primarily focused on AI-900, the foundational data concepts and Azure architecture sections provide excellent supplementary reading for DP-900 candidates who want a structured reference beyond video courses and practice questions. The text is particularly strong on explaining the boundaries between machine learning services and data services — a distinction that appears in both AI-900 and DP-900 questions.

For exam day logistics, both AZ-900 and DP-900 can be taken online through Pearson VUE from your home or office, or at an authorized Pearson VUE test center. Online proctoring requires a stable internet connection, a cleared workspace, a webcam, and a government-issued photo ID.

Technical issues during online exams — while rare — do occur, and Microsoft's policy allows rescheduling without penalty if done more than 24 hours in advance. Arriving early at a test center (or logging in fifteen minutes early for online) reduces stress and gives you time to complete the check-in process without rushing into the exam.

Building an effective study schedule is where many candidates stumble — not because they lack motivation, but because they distribute study time inefficiently. The most common mistake is front-loading reading and video watching while leaving practice tests until the final two or three days before the exam.

At that point, if practice scores reveal knowledge gaps, there is no time to address them. A better model is the 60-20-20 split: 60% of your study time on conceptual learning (reading, video courses, official documentation), 20% on hands-on lab exploration in the Azure portal, and 20% on timed practice exams with structured review of every wrong answer.

For AZ-900, a four-week schedule might look like this: Week one covers cloud concepts and Azure architecture fundamentals. Week two dives into compute, storage, and networking services. Week three focuses on identity, security, governance, cost management, and compliance. Week four is entirely practice-test driven — two full-length practice exams per day, with the morning session taken under strict time conditions and the evening session used to review every question, correct or incorrect, against the official documentation.

Candidates who follow this week-four cadence report walking into the real exam feeling over-prepared, which is exactly the mindset you want. Over-confidence and under-preparation are both dangerous; calibrated confidence based on demonstrated practice performance is the goal.

For DP-900, the same four-week framework applies with different content distribution. Week one covers core data concepts and relational data fundamentals. Week two focuses on Azure SQL Database, Azure SQL Managed Instance, and the PostgreSQL/MySQL managed services. Week three is dedicated entirely to non-relational data (Cosmos DB, Azure Table Storage) and analytics workloads (Data Factory, Synapse Analytics, Power BI). Week four follows the same practice-test intensive approach.

If you have already cleared AZ-900, you can likely compress the DP-900 cloud context portions of week one and shift that time toward the Cosmos DB consistency models and Synapse Analytics architecture, which are the most commonly mis-understood areas.

Hands-on lab time is non-negotiable, even for fundamentals-level exams. Microsoft's free Azure sandbox environments — available through Microsoft Learn modules — let you create resources, explore the portal, and run guided exercises without incurring any cost.

Spending two hours creating an Azure SQL Database, running a few SQL queries, then creating a Cosmos DB account and exploring the different consistency settings does more for long-term retention than reading the same documentation three times. Visual memory of the Azure portal's interface also helps on exam questions that describe a scenario and ask what you would click or configure — a surprisingly common question type that purely reading-based study does not prepare you for.

Community resources are a valuable supplement to official Microsoft materials. Reddit's r/AzureCertification community is particularly active, with weekly exam experience threads where recent test-takers share which domains felt heavily tested on their specific exam form, which practice question banks most closely matched the real exam, and how much time they had remaining at the end.

Because Microsoft uses multiple exam forms and updates question pools regularly, these anecdotal data points help you calibrate where to focus energy in the final days. That said, avoid so-called az-900 dumps — memorized question lists from braindumping websites that violate Microsoft's exam non-disclosure agreement. Using dumps risks having your certification revoked if Microsoft detects exam fraud, and they provide false confidence because the real exam's phrasing and scenario framing differs from memorized questions.

The week before your exam, shift from learning new material to consolidating what you already know. Review your flashcards daily, take one timed practice test every morning, and spend evenings re-reading the official exam skills outline to make sure you have not overlooked any sub-objective.

Eat well, sleep adequately, and avoid cramming new content in the final 48 hours — cognitive research consistently shows that consolidation during sleep is more valuable than late-night review sessions at that stage of preparation. On exam morning, do a brief 30-minute review of your weakest area's key concepts, then close the books and go in confident.

After passing your first exam, do not wait more than two weeks before beginning preparation for the next one. The cloud context knowledge from AZ-900 is freshest immediately after you pass it, making it the ideal time to pivot to DP-900 or AI-900 study. Candidates who wait several months between exams often report having to re-study AZ-900 material because they have forgotten the service details that DP-900 builds upon.

Momentum in certification study is a real asset — use it by chaining your exams with minimal gaps between them. Both the dp 900 and az 900 badges together create a credential profile that speaks clearly to hiring managers: this candidate understands both cloud fundamentals and data services on Azure, which is a combination that relatively few entry-level candidates hold simultaneously.