Exam DP203 Introduction: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
NeilM (talk | contribs)
 
(11 intermediate revisions by the same user not shown)
Line 22: Line 22:
# Azure HDInsight
# Azure HDInsight
# Azure Machine Learning
# Azure Machine Learning
# Azure Stream Analytics


running the following [[Exam_DP203_languages|Languages]]::
running the following [[Exam_DP203_languages|Languages]]::
Line 33: Line 34:
# SQL
# SQL
# Spark
# Spark
# Spark Delta Lake
# CosmosDB
# CosmosDB
# Dataverse
# Dataverse
Line 45: Line 47:


# CSV
# CSV
# JSON
# Parquet
# 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.


== Course parts ==
== Pages index ==
[[Exam_DP203_Path_1|Path 1]]
 
[[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