Exam DP203 Introduction: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
No edit summary
NeilM (talk | contribs)
No edit summary
Line 1: Line 1:
== Introduction ==
This is the introduction page to my study notes on exam DP 203 Microsoft Certified Azure Data Engineer.
This is the introduction page to my study notes on exam DP 203 Microsoft Certified Azure Data Engineer.


Line 48: Line 49:
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.
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.


Course parts
== Course parts ==
 
[[Exam_DP203_Part_1|Part 1]]
[[Exam_DP203_Part_1|Part 1]]

Revision as of 16:02, 15 November 2024

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

running the following Languages::

  1. SQL
  2. Python
  3. Scala

on the following back-end services:

  1. SQL
  2. Spark
  3. CosmosDB
  4. Dataverse
  5. 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. 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.

Course parts

Part 1