Free study guide

Microsoft DP-900 Study Guide

Microsoft Azure Data Fundamentals DP-900

Microsoft Azure Data Fundamentals (DP-900) is the starting point for working with data in the cloud. It covers core data concepts, relational and non relational data on Azure, and analytics workloads including Power BI. It suits people beginning with data, and it can help you prepare for roles such as database administrator or data engineer, though it is not a prerequisite for any exam.

  • Exam code DP-900
  • Fundamentals level
  • 4 exam domains

This guide is free, with no sign-up. It explains every Microsoft DP-900 exam topic in plain English, one chapter at a time. Read them in order or jump straight to the topic you need.

  • 4chapters
  • 14topics
  • 5diagrams and exhibits
  • 1 h 15 minfast track
Start with Describe Core Data Concepts
  • Every topic follows the same simple pattern: what it is, how it works, common mistakes
  • Diagrams and real command output where a picture explains it best
  • Exam tips and worked subnetting and IPv6 practice, with answers

How the exam is weighted

Each domain is worth roughly this share of the exam. The exam provider publishes a range for each domain, so the bar marks the middle of it. Spend your study time in proportion, and select a domain to open its chapter.

Chapters

Open a chapter to see its topics and how long each takes.

1Describe Core Data Concepts4 topics · 19 min fast trackData formats, storage options, transactional and analytical workloads, and data roles.
  1. 1Ways to Represent Data5 min
  2. 2Data Storage Options and File Formats5 min
  3. 3Transactional and Analytical Workloads5 min
  4. 4Data Roles and Responsibilities4 min
Read the chapter overview →
2Identify Considerations for Relational Data on Azure3 topics · 16 min fast trackRelational concepts, normalization, SQL statements, database objects and the Azure SQL family.
  1. 1Relational Concepts and Normalization5 min
  2. 2SQL Statements and Database Objects5 min
  3. 3Azure Relational Data Services6 min
Read the chapter overview →
3Non Relational Data on Azure3 topics · 17 min fast trackBlob Storage, Azure Files, Table Storage and Azure Cosmos DB, with use cases and APIs.
  1. 1Azure Blob Storage6 min
  2. 2Azure Files and Table Storage5 min
  3. 3Azure Cosmos DB6 min
Read the chapter overview →
4Describe an Analytics Workload on Azure4 topics · 23 min fast trackIngestion, processing, data stores, Microsoft Fabric, real time analytics and Power BI.
  1. 1Data Ingestion and Processing5 min
  2. 2Analytical Data Stores and Services6 min
  3. 3Batch and Real Time Analytics6 min
  4. 4Power BI Visualization6 min
Read the chapter overview →

Ready for more practice?

The full Microsoft DP-900 question bank has 503 questions, with timed practice exams and an explanation for every answer.

SubscribeTry Sample Exam

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Microsoft. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.