I Knew Nothing About Data. 90 Days Later I Had My Azure DP-900.

Here's a confession that would make any data engineer cringe: six months ago, I thought "normalization" was something you did in therapy. SQL? Wasn't that the thing from those hacking movies? Azure Cosmos DB? Sounds like a space program.

But my company was shifting everything to Azure, and my manager casually mentioned that "a data fundamentals cert would look great on your next review." So I did what any reasonable person does — I panicked quietly, bought a study guide, and figured it out.

And you know what? The DP-900 Azure Data Fundamentals exam is genuinely one of the most approachable Microsoft certifications out there. If I can pass it coming from basically zero data knowledge, so can you. Here's how.

What Even Is the Azure DP-900?

The DP-900 is Microsoft's entry-level data certification. It tests whether you understand core data concepts and how Azure data services work at a high level. You don't need to write SQL queries or build data pipelines — you just need to know what they are and when you'd use them.

$99 and no prerequisites. That's what makes it such a great starting point. Compare that to the AZ-104 at $165 that expects real Azure experience — the DP-900 is deliberately beginner-friendly.

Who Should Take the DP-900?

Honestly? Way more people than you'd think:

• Cloud beginners who want a second fundamentals cert after AZ-900
• Project managers and BAs who need to talk data with engineering teams
• Developers who want to understand the data services they're building on
• Career changers eyeing data engineering or analytics roles
• Anyone prepping for DP-100, DP-203, or DP-300 — DP-900 builds the foundation

DP-900 Exam Topics Breakdown

Microsoft organizes the exam into four domains. Here's what each one actually covers — and what tripped me up.

Core Data Concepts (25-30%)

This is "Data 101" and it's the largest section. You need to understand:

• Data types: structured, semi-structured, unstructured. Know the differences and real-world examples of each.
• Data storage: file formats (CSV, JSON, Parquet, Avro), databases vs data lakes vs data warehouses
• Data processing: batch vs streaming, ETL vs ELT. The ETL/ELT distinction shows up a lot.
• Data roles: data engineer, data analyst, database admin. Know who does what.

The trick here is that most questions aren't technical — they're conceptual. "Which type of data processing would you use for real-time fraud detection?" That kind of thing. If you understand the concepts, you'll cruise through this section.

Relational Data on Azure (20-25%)

SQL databases and Azure's relational services:

• Relational concepts: tables, primary/foreign keys, normalization, views, stored procedures
• Azure SQL Database vs SQL Managed Instance vs SQL Server on VM — when to use each
• Azure Database for MySQL/PostgreSQL — know these exist and their basic use cases
• Basic SQL: SELECT, JOIN, WHERE, GROUP BY. You won't write queries, but you need to understand what they do.

If you've ever used a spreadsheet with multiple tabs that reference each other — congratulations, you basically understand relational databases. The exam just formalizes that knowledge.

Non-Relational Data on Azure (15-20%)

NoSQL and Azure's non-relational services:

• Azure Cosmos DB: The star of this section. Know its APIs (Core SQL, MongoDB, Cassandra, Gremlin, Table), partition keys, and when you'd choose it over SQL Database.
• Azure Blob Storage: Hot, cool, and archive tiers. This comes up surprisingly often.
• Azure Table Storage and Azure Files
• NoSQL concepts: document databases, key-value stores, graph databases, column-family databases

The thing that confused me initially: Cosmos DB supports multiple APIs, which means it can act like different types of NoSQL databases depending on how you configure it. Once that clicked, the whole section made sense.

Analytics on Azure (25-30%)

Data analytics, visualization, and Azure's analytics stack:

• Azure Synapse Analytics: This is Microsoft's big unified analytics platform. Know what it does at a high level.
• Azure Data Factory: Data integration and ETL/ELT pipelines. Know its purpose, not how to build one.
• Azure Databricks: Apache Spark-based analytics. Big data processing.
• Power BI: Data visualization and reporting. Several questions focus on this.
• Azure HDInsight, Azure Stream Analytics — know what they're for

My biggest mistake? I underestimated Power BI. I thought it was just a chart-making tool. The exam asks about data models, DAX expressions (conceptually), and how Power BI connects to various data sources. Don't skip it.

My Actual Study Plan (What Worked)

I passed the DP-900 in about 3 weeks of study, doing roughly an hour a day plus longer sessions on weekends. Here's the timeline:

Total study time: roughly 25-30 hours. Could probably do it in 15-20 if you already know basic SQL and cloud concepts.

Free Resources I Used

• Microsoft Learn DP-900 Path — Free, official, and covers everything. This should be your primary study material.
• ExamCert DP-900 Practice Questions — Hundreds of free practice questions with explanations. I did these on my commute.
• John Savill's YouTube channel — His DP-900 study cram is excellent for visual learners. About 3 hours.

Paid Resources (Optional)

• Whizlabs DP-900 Practice Tests — ~$15 for extra practice exams. Worth it if you want more question variety.
• MeasureUp Official Practice Test — Microsoft's own practice test. Closest to the real exam but pricey (~$99).

Honestly, the free resources alone are enough. Microsoft Learn + ExamCert practice questions got me to a comfortable passing score without spending anything on study materials.

The 7 Things That Actually Show Up on the Exam

After taking the exam and talking to others who've taken it, these topics appear consistently:

1. Relational vs Non-Relational: When to Use What

If the scenario describes structured data with clear relationships (orders, customers, invoices) → relational. If it's flexible schema, massive scale, or document-based → non-relational. Sounds obvious, but the exam scenarios try to blur the lines.

2. Azure Cosmos DB APIs

Know all five APIs and when you'd pick each. Core (SQL) for document databases. MongoDB API for migrating from MongoDB. Gremlin for graph relationships. Cassandra for column-family workloads. Table API for key-value pairs.

3. ETL vs ELT

ETL: transform before loading (traditional, Azure Data Factory). ELT: load first, transform in the destination (modern, uses the power of cloud data warehouses like Synapse). The exam loves asking when to use which.

4. Batch vs Stream Processing

Batch = processing data in chunks on a schedule. Stream = processing data in real-time as it arrives. Azure Stream Analytics = streaming. Azure Data Factory = batch. Know the scenarios for each.

5. Azure Storage Tiers

Hot (frequent access, highest storage cost, lowest access cost). Cool (infrequent access, 30-day minimum). Archive (rare access, lowest storage cost, highest retrieval cost, hours to rehydrate). The exam tests you on which tier to choose for different scenarios.

6. Power BI Fundamentals

Reports vs dashboards vs paginated reports. Data sources and datasets. The Power BI workflow: connect → transform → visualize → publish → share. Don't skip this — it's worth ~5-8 questions.

7. Data Roles and Responsibilities

Data Engineer builds pipelines. Data Analyst creates reports and insights. Database Admin manages and secures databases. Data Scientist builds ML models. The exam gives you scenarios and asks which role is responsible.

DP-900 vs Other Azure Fundamentals Exams

How does DP-900 compare to the other fundamentals certifications?

My recommendation? Take AZ-900 first for broad cloud context, then DP-900 if you're interested in data roles. Together, they give you a solid Azure foundation for under $200.

After DP-900: Your Next Steps

The DP-900 is a stepping stone. Here's where to go based on your career goals:

• Data Engineering → DP-203 (Azure Data Engineer Associate). Heavy on Synapse, Data Factory, Databricks.
• Data Science → DP-100 (Azure Data Scientist Associate). Machine learning on Azure.
• Database Admin → DP-300 (Azure Database Administrator Associate). SQL Server focused.
• General Azure → AZ-104 (Azure Administrator). Broader cloud operations.
• Data Analytics → PL-300 (Power BI Data Analyst). If you loved the Power BI section.

Whatever you choose, the DP-900 gives you the vocabulary and conceptual framework that makes all those role-based exams easier. It's the foundation that pays forward.

FAQ: Azure DP-900 Common Questions

Related Resources

• Azure DP-900 Free Practice Questions
• Azure DP-900 Complete Guide
• DP-900 vs AZ-900: Which First?
• DP-900 vs DP-203: Which First?
• AI-900 vs DP-900: Which First?
• Azure DP-100 Study Guide 2026
• Azure AZ-104 Study Guide
• AWS vs Azure Certification: Which First?