Microsoft Azure Data Fundamentals (DP-900): Exam Guide

DP-900 is a Microsoft fundamentals exam that helps new Azure learners separate data concepts from general cloud knowledge and product-name memorisation.

Microsoft Azure Data Fundamentals, commonly known by the DP-900 exam code, is a fundamentals-level certification for understanding core data concepts and how Microsoft Azure data services support relational data, non-relational data, analytics workloads, governance, and basic platform choices. It is designed for people who need data literacy before moving into deeper engineering, analytics, administration, or architecture work.

The certification is useful for students, analysts, business users, junior developers, and managers who want a shared language for data projects. It helps explain why a team might choose Azure SQL Database for transactional systems, Azure Cosmos DB for globally distributed application data, Azure Data Lake Storage for analytical files, or Azure Synapse Analytics for integrated analytics. It does not require advanced coding experience, but it rewards candidates who have spent time in the Azure portal and can connect concepts to practical workloads.

What DP-900 actually tests

DP-900 is often described as an introductory exam, but that should not be confused with trivial. The exam is less about memorising every Azure product name and more about recognising the type of data problem being described. A question might ask whether a workload needs structured relational storage, flexible document data, large-scale analytical storage, or data transformation before reporting. The candidate is expected to choose the correct category of service and understand why it fits.

Microsoft’s published skills outline groups the exam into four broad areas. The current outline should always be checked on the official Microsoft exam page before booking, because Microsoft can update objectives over time. At a high level, candidates should expect these domains:

• Core data concepts, including types of data, transactional and analytical workloads, batch and streaming patterns, and basic roles in data projects.
• Relational data on Azure, including tables, keys, normalisation concepts, SQL workloads, Azure SQL Database, and related platform choices.
• Non-relational data on Azure, including key-value, document, graph, wide-column, object storage, Azure Cosmos DB, and Azure Storage concepts.
• Analytics workloads on Azure, including data ingestion, transformation, warehousing, lakehouse-style storage patterns, Power BI, and services such as Azure Synapse Analytics.

These areas translate into everyday workplace decisions. A report built from sales tables depends on relational modelling and query concepts. A customer-facing application storing flexible user profiles may need a non-relational design. A pipeline that lands raw files, transforms them, and makes them available for dashboards depends on storage, integration, analytics, and governance working together.

The exam also includes governance and privacy concepts because data fundamentals are incomplete without them. Candidates should understand access control, data sensitivity, retention, compliance responsibilities, and the difference between securing a platform and governing the data that flows through it. A common mistake is to spend all preparation time on storage engines and leave governance until the end, even though real projects often fail when ownership, classification, and permissions are unclear.

DP-900 scoring and exam expectations

Microsoft certification exams use a scaled score from 100 to 1000, and 700 is the passing score. This does not mean a candidate must answer exactly 70 percent of questions correctly, because scoring can account for item weighting and exam design. The practical takeaway is simple: prepare across all domains rather than trying to calculate a narrow pass margin.

Question numbers, formats, and delivery details can vary, so candidates should avoid relying on fixed claims about the exact number of questions or seat time. Microsoft’s exam page and exam policies remain the primary source for current registration, retake, accommodation, and delivery information. DP-900 is a fundamentals exam, and Microsoft currently treats fundamentals certifications differently from many role-based certifications in relation to renewal; candidates should verify the current certification policy directly with Microsoft before assuming any renewal requirement.

What should not be expected is a deep engineering exam. DP-900 does not ask candidates to build production pipelines, tune complex SQL workloads, design enterprise governance programmes, or write advanced code. It does, however, expect enough practical familiarity to distinguish between a database, a data lake, a warehouse, a pipeline, and a dashboard. Hands-on practice makes those distinctions easier to remember because learners see how the services appear in Azure rather than reading product descriptions in isolation.

The Azure data platform in plain English

Azure data services can feel crowded at first because several services appear to overlap. A useful starting point is to ask what kind of data is being stored, how it will be queried, and who will use the result. Operational applications usually need fast reads and writes. Analytical systems usually need to combine, transform, and summarise large volumes of data. Governance and security apply across both, but the design priorities differ.

Azure SQL Database is a managed relational database service for structured data where tables, relationships, SQL queries, and transactional consistency matter. It is commonly associated with application back ends, line-of-business systems, and reporting sources that need well-defined schemas. For DP-900, the important skill is not to memorise every deployment option; it is to recognise when relational modelling and SQL are the right fit.

Azure Cosmos DB is Microsoft’s globally distributed non-relational database service. It is often used where applications need flexible schemas, low-latency access, and data models such as document or key-value structures. DP-900 candidates should understand why document data can be useful for application profiles, catalogues, telemetry, and other workloads where rigid table structures may be inconvenient.

Azure Storage and Azure Data Lake Storage are closely related, but they should not be treated as interchangeable labels. Blob storage is general-purpose object storage for files and unstructured data. Azure Data Lake Storage builds on Azure Storage capabilities and is commonly used for analytical workloads where large volumes of raw, curated, and transformed data need to be organised for processing by analytics tools. The difference matters because a lake is usually part of a broader analytics architecture, not simply a folder full of files.

Azure Synapse Analytics brings together data integration, warehousing, and analytics capabilities. At the fundamentals level, candidates should know that it can support analytical querying and integration scenarios, particularly when data from multiple sources needs to be prepared for reporting or analysis. Power BI then sits closer to the business user, turning trusted data models into reports and dashboards.

How exam concepts map to real work

A manager looking at weekly sales performance may only see a Power BI dashboard, but DP-900 concepts sit underneath it. Sales transactions may begin in a relational database, be exported into analytical storage, transformed into a clean model, and then surfaced as measures in a report. If the report is slow or inconsistent, the issue may be in modelling, refresh design, data quality, or permissions rather than in the visual itself.

A product team collecting application events faces a different problem. Clickstream or telemetry data can be semi-structured, high-volume, and time-sensitive. The team may land raw files in storage, process them in batches, and use analytics services to identify usage patterns. In that scenario, the candidate needs to recognise that analytical processing is different from a transactional database workload.

Governance appears in both examples. A dashboard containing customer data needs access controls and sensitivity awareness. A data lake containing raw operational extracts needs naming conventions, ownership, retention rules, and privacy controls. DP-900 does not turn a candidate into a governance specialist, but it should make clear that data value depends on trust as much as storage capacity.

A practical two-to-three week study approach

A strong DP-900 preparation plan combines Microsoft Learn reading with small Azure exercises. Reading alone can make the services sound similar, while labs reveal how the portal, storage accounts, databases, queries, and reporting tools fit together. Candidates who want structured classroom preparation may use a DP-900 Azure Data Fundamentals course, but the same principle applies: each concept should be tied to a visible task.

Start with Microsoft Learn modules for core data concepts, and write short examples of structured, semi-structured, and unstructured data from a familiar workplace or study context.

Create a small Azure Storage account in a suitable learning subscription, upload sample CSV or JSON files, and compare general object storage with analytical data-lake-style organisation.

Review relational concepts, then create or inspect a simple relational database and practise reading tables, keys, rows, columns, and basic SQL query results.

Study non-relational concepts, then explore how document-shaped data differs from rows in a relational table and where Azure Cosmos DB fits.

Work through analytics concepts by tracing how raw data can be ingested, transformed, queried, and presented in a Power BI Desktop report.

Finish by revisiting the official skills outline, taking a practice assessment, and mapping every missed question back to a domain rather than memorising the answer.

This sequence is deliberately lab-first. The goal is not to build a production solution; it is to make the vocabulary concrete. A screenshot of a storage container, a simple SQL query, a document record, and a basic Power BI visual can be enough to anchor the concepts. Candidates who are preparing for interviews can also keep a small portfolio of notes or screenshots, because hiring managers often treat DP-900 as a literacy signal rather than proof that someone can perform effectively in an engineering role.

The most common preparation mistakes are predictable. Learners often cram service names without mapping them to workloads, skip governance and privacy topics, avoid hands-on labs, or start practice tests before reviewing the official skills outline. Readynez preparation materials for Microsoft fundamentals courses are typically organised around this workload-to-service mapping because it reflects how the exam tests understanding rather than product trivia.

DP-900 or AZ-900: which should come first?

DP-900 and AZ-900 are both Microsoft fundamentals certifications, but they answer different questions. AZ-900 is the broader cloud starting point, covering cloud concepts, Azure architecture, identity, governance, pricing concepts, and support. DP-900 narrows the focus to data concepts and Azure data services. Someone who is unsure how cloud platforms work at all may find AZ-900 a better first step, while someone already focused on reporting, databases, analytics, or data projects may get more immediate value from DP-900.

A simple decision rule is to start with the problem closest to the learner’s work. If the immediate need is understanding subscriptions, resource groups, identity, shared responsibility, and the language of cloud adoption, AZ-900 is usually the cleaner entry point. If the immediate need is understanding databases, storage, analytics pipelines, and reporting foundations, DP-900 is the more relevant first certification. Readers comparing broader Azure basics can also review an Azure training overview before choosing a route.

After DP-900, the next step depends on role direction. Learners interested in building data pipelines often look toward Azure data engineering paths such as DP-203. Analysts who work deeply with semantic models, Power BI, and enterprise analytics may consider analytics-focused credentials. Developers may use DP-900 as a foundation before learning how applications interact with relational and non-relational stores. The certification is most valuable when it becomes the base for a role-specific project rather than the end of the journey.

References and current-source checks

Before publishing or booking the exam, candidates should check Microsoft’s official DP-900 exam page, the latest skills measured outline, Microsoft certification scoring information, exam retake policies, and fundamentals certification renewal guidance. Microsoft Learn is also the primary source for Azure service documentation, including Azure SQL Database, Azure Cosmos DB, Azure Storage, Azure Data Lake Storage, Azure Synapse Analytics, and Power BI learning content.

This article summarises those topics in plain English and avoids fixed claims about exam question counts, timings, pricing, or regional delivery details because Microsoft can change those operational details. The safest study habit is to use official Microsoft sources for exam mechanics and use explanatory guides for context, examples, and study structure.

Building useful Azure data literacy

DP-900 is a good starting point when a learner needs to understand the language of modern data work on Azure. Its value comes from connecting concepts to practical decisions: relational or non-relational storage, transactional or analytical workloads, raw files or governed datasets, dashboard visuals or trusted models. Candidates who prepare in that way usually come away with knowledge they can use in meetings, project discussions, and entry-level technical conversations.

A practical next step is to compare the official Microsoft skills outline with a small set of hands-on labs, then decide whether self-study, instructor-led training, or a broader learning subscription fits the available time and goals. Readynez includes DP-900 and follow-on Microsoft courses in Unlimited Microsoft Training; readers who need help choosing a route can also contact the team with questions about the Azure Data Fundamentals path.

FAQ

What is Microsoft Azure Data Fundamentals?

Microsoft Azure Data Fundamentals is the certification associated with exam DP-900. It validates foundational understanding of core data concepts and how Azure services support relational data, non-relational data, analytics workloads, and basic governance considerations.

Who is DP-900 for?

DP-900 is suitable for beginners in data and Azure, including students, analysts, business users, junior developers, and managers who need baseline data literacy. It is also useful for people who work near data teams and want to understand the terminology used in databases, pipelines, analytics, and reporting.

Do candidates need Azure experience before taking DP-900?

Advanced Azure experience is not required, but some hands-on exposure helps. Creating a storage account, looking at a relational database, exploring document data, and following a simple analytics workflow can make the exam topics much easier to understand.

What score is needed to pass DP-900?

Microsoft uses a scaled score from 100 to 1000 for certification exams, and 700 is the passing score. Candidates should avoid treating this as a simple percentage and should prepare across all published skill domains.

Should a beginner take DP-900 or AZ-900 first?

AZ-900 is usually the broader starting point for general cloud concepts, while DP-900 is better for learners whose immediate focus is data storage, databases, analytics, and reporting. The better first choice depends on whether the learner needs general Azure literacy or data-specific literacy.