Welcome to the DP-900: Azure Data Fundamentals Exam Prep Hub!

Welcome to the one-stop hub with information for preparing for the DP-900: Microsoft Azure Data Fundamentals certification exam. The content for this exam helps you to “Demonstrate foundational knowledge of core data concepts related to Microsoft Azure data services.”. Upon successful completion of the exam, you earn the Microsoft Certified: Azure Data Fundamentals certification.

This hub provides information directly here (topic-by-topic as outlined in the official study guide), links to a number of external resources, tips for preparing for the exam, practice tests, and section questions to help you prepare. Bookmark this page and use it as a guide to ensure that you are fully covering all relevant topics for the AI-900 exam and making use of as many of the resources available as possible.

---

Audience profile (from Microsoft’s site)

This exam is an opportunity to demonstrate your knowledge of core data concepts and related Microsoft Azure data services. As a candidate for this exam, you should have familiarity with Exam DP-900’s self-paced or instructor-led learning material.

This exam is intended for you, if you’re a candidate beginning to work with data in the cloud.

You should be familiar with:
- The concepts of relational and non-relational data.
- Different types of data workloads such as transactional or analytical.

You can use Azure Data Fundamentals to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate, but it is not a prerequisite for any of them.

---

Skills at a glance (as specified in the official study guide)

• Describe core data concepts (25–30%)
• Identify considerations for relational data on Azure (20–25%)
• Describe considerations for working with non-relational data on Azure (15–20%)
• Describe an analytics workload on Azure (25–30%)

---

Topic-by-Topic Exam Content

Describe core data concepts (25–30%)

Describe ways to represent data

• Describe features of structured data
  • Practice Questions: Describe features of structured data
• Describe features of semi-structured data
  • Practice Questions: Describe features of semi-structured data
• Describe features of unstructured data
  • Practice Questions: Describe features of unstructured data

Identify options for data storage

• Describe common formats for data files
  • Practice Questions: Describe common formats for data files
• Describe types of databases
  • Practice Questions: Describe types of databases

Describe common data workloads

• Describe features of transactional workloads
  • Practice Questions: Describe features of transactional workloads
• Describe features of analytical workloads
  • Practice Questions: Describe features of analytical workloads

Identify roles and responsibilities for data workloads

• Describe responsibilities for database administrators
  • Practice Questions: Describe responsibilities for database administrators
• Describe responsibilities for data engineers
  • Practice Questions: Describe responsibilities for data engineers
• Describe responsibilities for data analysts
  • Practice Questions: Describe responsibilities for data analysts

Identify considerations for relational data on Azure (20–25%)

Describe relational concepts

• Identify features of relational data
  • Practice Questions: Identify features of relational data
• Describe normalization and why it is used
  • Practice Questions: Describe normalization and why it is used
• Identify common structured query language (SQL) statements
  • Practice Questions: Identify common structured query language (SQL) statements
  • Additional Practice Questions: Identify common Structured Query Language (SQL) statements (SQL JOIN focused)
• Identify common database objects
  • Practice Questions: Identify common database objects

Describe relational Azure data services

• Describe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines
  • Practice Questions: Describe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines
• Identify Azure database services for open-source database systems
  • Practice Questions: Identify Azure database services for open-source database systems

Describe considerations for working with non-relational data on Azure (15–20%)

Describe capabilities of Azure storage

• Describe Azure Blob storage
  • Practice Questions: Describe Azure Blob storage
• Describe Azure File storage
  • Practice Questions: Describe Azure File storage
• Describe Azure Table storage
  • Practice Questions: Describe Azure Table storage

Describe capabilities and features of Azure Cosmos DB

• Identify use cases for Azure Cosmos DB
  • Practice Questions: Identify use cases for Azure Cosmos DB
• Describe Azure Cosmos DB APIs
  • Practice Questions: Describe Azure Cosmos DB APIs

Describe an analytics workload (25–30%)

Describe common elements of large-scale analytics

• Describe considerations for data ingestion and processing
  • Practice Questions: Describe considerations for data ingestion and processing
• Describe options for analytical data stores
  • Practice Questions: Describe options for analytical data stores
• Describe Microsoft cloud services for large-scale analytics, including Azure Databricks and Microsoft Fabric
  • Practice Questions: Describe Microsoft cloud services for large-scale analytics, including Azure Databricks and Microsoft Fabric

Describe consideration for real-time data analytics

• Describe the difference between batch and streaming data
  • Practice Questions: Describe the difference between batch and streaming data
• Identify Microsoft cloud services for real-time analytics
  • Practice Questions: Identify Microsoft cloud services for real-time analytics

Describe data visualization in Microsoft Power BI

• Identify capabilities of Power BI
  • Practice Questions: Identify capabilities of Power BI
• Describe features of data models in Power BI
  • Practice Questions: Describe features of data models in Power BI
• Identify appropriate visualizations for data
  • Additional Information: Visualization comparison table
  • Practice Questions: Identify appropriate visualizations for data

---

DP-900 Practice Exams

DP-900 Practice Exam 1 (60 questions with answers)

DP-900 Practice Exam 2 (60 questions with answers)

---

Important DP-900 Resources

• Link to the free, comprehensive, self-paced course on Microsoft Learn – Introduction to Microsoft Azure Data
• Link to the certification page: Microsoft Certified: Azure Data Fundamentals certification page
• Link to the study guide: Study guide for Exam DP-900: Microsoft Azure Data Fundamentals

YouTube video series: Microsoft Learn DP-900 Azure Data Fundamentals YouTube series

A book you may find useful (on Amazon): Exam Ref DP-900 Microsoft Azure Data Fundamentals 2nd Edition

---

Good luck to you on your data journey!