Exam passed! DP-900: Microsoft Azure Data Fundamentals Certification
Exam passed! DP-900: Microsoft Azure Data Fundamentals - Sharing my notes and experience of earning the certification exam
About the exam: Microsoft Azure Data Fundamentals DP-900 Certification
This exam is part of the 900 family which is targeted for general-purpose / fundamentals knowledge. I enjoyed prepared for this exam as it really covers the basics for understanding of data, which some minimum understanding of Azure offering for Data Services. Here are some of the topics I highlight:
- Understanding of Relational vs NoSQL and data-modelying types (structured, semi-structured, unstructured)
- OLTP and OLAP concepts
- Azure Storage, Data Lake and HDInsight
- Azure Data Factory, Databricks and Synapse (Spark, Hadoop)
- CosmosDB basics and APIs (MongoDB, Gremlim, Cassandra, SQL API)
- Power BI basics including visualizations, PowerBI Service and PowerBI Desktop
Verified by Credly
Earners of the Azure Data Fundamentals certification have demonstrated foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services.
- Describe core data concepts
- Identify considerations for relational data on Azure
- Describe considerations for working with non-relational data on Azure
- Describe an analytics workload on Azure
Skills measured:
- Describe ways to represent data, including structured, semi-structured and unstructured data
- Identify options for data storage, common formats for data files and types of databases
- Describe common data workloads including both transactional and analytical workloads
- Identify roles and responsibilities for data workloads including database administrators, data engineers and data analysts
- Identify relational concepts SQL and NoSQL data
https://docs.microsoft.com/en-us/learn/certifications/exams/dp-900
My experience taking exams online through Microsoft Learning
If you are interested, I’ve put together some recommendations for taking this kind of certification exams as part of my Microsoft AI Fundamentals AI-900 Certification post here which I recommend to take a look on preparing for exam day.
Recommended resources for exam
Here is a list of materials to take a look in case you are considering to pursuit the certification, which is available from Microsoft Learn website:
- https://learn.microsoft.com/en-us/training/paths/azure-data-fundamentals-explore-core-data-concepts/
- https://learn.microsoft.com/en-us/training/paths/azure-data-fundamentals-explore-relational-data/
- https://learn.microsoft.com/en-us/training/paths/azure-data-fundamentals-explore-non-relational-data/
- https://learn.microsoft.com/en-us/training/paths/azure-data-fundamentals-explore-data-warehouse-analytics/
See the full list and additional content at: https://docs.microsoft.com/en-us/learn/certifications/exams/dp-900
Deep links - Basics, trainings and recommended lectures
- What is Azure Synapse Analytics? - Azure Synapse Analytics
- Understand star schema and the importance for Power BI - Power BI
- Understanding the Table service data model (REST API) - Azure Storage
- Understand batch and stream processing - Training
- Big data architecture style - Azure Architecture Center
- Relational vs. NoSQL data
- Hot, Cool, and Archive access tiers for blob data - Azure Storage
- Explore data ingestion pipelines - Training
- Introduction to Azure Data Factory - Azure Data Factory
- Identify Azure Cosmos DB APIs - Training
- Tutorial: How to query with SQL in Azure Cosmos DB?
- How to query table data in Azure Cosmos DB?
- How to query graph data in Azure Cosmos DB?
- Use the Execute SSIS Package activity from the portal - Azure Data Factory
- Connector overview - Azure Data Factory & Azure Synapse
- Introduction to the Azure Cosmos DB Table API
- Introduction to Azure Cosmos DB Gremlin API
- Introduction to the Azure Cosmos DB Cassandra API
- Explore transactional data processing - Training
- Online analytical processing (OLAP) - Azure Architecture Center
- Describe core concepts of data modeling - Training
- Data modeling and visualizations - Training
- Get started with Power BI Desktop - Power BI
- Active Directory authentication - Azure Database for PostgreSQL - Single Server
- SSL/TLS - Azure Database for PostgreSQL - Single Server
- Transport Layer Security (TLS) - Hyperscale (Citus) - Azure Database for PostgreSQL
- What is Azure Database for PostgreSQL
- Understand data store models - Azure Application Architecture Guide
- Explore Azure Storage for non-relational data - Training
- Azure Data Lake Storage Gen2 Introduction
- What is Azure Databricks?
- What is Azure HDInsight
- Data redundancy - Azure Storage
- Microsoft Azure Data Fundamentals: Explore non-relational data in Azure - Training
- SQL Server to SQL Managed Instance: Migration overview - Azure SQL Managed Instance
- Describe Azure SQL services and capabilities - Training
- Compare the database engine features of SQL Database and SQL Managed Instance - Azure SQL Database & SQL Managed Instance
- What is Azure SQL Managed Instance? - Azure SQL Managed Instance
- Explore fundamental relational data concepts - Training
- Data Visualization | Microsoft Power BI
- Azure SQL Database – Managed Cloud Database Service | Microsoft Azure
- Explore common elements of stream processing architecture - Training
- Apache Spark in Azure Synapse Analytics overview - Azure Synapse Analytics
- What is Apache Spark Structured Streaming? - Azure Databricks
- Comparing Power BI Desktop and the Power BI service - Power BI
- Introduction to Blob (object) storage - Azure Storage
- Explore Azure blob storage - Training
I would be more than happy to connect in case you want to get more tips for getting ready for the exam. Please feel free to reach out to my LinkedIn here
-Esteban
