Back to main

---

Skills measured as of November 2, 2023

Skills at a glance

• Describe core data concepts (25–30%)

• Identify considerations for relational data on Azure (20–25%)

• Describe considerations for working with non-relational data on Azure (15–20%)

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

Back to top

Back to main

---

Describe core data concepts (25–30%)

Describe ways to represent data

• Describe features of structured data

• Describe features of semi-structured

• Describe features of unstructured data

Identify options for data storage

• Describe common formats for data files

• Describe types of databases

Describe common data workloads

• Describe features of transactional workloads (OLTP)

• Describe features of analytical workloads (OLAP)

Identify roles and responsibilities for data workloads

• Describe responsibilities for database administrators

• Describe responsibilities for data engineers

• Describe responsibilities for data analysts

Back to top

Back to main

---

Identify considerations for relational data on Azure (20–25%)

Describe 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

Describe 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

Back to top

Back to main

---

Describe considerations for working with non-relational data on Azure (15–20%)

Describe capabilities of Azure storage

• Describe Azure Blob storage

• Describe Azure File storage

• Describe Azure Table storage

Describe capabilities and features of Azure Cosmos DB

• Identify use cases for Azure Cosmos DB

• Describe Azure Cosmos DB APIs

Back to top

Back to main

---

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

Describe common elements of large-scale analytics

• Describe considerations for data ingestion and processing

• Describe options for analytical data stores

• Describe Azure services for data warehousing, including Azure Synapse Analytics, Azure Databricks, Azure HDInsight, and Azure Data Factory

Describe consideration for real-time data analytics

• Describe the difference between batch and streaming data

• Describe technologies for real-time analytics including Azure Stream Analytics, Azure Synapse Data Explorer, and Spark Structured Streaming

Describe data visualization in Microsoft Power BI

• Identify capabilities of Power BI

• Describe features of data models in Power BI

• Identify appropriate visualizations for data

Back to top

Back to main

---

Return to top

Back to main