Describe core data concepts
25–30% - Describe structured, semi-structured, and unstructured data and common file formats.
- Describe transactional versus analytical workloads and Azure datastore options.
- Identify responsibilities of database administrators, data engineers, and data analysts.
Practice Core Data Concepts Questions →
Identify considerations for relational data on Azure
20–25% - Describe relational concepts, normalisation, SQL statements, and database objects.
- Describe Azure SQL Database, Managed Instance, SQL Server on Azure VMs, and open-source options.
Practice Relational Data on Azure Questions →
Describe considerations for working with non-relational data on Azure
15–20% - Describe Azure Blob Storage, Azure Files, and Table storage.
- Identify Cosmos DB use cases and APIs.
Practice Nonrelational Data on Azure Questions →
Describe an analytics workload
25–30% - Describe ingestion, analytical stores, Databricks, and Microsoft Fabric.
- Describe batch versus streaming analytics and visualisation in Power BI.
Practice Analytics Workload Questions →