Learning Path for DP-900 Microsoft Azure Data Fundamentals Certification

azure-data-fundamentals-600x600

Index

Prerequisites

This certification is intended for candidates beginning to work with data in the cloud. Candidate should have foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services. Candidates should be familiar with the concepts of relational and non-relational data, and different types of data workloads such as transactional or analytical.

Why to do it?

This certificate provides you an opportunity to demonstrate the knowledge of core data concepts and how they are implemented using Microsoft Azure data services. Azure Data Fundamentals can be used to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate. It will add value to your skill set and expertise if you into job roles like Azure Data Analyst, Azure Database Administrator, Azure Data Engineer, Solutions Architect etc.

Exam, Languages & Price

To get this certificate you need to pass ‘Exam DP-900’, which is available in English, Japanese, Chinese (Simplified), Korean, French, German, Spanish. Price is based on the country in which the exam is proctored. In the USA it’s for $99 USD and in India it’s for ₹3696 INR.

In exam, you will get 60 minutes to answer around 49 multiple choice questions. To pass the exam, you will need to score 700 points out of 1000. I got 903 points, Link to my certification badge

Skills Measured

Please note skills measured are intended to illustrate how Microsoft is assessing that skill. This list is not definitive or exhaustive.

In most cases, exams do NOT cover preview features, and some features will only be added to an exam when they are GA (General Availability).

Skill Weightage
Describe core data concepts 15-20%
Describe how to work with relational data on Azure 25-30%
Describe how to work with non-relational data on Azure 25-30%
Describe an analytics workload on Azure 25-30%

Above details are based on the updates available at the time of writing this article, for latest skill outline please refer link

Learning Path

There are two ways to prepare for this exam. You can either self-teach using free online resources or can go for instructor led path. In this article I will list all the required resources from Microsoft Learn to clear this exam. Remember objective should be to achieve the necessary knowledge instead of just clearing certifications. If you google it, you will find tons of material with question and answers for this exam. But that won’t help you to gain necessary knowledge. In machine learning terminology, use all the learning material as ‘training data’ and use online question dumps as your ‘test data’. Remember if you use ‘test data’ during training then it may result in good score but will definitely fail in real life scenarios!

Below are the learning resources for each of the section mentioned in skill measured table. At the end of each learning resource there is knowledge check section, to test your understanding of a particular module.

Describe core data concepts

azure-data-fundamentals-explore-core-data-concepts.png

This section has around 15 to 20 % weightage in exam. It tests candidates ability to describe core data workloads and data analytics core concepts.

Describe types of core data workloads

  • describe batch data
  • describe streaming data
  • describe the difference between batch and streaming data
  • describe the characteristics of relational data

Describe data analytics core concepts

  • describe data visualization (e.g., visualization, reporting, business intelligence (BI))
  • describe basic chart types such as bar charts and pie charts
  • describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive,cognitive)
  • describe ELT and ETL processing
  • describe the concepts of data processing

Suggested online resource is as below

Sample Questions

Below are few of the sample questions with multiple choice options. These questions are from Microsoft online learning path, in exam also you will get similar questions like below.

Set 1

Describe_concepts_of_relational_data_Knowledge_check.PNG

Set 2

Explore_concepts_of_data_analytics_Knowledge_check.PNG

Set 3

Explore_concepts_of_non-relational_data_Knowledge_check.PNG

Set 4

Explore_core_data_concepts_Knowledge_check.PNG

Set 5

Explore_roles_and_responsibilities_in_the_world_of_data_Knowledge_check.PNG

Describe how to work with relational data on Azure

azure-data-fundamentals-explore-relational-data.png

This section has around 25 to 30 % weightage in exam. It tests candidates ability to identify relational data workloads, relational Azure data services, identify basic management tasks for relational data and query techniques for data using SQL language.

Describe relational data workloads

  • identify the right data offering for a relational workload
  • describe relational data structures (e.g., tables, index, views)

Describe relational Azure data services

  • describe and compare PaaS, IaaS, and SaaS solutions
  • describe Azure SQL database services including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machine
  • describe Azure Synapse Analytics
  • describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL

Identify basic management tasks for relational data

  • describe provisioning and deployment of relational data services
  • describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
  • identify data security components (e.g., firewall, authentication)
  • identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
  • identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)

Describe query techniques for data using SQL language

  • compare Data Definition Language (DDL) versus Data Manipulation Language (DML)
  • query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL

Suggested online resource is as below

Sample Questions

Below are few of the sample questions with multiple choice options. These questions are from Microsoft online learning path, in exam also you will get similar questions like below.

Set 1

Explore_relational_data_offerings_in_Azure_Knowledge_check.PNG

Describe how to work with non-relational data on Azure

azure-data-fundamentals-explore-non-relational-data.png

This section has around 25 to 30% weightage in exam. It tests candidates ability to identify non-relational data workloads and corresponding offerings on the Azure.

Describe non-relational data workloads

  • describe the characteristics of non-relational data
  • describe the types of non-relational and NoSQL data
  • recommend the correct data store
  • determine when to use non-relational data

Describe non-relational data offerings on Azure

  • identify Azure data services for non-relational workloads
  • describe Azure Cosmos DB APIs
  • describe Azure Table storage
  • describe Azure Blob storage
  • describe Azure File storage

Identify basic management tasks for non-relational data

  • describe provisioning and deployment of non-relational data services
  • describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
  • identify data security components (e.g., firewall, authentication)
  • identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
  • identify management tools for non-relational data

Suggested online resource is as below

Sample Questions

Below are few of the sample questions with multiple choice options. These questions are from Microsoft online learning path, in exam also you will get similar questions like below.

Set 1

Explore_non-relational_data_offerings_in_Azure_Knowledge_check.PNG

Set 2

Explore_provisioning_and_deploying_non-relational_data_services_in_Azure_Knowledge_check.PNG

Describe an analytics workload on Azure

azure-data-fundamentals-explore-data-warehouse-analytics.png

This section has around 25 to 30 % weightage in exam. It tests candidates ability to identify analytics workload, components of a modern data warehouse and Azure tools and services used for data ingestion and visualization.

Describe analytics workloads

  • describe transactional workloads
  • describe the difference between a transactional and an analytics workload
  • describe the difference between batch and real time
  • describe data warehousing workloads
  • determine when a data warehouse solution is needed

Describe the components of a modern data warehouse

  • describe Azure data services for modern data warehousing such as Azure Data Lake, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
  • describe modern data warehousing architecture and workload

Describe data ingestion and processing on Azure

  • describe common practices for data loading
  • describe the components of Azure Data Factory (e.g., pipeline, activities, etc.)
  • describe data processing options (e.g., Azure HDInsight, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)

Describe data visualization in Microsoft Power BI

  • describe the role of paginated reporting
  • describe the role of interactive reports
  • describe the role of dashboards
  • describe the workflow in Power BI

Suggested online resource is as below

Sample Questions

Below are few of the sample questions with multiple choice options. These questions are from Microsoft online learning path, in exam also you will get similar questions like below.

Set 1

Examine_components_of_a_modern_data_warehouse_Knowledge_check.PNG

Set 2

Explore_data_ingestion_in_Azure_Knowledge_check.PNG

Set 3

Explore_data_storage_and_processing_in_Azure_Knowledge_check.PNG

Set 4

Get_started_building_with_Power_BI_Check_your_knowledge.PNG

Practice Exams

Its always a better idea to do few practice tests, before going for final exam. I have taken Examtopics practice test. I have also prepared my handwritten notes based on above learning path that I have refered before the final exam. I have also refered the 200 Practice Questions For Azure Data DP-900 Fundamentals Exam.

Other Links

2020

ANN Model to Classify Images

11 minute read

In this guide we are going to create and train the neural network model to classify the clothing images. We will use TensorFlow deep learning framework along...

Introduction to NLP

8 minute read

In short NLP is an AI technique used to do text analysis. Whenever we have lots of text data to analyze we can use NLP. Apart from text analysis, NLP also us...

K Fold Cross Validation

13 minute read

There are multiple ways to split the data for model training and testing, in this article we are going to cover K Fold and Stratified K Fold cross validation...

K-Means Clustering

12 minute read

K-Means clustering is most commonly used unsupervised learning algorithm to find groups in unlabeled data. Here K represents the number of groups or clusters...

Time Series Analysis and Forecasting

10 minute read

Any data recorded with some fixed interval of time is called as time series data. This fixed interval can be hourly, daily, monthly or yearly. Objective of t...

Support Vector Machines

9 minute read

Support vector machines is one of the most powerful ‘Black Box’ machine learning algorithm. It belongs to the family of supervised learning algorithm. Used t...

Random Forest

11 minute read

Random forest is supervised learning algorithm and can be used to solve classification and regression problems. Unlike decision tree random forest fits multi...

Decision Tree

14 minute read

Decision tree explained using classification and regression example. The objective of decision tree is to split the data in such a way that at the end we hav...

Agile Scrum Framework

7 minute read

This tutorial covers basic Agile principles and use of Scrum framework in software development projects.

Underfitting & Overfitting

2 minute read

Main objective of any machine learning model is to generalize the learning based on training data, so that it will be able to do predictions accurately on un...

Binary Logistic Regression Using Sklearn

5 minute read

In this tutorial we are going to use the Logistic Model from Sklearn library. We are also going to use the same test data used in Logistic Regression From Sc...

Train Test Split

3 minute read

In this tutorial we are going to study about train, test data split. We will use sklearn library to do the data split.

One Hot Encoding

11 minute read

In this tutorial we are going to study about One Hot Encoding. We will also use pandas and sklearn libraries to convert categorical data into numeric data.

Back to top ↑