DP-900 study notes
- Core data concepts DP-900 notes on structured, semi-structured and unstructured data, file formats, data stores, transactional and analytical workloads, and the DBA, data engineer and data analyst roles. 25–30%
- Relational data on Azure DP-900 notes on relational concepts, keys, normalization, SQL statements, views, indexes and stored procedures, the Azure SQL family, and Azure Database for PostgreSQL and MySQL. 20–25%
- Non-relational data on Azure DP-900 notes on Azure Blob storage tiers and redundancy, Azure Files, Azure Table storage, and Azure Cosmos DB use cases, APIs, consistency levels, throughput and partitioning. 15–20%
- Analytics workloads on Azure DP-900 notes on data ingestion and processing, ETL and ELT, analytical stores, Microsoft Fabric, Azure Databricks and Synapse, batch versus streaming, real-time services and Power BI. 25–30%