Exam DP203 Introduction: Difference between revisions

From MillerSql.com
← Older edit
VisualWikitext
NeilM (talk | contribs)
1,601 edits
No edit summary
NeilM (talk | contribs)
1,601 edits
 
(21 intermediate revisions by the same user not shown)
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 7: Line 8:
https://learn.microsoft.com/en-us/credentials/certifications/azure-data-engineer/?practice-assessment-type=certification#certification-prepare-for-the-exam
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 [[Exam_DP203_Storage|Storage]] within Azure:
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 [[Exam_DP203_Storage|Storage]]:


# Azure Blob Storage
# Azure Blob Storage
Line 19: Line 20:
# Databricks
# Databricks
# Microsoft Purview
# Microsoft Purview
# Azure HDInsight
# Azure Machine Learning
# Azure Stream Analytics


running the following [[Exam_DP203_languages|Languages]]::
running the following [[Exam_DP203_languages|Languages]]::
Line 30: Line 34:
# SQL
# SQL
# Spark
# Spark
# Spark Delta Lake
# CosmosDB
# CosmosDB
# Dataverse
# Hadoop
authenticating with each other using the following [[Exam_DP203_authentication|authentication]] methodologies:
authenticating with each other using the following [[Exam_DP203_authentication|authentication]] methodologies:


# Managed Identities
# Managed Identities
# username and password
# username and password
Using the following data [[Exam_DP203_file_formats|file formats]]:
# CSV
# JSON
# 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.
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]]
[[Exam_DP203_Synapse_Analytics_Security|Synapse Analytics Security]]
[[Exam_DP203_Hybrid_Transactional_Analytical|Hybrid Transactional Analytical]]
[[Exam_DP203_Azure_Stream_Analytics|Azure Stream Analytics]]
[[Exam_DP203_front-end_services_Databricks|Azure Databricks]]
[[Exam_DP203_Course_Tybul|Tybul course]]

Latest revision as of 10:29, 22 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
  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

Retrieved from ‘https://wiki.millersql.com/wiki/index.php?title=Exam_DP203_Introduction&oldid=1330’