DP-900 Microsoft Azure Data Fundamentals Exam Guide
DP-900 validates foundational knowledge of data concepts and the Azure services used for relational, non-relational, and analytics workloads. It is designed for people beginning to work with data in the cloud, not only for experienced data engineers. This guide helps you decide whether your current knowledge is close to exam scope, which domains deserve the most study time, whether to use self-paced or instructor-led training, and what to check before scheduling the assessment.
What does DP-900 actually validate?
DP-900 tests whether you can recognize core data concepts, choose appropriate Azure data services at a fundamental level, and distinguish transactional, analytical, relational, and non-relational workloads. It is a knowledge assessment rather than a specialist implementation exam, so preparation should focus on service purpose, workload fit, terminology, and basic architectural decisions.
Microsoft describes the certification as an opportunity to demonstrate foundational knowledge of core data concepts related to Azure data services. The audience is made up of candidates beginning to work with data in the cloud. You should already be familiar with relational and non-relational data concepts and with transactional and analytical workloads.
The certification is classified as Beginner level. Microsoft associates it with Azure, the Data Engineer role, and the Databases subject. Passing DP-900 can help prepare you for certifications such as Azure Database Administrator Associate or Azure Data Engineer Associate, but Microsoft states that it is not a prerequisite for either one.
Who benefits from this exam?
DP-900 is a sensible starting point for students, developers, analysts, administrators, project participants, and cloud beginners who need a shared vocabulary for Azure data services. It can also help a professional decide whether to move toward database administration, data engineering, analytics, or another Azure data path.
Do not treat the Beginner label as proof that no study is needed. A candidate who knows SQL but has not worked with cloud service categories may struggle with Azure-specific choices. Conversely, someone familiar with Azure may still need to review schemas, data formats, analytical workloads, and non-relational models.
Which skills and domains are measured?
Use the current Microsoft study guide as the controlling blueprint. It lists four domains: Describe core data concepts at 25–30%, Identify considerations for relational data on Azure at 20–25%, Describe considerations for working with non-relational data on Azure at 15–20%, and Describe an analytics workload on Azure at 25–30%. The percentages are domain labels, not a promise of an identical question mix on every attempt.
Microsoft explains that the bullets beneath each measured skill illustrate assessment coverage and that related topics may also appear. Most questions cover generally available features, although commonly used preview features may be included. Build understanding around the complete domain wording rather than memorizing isolated product names.
Describe core data concepts — 25–30%
This domain is one of the largest measured areas: Describe core data concepts represents 25–30% of the exam. Prepare to classify structured, semi-structured, and unstructured data; recognize common file formats and data stores; distinguish data workloads; and understand common data-processing approaches and professional roles.
A useful study exercise is to take a business example and classify it several ways. A customer table is structured data. A JSON event can be semi-structured data. An image or audio file is unstructured data. A system processing orders immediately has a transactional concern, while a system aggregating historical sales for reporting has an analytical concern.
Review why a database, a file store, a data warehouse, and a data lake are not interchangeable labels. The exam expects conceptual distinctions, so write a one-sentence purpose for each store and identify the kind of workload it supports. Do not spend most of your time on syntax that the blueprint does not require.
Identify considerations for relational data on Azure — 20–25%
This domain represents 20–25% of the exam: Identify considerations for relational data on Azure. Study tables, rows, columns, keys, relationships, normalization, and SQL-based querying alongside the Azure services that provide relational database capabilities.
The official course covers relational database services in Azure and introduces Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines through the related documentation referenced by Microsoft’s study material. Your goal is to explain the service category and a reasonable use case, not to become a database administrator before taking a fundamentals exam.
Practice comparison questions in your own words. Ask whether a requirement needs a managed cloud database, compatibility with an existing SQL Server environment, or control associated with a virtual machine. Then ask what the workload requires: transactions, reporting, scalability, availability, or integration with other services. This sequence is more useful than making a list of product definitions with no decision criteria.
Describe considerations for working with non-relational data on Azure — 15–20%
This domain represents 15–20% of the exam: Describe considerations for working with non-relational data on Azure. Focus on why an application might use key-value, document, graph, or column-family models, and connect those models to Azure storage and Azure Cosmos DB concepts.
Azure Cosmos DB is described in the supplied Microsoft study material as a fast NoSQL database with SLA-backed speed and availability, automatic and instant scalability, and open-source APIs for MongoDB and Cassandra. Treat those as service characteristics to recognize, then relate them to applications that need flexible data models or globally scalable access patterns.
Review the difference between choosing a non-relational model and merely storing a file outside a relational database. Blob, file, queue, and table-style storage solve different problems. A document database is also not automatically the best choice for every application; the data shape, access pattern, consistency needs, and workload determine the fit.
Describe an analytics workload on Azure — 25–30%
This domain represents 25–30% of the exam: Describe an analytics workload on Azure. Study the movement from data collection and storage to processing, visualization, and decision support. The official course specifically includes large-scale data warehousing, real-time analytics, and data visualization.
Separate batch analytics from real-time analytics when studying. Batch processing works with accumulated data, while real-time analysis considers data as it arrives. Then identify where data warehousing, stream processing, data integration, and visualization fit in a solution. The point is to recognize the workload and service role, not to design a production platform in detail.
Create a simple pipeline on paper: source, ingestion or integration, storage, transformation or analysis, and presentation. For each stage, write what problem it solves. This prevents a common mistake—memorizing Azure service names without knowing whether a service collects, stores, transforms, analyzes, or presents data.
How should you sequence DP-900 preparation?
Start with concepts, then study relational and non-relational service choices, and finish with analytics workflows and mixed-domain practice. This order follows the way the ideas depend on one another: you need to understand data shapes and workloads before judging which Azure service category fits a scenario.
Begin by reading the current DP-900 study guide and turning every skill bullet into a checklist. Mark each item as unfamiliar, partly understood, or explainable without notes. Use the official learning path for core data concepts first, because it has no prerequisites and covers common formats, workloads, roles, and services.
Next, work through the official DP-900 course material or its self-paced equivalent. Microsoft’s course is titled Introduction to Microsoft Azure Data, is beginner level, and covers relational data, non-relational data, big data, analytics, Azure storage, Azure Cosmos DB, data warehousing, real-time analytics, and data visualization.
After each topic, close the material and explain the concept from memory. If you cannot state what a service does, what data it handles, and what workload it supports, record it as a gap. Re-reading without retrieval can create recognition without usable understanding.
Choose self-paced or instructor-led study
Self-paced study is appropriate when you can follow a checklist, reserve regular sessions, and investigate unfamiliar terms independently. Instructor-led training is useful when you need structured pacing, live clarification, or a planned introduction to cloud data services. Microsoft presents the DP-900 course in both instructor-led and self-paced forms.
The official course has a listed duration of one day, but that is a course duration, not a guarantee that a candidate will be exam-ready after one day. Use it as a structured overview, then allocate additional time for review, retrieval practice, and the topics your diagnostic assessment exposes.
Educators have a separate Microsoft Learn learning path for preparing to teach DP-900 fundamentals in academic programs. That path is designed for course delivery and contains eight modules; it is useful context for instructors, but an individual candidate should normally begin with the certification page, study guide, and candidate learning content.
Use hands-on work without overbuilding
A small practical exercise can make service distinctions memorable, but hands-on work should support the blueprint rather than replace it. Use a sandbox or Azure account only when you can connect the activity to a concept such as storage type, relational versus non-relational design, ingestion, analytics, or visualization.
Microsoft’s core concepts learning path offers an Azure account choice that includes pay-as-you-go or an Azure free option for up to 30 days. Check the current Azure terms before creating resources, and remove resources when you finish. A free offer does not mean every activity or service is cost-free.
For DP-900, a useful exercise might be comparing a relational table with a document-shaped record, identifying a storage service for a file, and sketching how event data could reach a real-time analytics component. Avoid spending study time building a complex application whose implementation details are outside the fundamentals scope.
What is a practical DP-900 study roadmap?
Use a staged roadmap with a baseline, concept pass, service comparison, and exam simulation. The dates are yours to set; the important decision is to schedule only after you can explain the measured domains and your practice results show that remaining gaps are specific rather than broad.
Stage one is orientation. Read the current study guide, copy its four domain names into a tracker, and rate your confidence in each. Record whether your weakness is vocabulary, workload classification, Azure service selection, or inability to explain a concept. This diagnosis determines whether you need fundamentals first or targeted review.
Stage two is the concept pass. Complete the core data concepts learning path and study structured, semi-structured, and unstructured data, common file formats, data stores, data processing, and workload types. Use short written comparisons, such as relational versus non-relational or transactional versus analytical, rather than copying paragraphs.
Stage three is Azure mapping. Study relational services, Azure storage, Azure Cosmos DB, data integration, data warehousing, real-time analytics, and visualization. For every service or category, write three notes: the problem it addresses, the type of data or workload involved, and one reason a different option might be selected.
Stage four is retrieval and correction. Take Microsoft’s free practice assessment, review the report, and group missed items by domain. Revisit the underlying concept instead of memorizing the wording of a missed question. Microsoft says practice assessments provide an overview of question style, wording, and difficulty and can help identify knowledge gaps.
Stage five is environment preparation. Use the Microsoft exam sandbox to experience the interface and interactive question types. Confirm your language, account, scheduling route, and any accommodation needs before booking. The final review should be a compact checklist of distinctions you can explain, not a last-minute attempt to learn every Azure service.
A focused final review checklist
The final review is ready when you can classify data, explain common storage models, distinguish transactional and analytical workloads, describe relational structures, compare non-relational models, and place ingestion, storage, analysis, and visualization in an analytics workflow.
Check that you can answer these questions without relying on product-name recognition: What makes data structured, semi-structured, or unstructured? Why would an application use a document or key-value model? What separates a transaction system from an analytical system? What does a data warehouse contribute? Where does real-time processing belong?
Then compare the Azure service categories in scenario language. If the requirement says relational SQL semantics, think about relational services. If it describes flexible documents or NoSQL access, consider non-relational options. If it describes historical aggregation, dashboards, or event processing, identify the analytics stage before selecting a service. These are study heuristics, not substitutes for the official blueprint.
What are the official DP-900 delivery details?
Microsoft states that DP-900 is proctored and provides 45 minutes to complete the assessment. The exam page also indicates that interactive components may be part of the assessment. Confirm the current details on the official certification page when scheduling, because exam experiences and policies can change.
The exam is offered in English, Japanese, Chinese (Simplified), Korean, French, German, Spanish, Portuguese (Brazil), Russian, Indonesian (Indonesia), Arabic (Saudi Arabia), Chinese (Traditional), and Italian according to the supplied certification-page facts. The scheduling page is the appropriate place to confirm availability for your location and selected delivery route.
Microsoft lists Pearson VUE as a scheduling route and Certiport as an option for students or educators. Connect your certification profile to Microsoft Learn before scheduling. Microsoft recommends using a personal Microsoft account because exam records tied to an organizational work or school account can be lost and unrecoverable if you leave that organization.
If the exam is not available in your preferred language, Microsoft says you can request an additional 30 minutes. Review accommodation guidance early if you need assistive devices, extra time, or another modification to the exam experience. Do not wait until the appointment is imminent to investigate eligibility or documentation.
Scoring, retakes, and price checks
Microsoft requires a score of 700 or greater to pass DP-900. The score is an official requirement, while a practice-assessment result is a preparation signal; do not assume that a particular practice percentage maps directly to the exam score.
If you fail a certification exam, Microsoft states that you can retake it 24 hours after the first attempt. Later retake intervals vary, so consult the current exam retake policy rather than planning around an assumed schedule.
The exam price depends on the country or region in which the exam is proctored. Check the current scheduling page for the amount applicable to you. Avoid relying on prices quoted in third-party guides, because location and policy changes can make them inaccurate.
Track exam-version changes carefully
Use the current Microsoft study guide rather than an old outline or an unofficial question bank. Microsoft says the English-language exam is updated first; localized versions may follow approximately eight weeks later, although localized updates do not always follow that schedule.
The current study guide identifies skills measured as of July 21, 2026 in the supplied research. Check the live study guide before final revision to confirm that your notes match the version associated with your appointment. Pay particular attention to changed domain wording and newly listed service considerations.
A sensible change-control habit is to keep the study-guide URL in your notes and record the date you last checked it. When a domain changes, rebuild your checklist from the official bullets instead of trying to patch an old summary with scattered additions.
Which study materials should you trust?
Make the Microsoft certification page and DP-900 study guide your source of truth, then use the linked learning content to build understanding. The Microsoft Tech Community study guide can provide orientation, but its older domain percentages should not override the current official study guide.
The certification page links preparation content, a practice assessment, an exam sandbox, scheduling information, and certification resources. The study guide explains the purpose of the document, scoring, updates, accommodations, and measured skills. Start there before searching for third-party explanations.
The official core concepts learning path is a strong first resource because it has no prerequisites and introduces data formats, workloads, roles, and services. The DP-900 course supplies a broader course structure covering relational and non-relational data, big data, analytics, storage, Cosmos DB, warehousing, real-time analytics, and visualization.
Use third-party notes only to clarify a concept you have already located in the official scope. Check every service claim against current Microsoft documentation. A note that gives a precise question count, duration, price, or feature list without a current official source should not control your scheduling or preparation decisions.
How to use practice assessments properly
Use the official practice assessment as a diagnostic, not as a collection of questions to memorize. Its value is showing where your understanding is weak and familiarizing you with the style, wording, and difficulty of likely questions.
After each attempt, classify every uncertain answer even when you selected it correctly. For each missed or guessed item, write the principle being tested, the tempting but incorrect interpretation, and the source section you will review. This turns a score report into a revision plan.
Do not seek exam dumps, leaked questions, or memorized answer lists. They do not establish understanding, may be inaccurate or unauthorized, and cannot guarantee a passing result. Prepare from the skills measured and legitimate Microsoft learning resources instead.
What mistakes waste the most preparation time?
The most damaging mistakes are studying an outdated blueprint, treating service names as definitions, ignoring the largest domains, and confusing recognition with explanation. Correct these by anchoring your notes to the current study guide and practicing scenario-based distinctions across all four domains.
One common error is using an older outline that assigns different percentages to core concepts, relational data, non-relational data, and Azure data services. The current study guide uses the four domain labels listed above. Always name the official domain with its percentage when planning study time.
Another error is learning Azure SQL Database, Azure Cosmos DB, storage, and analytics products as disconnected flashcards. Instead, connect each service to data shape, workload, access pattern, and solution stage. A product name without a purpose will not help you reason through a scenario.
Candidates also sometimes overfocus on SQL syntax. Basic relational concepts matter, but DP-900 is broader: it covers data representation, storage, non-relational models, analytics workloads, and Azure service considerations. Balance relational review with the other measured domains.
Finally, do not book immediately after watching a course. Complete the study-guide checklist, take the practice assessment, correct the gaps, and use the sandbox. A booking decision should follow evidence about your readiness, not simply completion of a video playlist.
A decision rule for scheduling
Schedule when you can explain every measured domain in plain language, identify your weak areas from practice results, and have enough time to correct those weaknesses before the appointment. If your uncertainty is spread across all four domains, continue structured learning; if it is limited to a few concepts, use targeted review.
Before confirming the appointment, verify the current exam language, proctoring and delivery information, price for your region, account choice, and accommodation process. Save the official study-guide link so you can recheck updates. These administrative checks are separate from technical readiness and deserve their own checklist.
If you are using DP-900 to decide on a next certification, review the role-based certification pages after building the fundamentals. DP-900 can support preparation for Azure Database Administrator Associate and Azure Data Engineer Associate, but it is not required before pursuing either certification.
What should you do next?
Open the current Microsoft DP-900 study guide and create a four-row tracker using its exact domain names and percentages. Then complete the core data concepts learning path, map the remaining topics to the official course, and take the practice assessment before choosing a booking date.
Your immediate actions are straightforward: connect a personal Microsoft Learn profile, check the current language and scheduling options, use the exam sandbox, and record accommodation needs early. Study through explanations and service comparisons, not dumps or answer memorization. When your remaining gaps are specific and corrected, schedule through the official route for your region.
Conclusion
DP-900 is best approached as a fundamentals exam built around decisions: what kind of data is involved, what workload is being served, and which Azure service category fits the requirement. Let the current Microsoft study guide determine scope, use the official learning content to build understanding, and use practice tools to locate gaps. Confirm delivery, language, account, price, and policy details directly with Microsoft before scheduling.
Related exams
- AZ-104 exam — Microsoft Azure Administrator
- AZ-120 exam — Planning and Administering Microsoft Azure for SAP Workloads
- AZ-140 exam — Configuring and Operating Windows Virtual Desktop on Microsoft Azure
- AZ-305 exam — Designing Microsoft Azure Infrastructure Solutions
- AZ-400 exam — Microsoft Azure DevOps Solutions
- AZ-500 exam — Microsoft Azure Security Technologies
