1. Home
  2. Microsoft
  3. DP-900 Exam Syllabus

Microsoft DP-900 Exam Syllabus

Start Free DP-900 Exam Practice After Reviewing the Topics

Before starting your DP-900 exam preparation, it is recommended to review the complete Microsoft Azure Data Fundamentals exam syllabus and carefully go through the exam objectives listed below. Once you understand the exam structure and objectives, you should practice using our free DP-900 questions. We also provide premium DP-900 practice test, fully updated according to the latest exam objectives, to help you accurately assess your preparedness for the actual exam.

Microsoft
Vendor
DP-900
Exam Code
319
Total Questions
4
Total Exam Domains

START FREE DP-900 EXAM PRACTICE

NO SIGNUP REQUIRED  •  100% FREE TO START

DP-900 EXAM QUESTIONS

Microsoft DP-900 Exam Objectives

Section 1: Describe core data concepts
Weight:
25-30%
Describe ways to represent data
  • Describe the features of structured data
  • Describe the features of semi-structured data
  • Describe the features of unstructured data
Identify options for data storage
  • Describe common formats for data files
  • Describe features of common data stores including databases
  • Identify Azure datastores for common use cases
Describe common data workloads
  • Describe features of transactional workloads
  • Describe features of analytical workloads
Identify roles and responsibilities for data workloads
  • Describe responsibilities for database administrators
  • Describe responsibilities for data engineers
  • Describe responsibilities for data analysts
Section 2: Identify considerations for relational data on Azure
Weight:
20-25%
Describe relational concepts
  • Identify features of relational data
  • Describe normalization and why it is used
  • Identify common structured query language (SQL) statements
  • 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
  • Identify Azure database services for open-source database systems
Section 3: Describe considerations for working with non-relational data on Azure
Weight:
15-20%
Describe the capabilities of Azure storage
  • Describe features of Azure Blob storage
  • Describe features of Azure Files
  • Describe features of Azure Table storage
Describe the capabilities and features of Azure Cosmos DB
  • Identify use cases for Azure Cosmos DB
  • Describe Azure Cosmos DB APIs
Section 4: Describe an analytics workload
Weight:
25-30%
Describe common elements of large-scale analytics
  • Describe considerations for data ingestion and processing
  • Describe options for analytical data stores
  • Describe Microsoft cloud services for large-scale analytics, including Azure Databricks and Microsoft Fabric
Describe considerations for real-time data analytics
  • Describe the difference between batch and streaming data
  • Identify Microsoft cloud services for real-time analytics
Describe data visualization in Microsoft Power BI
  • Identify the capabilities of Power BI
  • Describe features of data models in Power BI
  • Identify appropriate visualizations for data
Info
https://docs.microsoft.com/en-us/learn/certifications/exams/dp-900