1.0 Describe core data concepts
25-30%
- 1.1Describe ways to represent data
Describe the features of structured data; Describe the features of semi-structured data; Describe the features of unstructured data
- 1.2Identify 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
- 1.3Describe common data workloads
Describe features of transactional workloads; Describe features of analytical workloads
- 1.4Identify roles and responsibilities for data workloads
Describe responsibilities for database administrators; Describe responsibilities for data engineers; Describe responsibilities for data analysts
2.0 Identify considerations for relational data on Azure
20-25%
- 2.1Describe 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
- 2.2Describe 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
3.0 Describe considerations for working with non-relational data on Azure
15-20%
4.0 Describe an analytics workload
25-30%
- 4.1Describe 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
- 4.2Describe considerations for real-time data analytics
Describe the difference between batch and streaming data; Identify Microsoft cloud services for real-time analytics
- 4.3Describe 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