Certification guide
DP-900Microsoft Azure Data Fundamentals: the honest guide
DP-900 is a vocabulary exam, and that is not a criticism. Azure Data Fundamentals proves you can hold a conversation about data: what structured data is against semi-structured, when a relational database fits against a document store, and what each of the Azure analytics services is for. It takes most people a couple of weekends, costs $99, and never expires.
It is the data sibling of AZ-900, and it reads the same way. It will not get you a data engineering job. It will get a non-technical stakeholder taken seriously in a data conversation, and it will get a technical candidate past a screening filter that says 'Azure data familiarity'.
The exam is 40 to 60 questions in 45 minutes, and the pass mark is 700 on a 1000 point scale. Alongside multiple choice you get drag-and-drop and hot area questions, which ask you to match services to jobs or mark a spot on a diagram rather than pick from four lines.
Who Azure Data Fundamentals is for
A good fit if
- You work near data on Azure without administering it: project management, analytics reporting, procurement, compliance.
- You are starting a data path and want the cheapest first step before a role-based exam like DP-100 or DP-203.
- Your employer is moving data workloads to Azure and you need shared vocabulary across a team.
- You already hold AZ-900 and want the matching fundamentals credential on the data side.
- You want a credential that never expires and costs under $100.
Probably not, if
- You already build data pipelines or administer databases on Azure. A role-based exam maps to what you do; DP-900 will teach you little.
- You want to prove hands-on ability. This exam asks what a service is for, never how to configure or query it in production.
- You are looking for a database administration or data engineering credential specifically. DP-900 is the concepts layer beneath those, not a substitute for them.
- You are committed to AWS. The AWS data and analytics certifications are the equivalent step in that ecosystem.
Is Azure Data Fundamentals worth it?
For a non-engineer working near data on Azure, this is a strong $99. The gap between people who can name the services and people who cannot is real during a migration, and DP-900 closes it in a fortnight. The relational against non-relational content and the analytics vocabulary are the parts most useful outside the exam.
For someone heading toward a role-based data certification, it is optional. It is not a prerequisite for DP-100 or DP-203, and the useful content is a subset of what those cover. Take it if a $99 credential that never expires appeals, skip it if you are in a hurry to the role-based exam.
For someone hoping it leads directly to a data job, no. It is a fundamentals certification and hiring managers read it as exactly that. It is a good first step and a poor final one.
If you already hold AZ-900, the decision is easy. DP-900 is the same format, the same price and the same free study path, aimed at data rather than cloud generally, and the two together read as a coherent foundation.
What the exam actually asks you to do
Multiple choice and multiple response, plus drag-and-drop ordering and hot area items where you click a region of a screenshot.
Item formats
- Multiple choice
- Multiple response
- Drag and drop
- Hot area
The highlighted formats are the ones you cannot answer from memory alone. Microsoft Learn, exam duration and question types ↗
Domain breakdown and official weightings
From the official Microsoft Learn study guides. Describe core data concepts is the heaviest domain at 29 percent, followed by Describe an analytics workload on Azure at 29 percent.
- Describe core data concepts29%
- Identify considerations for relational data on Azure23%
- Describe considerations for working with non-relational data on Azure19%
- Describe an analytics workload on Azure29%
Study plans by experience level
No data or cloud background
2 to 3 weeksat 5 to 6 hours
- 1Week 1: the Microsoft Learn DP-900 path, core data concepts first. This is 29 percent of the exam and everything after it assumes the vocabulary. Get structured, semi-structured and unstructured straight before you move on.
- 2Create an Azure free account and build one of each thing you read about: a SQL Database, a Cosmos DB account, a storage container. Deleting them afterwards is fine; the point is to attach the words to something real.
- 3Week 2: relational data on Azure at 23 percent, then non-relational data at 19 percent. Focus on which service fits which shape of data, which is what the exam asks.
- 4Week 3: analytics workloads at 29 percent. This is the other heavy area and the one with the most service names to keep apart. Learn what each one does rather than how to run it.
- 5Take practice questions until you are consistently above 85 percent, then book.
Working in IT or data, new to Azure
1 weekat 8 hours
- 1Skim the Microsoft Learn path, slowing down only where the Azure service names are unfamiliar. If you already know relational databases, the core concepts and relational sections move fast.
- 2Map the Azure services onto tools you already use. A SQL Database is a managed relational engine, Cosmos DB is the document and key-value option, and the analytics services line up against warehousing and pipeline tools you likely know by other names.
- 3Spend one session on the analytics area specifically, because the service boundaries there are Azure-specific and the most common place to lose marks.
- 4Take one full practice set, fix whatever it exposes, and book.
Non-technical, working near a data team
4 to 5 weeksat 4 hours
- 1Weeks 1 to 2: core data concepts. Take the time here; the rest of the exam assumes this vocabulary, and it is the part that changes your working conversations.
- 2Week 3: relational and non-relational data, grouped by which service solves which problem rather than by feature lists.
- 3Week 4: analytics workloads, at the level of what each service is for. You do not need to build anything, only to recognize the names and their jobs.
- 4Week 5: practice questions, focusing on the wording rather than the technology. Microsoft's phrasing is consistent and learnable, and the drag-and-drop items reward knowing which service maps to which job.
Common mistakes
- Studying it like a technical exam
- DP-900 asks what a service is for and when it fits, not how to configure a database or write a pipeline. Time spent building production-grade resources is enjoyable and is not what the questions test.
- Over-investing in SQL
- The exam wants reading-level SQL familiarity only. A question may show a simple SELECT or describe a table and check that you recognize the relational concept. Practicing complex queries is preparation for a different exam.
- Treating the analytics services as interchangeable
- The analytics area is 29 percent of the exam, and its difficulty is keeping the service names apart. Learn what each one does and the job it maps to, because the drag-and-drop questions are built to catch a vague grasp of which is which.
- Blurring structured, semi-structured and unstructured
- The whole exam rests on these three categories and which storage option suits each. Get them confused early and the relational against non-relational questions become guesswork. This is the vocabulary to nail in week one.
- Paying for a course
- The official Microsoft Learn path is free, complete, and written by the team that writes the skills outline. Paid courses for DP-900 mostly repackage it.
- Expecting it to carry an application on its own
- It is a fundamentals credential and it reads as one. Useful as a first step or a vocabulary fix, not as evidence that you can build or run data systems.
What comes after passing
Fundamentals certifications do not expire, so there is nothing to renew, no continuing education requirement and no annual fee. That is unusual and it is worth knowing before you compare DP-900 against certifications with three-year cycles.
The next step depends on direction. DP-100 for data science, DP-203 for data engineering, and the Azure database administrator track if running databases is the goal. Those role-based certifications expire after one year and renew free through an online assessment on Microsoft Learn, so budget the annual hour rather than a fee.
If AZ-900 is not behind you yet, it pairs naturally with this one: same format, same price, the cloud fundamentals sitting beside the data fundamentals. AI-900 is the third fundamentals exam in the same family if your work drifts toward machine learning.
If the goal was shared vocabulary rather than a career move, you are done. Not every certification needs a sequel.
Where people go next
Costs across the full renewal cycle are on the Azure Data Fundamentals cost page.
Frequently asked questions
Is DP-900 worth it?
For non-engineers working near data on Azure, it is a strong $99 and it never expires. For engineers heading to a role-based data exam it is optional, since it is not a prerequisite. For anyone expecting it to produce a data job on its own, no.
How long does DP-900 take to study for?
One week at 8 hours for someone already working in IT or data, two to three weeks for someone new to cloud and data, four to five weeks at a lighter pace for a non-technical reader.
Does DP-900 require SQL knowledge?
Only reading-level familiarity. A question may show a simple SELECT or describe a table, and the exam cares that you recognize relational concepts rather than write production queries. You do not need to be able to author complex SQL to pass.
Does DP-900 expire?
No. Microsoft's fundamentals certifications do not expire, so there is no renewal cost and no continuing education requirement. Role-based data certifications such as DP-203 do expire after one year and renew free through an online assessment.
How hard is DP-900?
It is one of the most approachable exams on this site. The pass mark is 700 out of 1000, the questions are recall and recognition rather than analysis, and the official free study path covers the whole skills outline. The difficulty is keeping the service names and data categories apart.
Is DP-900 the same as AZ-900?
They are siblings, not the same exam. Both are Microsoft fundamentals exams at $99 that never expire and share the same format, but AZ-900 covers Azure and cloud concepts generally while DP-900 covers data: relational and non-relational storage and analytics workloads. Neither is a prerequisite for the other.
Where do the DP-900 domain weightings come from?
Microsoft publishes the weightings as ranges rather than fixed percentages. The figures used here are the midpoints of the official ranges from the current DP-900 study guide, so treat them as close guidance on where to spend your time rather than exact splits.
Keep reading
- Azure Data Fundamentals practice questions
Free sample questions with the full explanation on every answer.
- Free Azure Data Fundamentals practice test
10 original questions, playable now. No account, no card.
- Azure Data Fundamentals exam format
How many questions, how long, what the items look like, and how long it stays valid.
- Azure Data Fundamentals passing score
The exact cut score, what kind of number it is, and the retake terms.
- How hard is Azure Data Fundamentals?
An honest difficulty read from the format, the clock and the weights.
- What Azure Data Fundamentals costs
The voucher price, the retake, and what renewal costs across the cycle.
Practice Azure Data Fundamentals for free while you decide
Original questions written from the published objectives, with the concept, the reasoning, and a note on every wrong option. No account needed to start.
Start free Azure Data Fundamentals questions