Microsoft certification practice
Practise Microsoft Azure Data Fundamentals DP-900 across all 4 official exam domains — Describe core data concepts, Describe an analytics workload on Azure, Identify considerations for relational data on Azure, Describe considerations for working with non-relational data on Azure — with original exam-style questions, full explanations, and wrong-answer analysis. Microsoft certification exams often test whether you can choose the right Azure, Microsoft 365, identity, security or monitoring action for a realistic administrative scenario. Courseiva helps you practise with structured questions and explanations.
Ways to study DP-900
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
New here? Start with this
Start with a 25-question practice test
Covers all 4 domains · takes ~5 min · no account needed · shows your weak areas immediately
Key facts for the Microsoft Azure Data Fundamentals DP-900 exam.
Exam cost
$165 USD / ~£135
Duration
45 minutes
Question count
40–60 questions
Passing score
700 / 1000
Validity
Lifetime (no expiry)
Delivered by
Pearson VUE
Online proctored
Yes — available
Retake policy
24 hours after first failure; 14 days after second
Question formats
Microsoft Azure Data Fundamentals (DP-900) validates foundational knowledge of core data concepts and how they are implemented using Azure data services. It covers relational databases, non-relational storage, analytics workloads, and Azure's data service portfolio.
Official prerequisite
None
Recommended experience
Basic understanding of data concepts helpful
No technical prerequisites. Basic familiarity with what databases and data pipelines are used for is helpful.
Should you skip this exam?
If you are a practising data engineer or DBA, go directly to DP-300 (Azure Database Administrator) or DP-203 (Data Engineer) for meaningful career impact.
Courseiva study tip
Understand the distinction between relational (Azure SQL) and non-relational (Cosmos DB, Blob Storage) data, and know what each Azure analytics service (Synapse, Databricks, Stream Analytics) is used for.
UK salary range
£30,000–£55,000
US salary range
$50,000–$85,000
Job roles that cite DP-900
What certification to take next
$165 USD.
700 out of 1000.
No — DP-900 is a lifetime certification.
DP-900 is straightforward. It is conceptual, not hands-on, and covers data fundamentals at an awareness level.
AZ-900 covers general Azure cloud concepts. DP-900 focuses specifically on data services (databases, non-relational storage, analytics). Both are Foundational level. They complement each other but are separate exams.
See how DP-900 stacks up against related certifications.
100% free — no account required
Everything on Courseiva for DP-900 is free — no subscription, no trial, no email wall.
Courseiva Exam Intelligence
Data confidence: BuildingDerived from Courseiva's continuously updated practice dataset: 820 exam-style questions. Updated 2 July 2026.
Question difficulty mix
Average time per question: 91s
4
Exam domains
official blueprint domains covered by the bank
820
Questions
exam-style questions in the DP-900 bank
Practice modes
Choose a mode that matches your current study phase. Use topic practice early on and mock exams closer to your exam date.
All DP-900 Questions
Browse the full question bank organised by domain and difficulty.
Practice Test
Start a 20-question session with a full explanation after each answer.
Mock Exam
Simulate the real exam with a timed, full-length question set.
Quick 25
A 25-question warm-up — ideal for a short daily study session.
Flashcards
Reinforce key terms, commands, and protocol facts with flashcards.
Domain Practice
Focus exclusively on one exam domain to target your weakest area.
50-Question Set
Mid-length practice set covering all domains.
Exam guide
Start with a short practice session, review each missed answer, then return to the topics that caused mistakes.
Microsoft Azure Data Fundamentals DP-900 spans 4 official exam domains (Describe core data concepts, Describe an analytics workload on Azure, Identify considerations for relational data on Azure, and more). Questions test whether you can apply each objective in a realistic scenario, not just recall a definition.
Related practice questions
Use these internal links to move from the exam guide into focused topic practice pages.
Practise DP-900 questions linked to Describe core data concepts.
Practise DP-900 questions linked to Describe an analytics workload on Azure.
Practise DP-900 questions linked to Identify considerations for relational data on Azure.
Practise DP-900 questions linked to Describe considerations for working with non-relational data on Azure.
Practise DP-900 questions linked to DP-900 fundamentals.
Practise DP-900 questions linked to DP-900 scenario.
Practise DP-900 questions linked to DP-900 troubleshooting.
Practice directory
Every practice set is a unique selection of questions — numbered tests, domain-focused sessions, and topic-specific quizzes.
Showing 8 of 56 tests. See all 56 DP-900 practice tests →
Official blueprint
Target weak areas by practising questions from a single domain. Each domain page shows all questions, difficulty breakdown, and a focused practice session.
Practise DP-900 questions in this domain →
Practise DP-900 questions in this domain →
Practise DP-900 questions in this domain →
Practise DP-900 questions in this domain →
Deep-dive questions
The most-searched DP-900 questions — each with a detailed explanation, worked example, and full answer breakdown.
Term reference
These terms appear frequently in DP-900 questions. Understanding them precisely reduces guessing and improves scores.
Azure Cosmos DB
Azure Cosmos DB is a fully managed, globally distributed NoSQL database service that offers fast reads and writes anywhere in the world with automatic scaling and multiple consistency models.
Azure Data Factory
Azure Data Factory is a cloud-based data integration service that lets you create, schedule, and orchestrate data pipelines to move and transform data from various sources to destinations.
Azure Databricks
Azure Databricks is a fast, easy, and collaborative Apache Spark-based analytics platform optimized for Azure that lets data teams prepare data, run machine learning models, and build data pipelines using a single workspace.
Azure SQL Database
Azure SQL Database is a fully managed relational database-as-a-service (DBaaS) in Microsoft Azure, based on the SQL Server engine, that handles scaling, backups, patching, and high availability automatically.
Azure Synapse Analytics
Azure Synapse Analytics is a cloud-based data integration, warehousing, and analytics service that brings together big data and data warehouse capabilities under one platform.
Blob storage
Blob storage is a cloud service for storing large amounts of unstructured data, such as text or binary data, like documents, images, and videos.
Cosmos DB API
Cosmos DB API is a collection of interfaces that lets applications interact with Azure Cosmos DB, a globally distributed NoSQL database, using different data models and query languages.
Data Lake Storage Gen2
Data Lake Storage Gen2 is a cloud-based storage service that combines a scalable data lake with enterprise-grade file system capabilities for big data analytics.
Learn the concepts
101 book-style chapters cover every DP-900 objective in plain English. Read the theory here, then test it with practice questions.
Chapter 1
Data Roles and Core Concepts
25 min read
Chapter 2
Relational Data Concepts
25 min read
Chapter 3
Non-Relational Data Concepts
25 min read
Chapter 4
Analytics and Data Warehouse Concepts
25 min read
Chapter 5
Azure SQL Services
25 min read
Chapter 6
Azure SQL Managed Instance and SQL VM
25 min read
Chapter 7
SQL Querying Basics
25 min read
Chapter 8
Azure Cosmos DB
25 min read
Free study guide
The Courseiva DP-900 study guide covers exam format, the official domain blueprint with weights, a structured study plan, and domain-specific tips for each section. Use it alongside practice questions to build both conceptual depth and exam confidence.
Sample questions
Original exam-style questions — not copied from any exam or dump site. Open a question for the full answer breakdown.
Which THREE of the following are characteristics of a data lake compared to a data warehouse?
Refer to the exhibit. An administrator is configuring aggregations in Power BI Premium to improve performance on a large dataset. The aggregation is defined on the Sales table with…
A company uses Azure SQL Database for an inventory management system. The Inventory table has millions of rows. Queries frequently filter on WarehouseID and then sort by LastUpdate…
A company operates an online store where customers place orders and the system immediately updates inventory and records payments. This workload is best described as:
A social media application stores user posts in Azure Cosmos DB. Each post has fields: PostID (unique), UserID, Timestamp, Content, LikesCount. The application frequently queries f…
A library management system uses Azure SQL Database. The Books table has 500,000 rows with columns: BookID (primary key, clustered), Title, Author, ISBN, PublishedYear, CopiesAvail…
Related certifications
Studying for DP-900? These related Microsoft certifications share concepts and are common next steps.
Microsoft Security, Compliance, and Identity Fundamentals
SC-900 · 1,250 practice questions
Azure Administrator
AZ-104 · 1,049 practice questions
Microsoft Azure AI Fundamentals
AI-900 · 985 practice questions
Azure Fundamentals
AZ-900 · 981 practice questions
Azure AI Engineer Associate
AI-102 · 945 practice questions
Microsoft 365 Endpoint Administrator
MD-102 · 942 practice questions
Official booking and top-rated study resources for the DP-900.
Courseiva provides free Microsoft Azure Data Fundamentals DP-900 (DP-900) practice questions with original exam-style questions, detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics. Courseiva is an independent platform and is not affiliated with Microsoft.