Search...

Quick Feedback

Back to Azure Data Fundamentals (DP-900)

Azure Data Fundamentals (DP-900) Study Guide

Domain-by-domain study guide for Microsoft Azure Data Fundamentals (DP-900). Covers all 4 exam objectives with topic checklists, quick notes, and practice links.

Download PDF Notes

Exam Overview

Key facts before you start studying

Duration

45 min

Questions

Exam Code

DP-900

Domains

Quick Navigation

Jump to a specific exam domain

1. Describe core data concepts (25%)
2. Identify considerations for relational data in Azure (25%)
3. Describe considerations for working with non-relational data on Azure (25%)
4. Describe an analytics workload on Azure (25%)

Domain 1

25%

Describe core data concepts

Understand types of data, data roles, and core data processing concepts

Topics to Master

Types of core data workloads
Data concepts (structured, semi-structured, unstructured)
Batch and streaming data processing
OLTP vs OLAP workloads
Data roles (data engineer, data analyst, data scientist)

Domain 2

25%

Identify considerations for relational data in Azure

Understand relational data concepts and Azure relational data services

Topics to Master

Relational data concepts (tables, keys, normalization)
SQL language fundamentals (DDL, DML, DCL)
Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure VMs
Azure Database for PostgreSQL/MySQL/MariaDB

Domain 3

25%

Describe considerations for working with non-relational data on Azure

Understand non-relational data concepts and Azure NoSQL services

Topics to Master

Non-relational data concepts (key-value, document, graph, column-family)
Azure Cosmos DB and its APIs
Azure Cosmos DB consistency levels
Azure Storage services (Blob, Table, Queue, Files)
Azure Data Lake Storage Gen2

Domain 4

25%

Describe an analytics workload on Azure

Understand large-scale data analytics and Azure analytics services

Topics to Master

Data warehousing concepts (star schema, ETL vs ELT)
Azure Synapse Analytics
Azure Databricks
Azure Data Factory
Power BI (datasets, reports, dashboards)
Real-time analytics and streaming with Stream Analytics

Continue Your Prep

Free CertStud resources for DP-900

Study Notes Exam Study Plan Start Practice Test

Back to Azure Data Fundamentals (DP-900)

Azure Data Fundamentals (DP-900) Study Guide

Domain-by-domain study guide for Microsoft Azure Data Fundamentals (DP-900). Covers all 4 exam objectives with topic checklists, quick notes, and practice links.

Download PDF Notes

Exam Overview

Key facts before you start studying

Duration

45 min

Questions

Exam Code

DP-900

Domains

Quick Navigation

Jump to a specific exam domain

1. Describe core data concepts (25%)
2. Identify considerations for relational data in Azure (25%)
3. Describe considerations for working with non-relational data on Azure (25%)
4. Describe an analytics workload on Azure (25%)

Domain 1

25%

Describe core data concepts

Understand types of data, data roles, and core data processing concepts

Topics to Master

Types of core data workloads
Data concepts (structured, semi-structured, unstructured)
Batch and streaming data processing
OLTP vs OLAP workloads
Data roles (data engineer, data analyst, data scientist)

Domain 2

25%

Identify considerations for relational data in Azure

Understand relational data concepts and Azure relational data services

Topics to Master

Relational data concepts (tables, keys, normalization)
SQL language fundamentals (DDL, DML, DCL)
Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure VMs
Azure Database for PostgreSQL/MySQL/MariaDB

Domain 3

25%

Describe considerations for working with non-relational data on Azure

Understand non-relational data concepts and Azure NoSQL services

Topics to Master

Non-relational data concepts (key-value, document, graph, column-family)
Azure Cosmos DB and its APIs
Azure Cosmos DB consistency levels
Azure Storage services (Blob, Table, Queue, Files)
Azure Data Lake Storage Gen2

Domain 4

25%

Describe an analytics workload on Azure

Understand large-scale data analytics and Azure analytics services

Topics to Master

Data warehousing concepts (star schema, ETL vs ELT)
Azure Synapse Analytics
Azure Databricks
Azure Data Factory
Power BI (datasets, reports, dashboards)
Real-time analytics and streaming with Stream Analytics

Continue Your Prep

Free CertStud resources for DP-900

Study Notes Exam Study Plan Start Practice Test