Module: Describe core data concepts (15–20%)

• Describe types of core data workloads

  • Transactional

  • Analytical

  • Streaming

• Describe data analytics core concepts

  • Data processing, batch and stream processing

  • Data visualization and reporting

Module: Describe how to work with relational data on Azure (25–30%)

• Describe relational data workloads

  • OLTP workloads

  • OLAP workloads

• Describe relational Azure data services

  • Azure SQL Database

  • Azure Database for PostgreSQL

  • Azure Database for MySQL

• Identify basic management tasks for relational data

  • Backup and restore

  • Performance tuning

  • Security

Module: Describe how to work with non-relational data on Azure (25–30%)

• Describe non-relational data workloads

  • Key-value databases

  • Document databases

  • Graph databases

• Describe non-relational data offerings on Azure

  • Azure Cosmos DB APIs (Core/SQL, MongoDB, Cassandra, Gremlin, Table)

• Identify basic management tasks for non-relational data

  • Backup and restore

  • Scalability

  • Security

Module: Describe an analytics workload on Azure (25–30%)

• Describe analytics workloads

  • Big data

  • Real-time analytics

  • Batch processing

• Describe modern data warehouse components

  • Azure Synapse Analytics

  • Azure Data Lake

  • Azure Data Factory

  • Azure Databricks

  • Power BI