Exam DP203 Introduction

From MillerSql.com
Revision as of 10:29, 22 November 2024 by NeilM (talk | contribs) (→‎Pages index)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

Azure Databricks

Tybul course