Exam DP203 Introduction

Introduction

This is the introduction page to my study notes on exam DP 203 Microsoft Certified Azure Data Engineer.

https://learn.microsoft.com/en-us/credentials/certifications/azure-data-engineer/?practice-assessment-type=certification

which links through to the free online course for this, which I have studied:

https://learn.microsoft.com/en-us/credentials/certifications/azure-data-engineer/?practice-assessment-type=certification#certification-prepare-for-the-exam

Having read through it, I can see that the overarching principle involved is that Azure services in scope for this course are built on top of four fundamental types of data Storage:

1. Azure Blob Storage
2. Azure Data Lake Storage Gen2
3. Azure Lake Database
4. Azure SQL Database

involving the following front-end services:

1. Azure Synapse Analytics Studio
2. Databricks
3. Microsoft Purview
4. Azure HDInsight
5. Azure Machine Learning
6. Azure Stream Analytics

running the following Languages::

1. SQL
2. Python
3. Scala

on the following back-end services:

1. SQL
2. Spark
3. Spark Delta Lake
4. CosmosDB
5. Dataverse
6. Hadoop

authenticating with each other using the following authentication methodologies:

1. Managed Identities
2. username and password

Using the following data file formats:

1. CSV
2. JSON
3. Parquet

I will create Wiki pages here for each of the above, and document the content of the course in the context of links to the above items also.

Pages index

Exam_DP203_Introduction

Exam_DP203_Storage_2_Azure_Data_Lake_Storage_Gen2

Exam_DP203_Storage_3_Azure_Lake_Database

Exam_DP203_front-end_services_Azure_Synapse_Analytics_Studio

Exam_DP203_Serverless_SQL_Pool

Exam_DP203_Serverless_SQL_Pool_Authentication

Exam_DP203_Dedicated_SQL_Pool

Exam_203_back-end_services_Spark

Exam_DP203_Synapse_Data_Pipelines

Exam_DP203_Copy_Data_tool

Exam_DP203_front-end_services_Databricks

Exam_203_back-end_services_Spark_Delta_Lake

Exam_DP203_Serverless_SQL_Pool_Authentication

Exam_DP203_SQL_Management

Synapse Analytics Security

Hybrid Transactional Analytical

Azure Stream Analytics