Azure Data Engineering Exercises

The following exercises support the training modules on Microsoft Learn that support the Microsoft Certified: Azure Data Engineer Associate certification.

To complete these exercises, you’ll need a Microsoft Azure subscription in which you have administrative access. For some exercises, you may also need access to a Microsoft Power BI tenant.

Exercise	In ILT, this is a…
Explore Azure Synapse Analytics	Lab
Query files using a serverless SQL pool	Suggested demo
Transform data using a serverless SQL pool	Lab
Analyze data in a lake database	Suggested demo
Analyze data in a data lake with Spark	Suggested demo
Transform data using Spark in Synapse Analytics	Lab
Use Delta Lake in Azure Synapse Analytics	Lab
Explore a relational data warehouse	Suggested demo
Load Data into a Relational Data Warehouse	Lab
Build a data pipeline in Azure Synapse Analytics	Lab
Use an Apache Spark notebook in a pipeline	Lab
Use Azure Synapse Link for Azure Cosmos DB	Lab
Use Azure Synapse Link for SQL	Suggested demo
Get started with Azure Stream Analytics	Suggested demo
Ingest realtime data with Azure Stream Analytics and Azure Synapse Analytics	Lab
Create a realtime report with Azure Stream Analytics and Microsoft Power BI	Suggested demo
Use Microsoft Purview with Azure Synapse Analytics	Lab
Explore Azure Databricks	Suggested demo
Use Spark in Azure Databricks	Lab
Use Delta Lake in Azure Databricks	Optional demo
Use a SQL Warehouse in Azure Databricks	Optional demo
Automate an Azure Databricks Notebook with Azure Data Factory	Suggested demo