DP-900 Exam Study Guide (Microsoft Azure Data Fundamentals)

DP-900 Microsoft Azure Data Fundamentals Certification Study Guide

Preparing for the DP-900 Microsoft Azure Data Fundamentals Certificate exam? Don’t know where to start? This post is the DP-900 Certificate Study Guide (with links to each exam objective).

I have curated a list of articles from Microsoft documentation for each objective of the DP-900 exam. I hope this article will help you to achieve the DP-900 Microsoft Certified Azure Data Fundamentals Certification. Also, please share the post within your circles so it helps them to prepare for the exam.

DP-900 Azure Data Fundamentals Online Course

DP-900 Azure Data Fundamentals Practice Test

DP-900 Azure Data Fundamentals Other Stuff

Coursera (Specialization)Azure Data Fundamentals Exam Prep
Amazon e-book (PDF)Microsoft Azure Data Fundamentals

Looking for DP-900 Dumps? Read This!

Using DP-900 exam dumps can get you permanently banned from taking any future Microsoft certificate exam. Read the FAQ page for more information. However, I strongly suggest you validate your understanding with practice questions.

DP-900 Sample Practice Exam Questions

DP-900 Microsoft Azure Data Fundamentals Certificate Practice Test

To view other Azure Certificate Study Guides, click here

Full Disclosure: Some of the links in this post are affiliate links. I receive a commission when you purchase through them.

Describe Core Data Concepts (15-20%)

Describe Types of Core Data Workloads

Describe batch data

Batch vs. Real time data processing

Describe streaming data

Streaming data

Describe the difference between batch and streaming data

Difference between Batch & Streaming processing

Describe the characteristics of relational data

Properties of RDBMSs and NoSQL databases

Describe Data Analytics Core Concepts

Describe data visualization (e.g., visualization, reporting, business intelligence)

Data visualization beginner’s guide

Business reporting or enterprise reporting

Business intelligence: Transforming data into business insights

Describe basic chart types such as bar charts and pie charts

Bar Graph: graphical display of data

A complete guide to Pie Charts

Describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive)

Comparing Descriptive, Predictive, Prescriptive & Diagnostic Analytics

What is cognitive analytics?

Describe ELT and ETL processing

What is ETL?

Describe the concepts of data processing

What is Data Processing?

DP-900 Azure Data Fundamentals preparation

Amazon link (affiliate)

Describe How to Work with Relational Data on Azure (25-30%)

Describe Relational Data Workloads

Identify the right data offering for a relational workload


Describe relational data structures (e.g., tables, index, views)

Properties of Relational Tables

Fully managed, intelligent & flexible cloud database services

SQL: Views

Describe Relational Azure Data Services

Describe and compare PaaS, IaaS, and SaaS delivery models

Types of cloud services

Describe Azure SQL Database

What is Azure SQL Database?

Describe Azure Synapse Analytics

What is Azure Synapse Analytics?

Describe SQL Server on Azure Virtual Machine

What is SQL Server on Azure Virtual Machines?

Describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure
Database for MySQL

What is Azure Database for PostgreSQL?

What is Azure Database for MariaDB?

What is Azure Database for MySQL?

Describe Azure SQL Managed Instance

What is Azure SQL Managed Instance?

Identify Basic Management Tasks for Relational Data

Describe provisioning and deployment of relational data services

Provision an Azure SQL database to store application data

Describe the method for deployment including ARM templates and Azure Portal

Creating a single database in Azure SQL Database using an ARM template

Create an Azure SQL Database single database

Identify data security components (e.g., firewall, authentication, encryption)

Azure SQL Database firewall

Azure Azure AD authentication

Information protection and encryption

Identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)

Troubleshooting connectivity issues & other errors

Azure SQL DB Connectivity Troubleshooting

Troubleshoot connection issues to Azure SQL Database

Identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)

What is Azure Data Studio?

Connect to & query a SQL Server instance by using SSMS

sqlcmd – Use the utility

Azure certification Frequently Asked Questions

Describe Query Techniques for Data Using SQL Language

Describe How to Work with Non-relational Data on Azure (25-30%)

Describe Non-relational Data Workloads

Describe the characteristics of non-relational data

Properties of NoSQL databases

Describe the types of non-relational and NoSQL data

Non-relational data and NoSQL

Recommend the correct datastore

Non relational data: Typical requirements

Determine when to use non-relational data

Relational vs. Non-relational databases

Describe Non-relational Data Offerings on Azure

Identify Azure data services for non-relational workloads

What are NoSQL databases?

Describe Azure Cosmos DB APIs

Identify the technology options

Describe Azure Table storage

What is Azure Table storage?

Describe Azure Blob storage

What is Azure Blob storage?

Describe Azure File storage

What are the Azure Files?

dp-900 Exam details & Tips

Identify Basic Management Tasks for Non-relational Data

Describe an Analytics Workload on Azure (25-30%)

Describe Analytics Workloads

Describe transactional workloads

Online transaction processing (OLTP)

Describe the difference between a transactional and an analytics workload

Transactional vs. Analytical: How does OLTP differ from OLAP?

Describe the difference between batch and real time

Batch vs. Real time data processing

Describe data warehousing workloads

Data warehouse workloads and use cases

Determine when a data warehouse solution is needed

Why You Need a Data Warehouse?

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

What is Azure Data Lake Analytics?

What is Azure Synapse Analytics?

What is Azure Databricks?

What is Azure HDInsight?

Describe modern data warehousing architecture and workload

Modern data warehouse architecture

Describe Data Ingestion and Processing on Azure

Describe common practices for data loading

Data loading strategies for Synapse SQL pool

Describe the components of Azure Data Factory (e.g., pipeline, activities, etc.)

Pipelines and activities in Azure Data Factory

Describe data processing options (e.g., HDI, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)

What is Azure HDInsight?

What is Azure Databricks?

What is Azure Synapse Analytics?

What is Azure Data Factory?

Describe Data Visualization in Microsoft Power BI

Describe the role of paginated reporting

What are paginated reports in Power BI Premium?

Describe the role of interactive reports

Go from data to insight to action with Power BI Desktop

Describe the role of dashboards

Dashboards for business users of the Power BI service

Describe the workflow in Power BI

Power BI Workflow

This brings us to the end of the DP-900 Microsoft Azure Data Fundamentals Study Guide.

What do you think? Let me know in the comments section if I have missed out on anything. Also, I love to hear from you about how your preparation is going on!

In case you are looking for other Azure certification exams check out this page

Follow/Like ravikirans.com to Receive Updates

Want to be notified as soon as I post? Subscribe to RSS feed / leave your email address in the subscribe section. Share the article to your social networks with the below links so it can benefit others.

Share the Article in Your Social Media Networks

  • 15
  • 4
  • 9

You may also like

Leave a Reply

Your email address will not be published. Required fields are marked *