Cert Atlas
Home/Microsoft/Microsoft Azure Data Fundamentals

Microsoft Azure Data Fundamentals (DP-900) Exam Blueprint

DP-900

Microsoft

40Questions
45 minDuration
700/1-1000Passing Score
$165Price
12Languages
Practice Microsoft Azure Data Fundamentals on QuizForge

Exam Domains

1.0 Describe core data concepts 28%
  • 1.1Describe ways to represent data
  • 1.2Describe features of structured data
  • 1.3Describe features of semi-structured data
  • 1.4Describe features of unstructured data
  • 1.5Identify options for data storage
  • 1.6Describe common formats for data files
  • 1.7Describe types of databases
  • 1.8Describe common data workloads
  • 1.9Describe features of transactional workloads
  • 1.10Describe features of analytical workloads
  • 1.11Identify roles and responsibilities for data workloads
  • 1.12Describe responsibilities for database administrators
  • 1.13Describe responsibilities for data engineers
  • 1.14Describe responsibilities for data analysts
2.0 Identify considerations for relational data on Azure 22%
  • 2.1Describe relational concepts
  • 2.2Identify features of relational data
  • 2.3Describe normalization and why it is used
  • 2.4Identify common structured query language (SQL) statements
  • 2.5Identify common database objects
  • 2.6Describe relational Azure data services
  • 2.7Describe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines
  • 2.8Identify Azure database services for open-source database systems
3.0 Describe considerations for working with non-relational data on Azure 18%
  • 3.1Describe capabilities of Azure storage
  • 3.2Describe Azure Blob storage
  • 3.3Describe Azure File storage
  • 3.4Describe Azure Table storage
  • 3.5Describe capabilities and features of Azure Cosmos DB
  • 3.6Identify use cases for Azure Cosmos DB
  • 3.7Describe Azure Cosmos DB APIs
4.0 Describe an analytics workload on Azure 32%
  • 4.1Describe common elements of large-scale analytics
  • 4.2Describe considerations for data ingestion and processing
  • 4.3Describe options for analytical data stores
  • 4.4Describe Microsoft cloud services for large-scale analytics, including Azure Databricks and Microsoft Fabric
  • 4.5Describe consideration for real-time data analytics
  • 4.6Describe the difference between batch and streaming data
  • 4.7Identify Microsoft cloud services for real-time analytics
  • 4.8Describe data visualization in Microsoft Power BI
  • 4.9Identify capabilities of Power BI
  • 4.10Describe features of data models in Power BI
  • 4.11Identify appropriate visualizations for data

Exam Details

Question TypesMultiple Choice, Multiple Response, Drag and Drop, Case Study, Build List, Hot Area, Repeated Answer Choices
FormatLinear
Online ProctoringAvailable
ID RequirementsOne valid, government-issued photo ID. Name on ID must match registration. For online: webcam required, room must be clear of people and materials.
RenewalRequired -- Microsoft certifications (Associate/Expert/Specialty) are renewed annually for free via a short renewal assessment on Microsoft Learn. Renewal assessment available 6 months before expiry. Fundamentals certifications do not expire.
PrerequisitesFamiliarity with Exam DP-900’s self-paced or instructor-led learning material (recommended)
Retake PolicyNo waiting period for first retake if score >= 500 on failed attempt. If score < 500: 14-day waiting period before retake. Maximum 5 attempts per exam per year (365 days). Free retake voucher sometimes included in official instructor-led training.
LanguagesEnglish, Simplified Chinese, Traditional Chinese, French, German, Japanese, Korean, Portuguese, Russian, Spanish, Arabic, Indonesian

Official Study Resources

online courseMicrosoft Learn (free self-paced training) (free)
practice examMicrosoft Official Practice Assessment (free)
Register for this exam | Source