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

DP-900 Microsoft Azure Data Fundamentals Certification Study Guide

DP-900 Preparation Details

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

Pluralsight Azure Data Fundamentals Learning Path
LinkedIn Learning (Free trial) Exam Tips: Azure Data Fundamentals
Udemy Azure Data Fundamentals Preparation
Skylines Academy Azure Data Fundamentals Certification

DP-900 Azure Data Fundamentals Practice Test

Whizlabs Exam Questions Azure Data Fundamentals Exam Certification
Udemy Practice Tests MS 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

DP-900 Sample Practice Exam Questions

DP-900 Microsoft Azure Data Fundamentals Certificate Practice Test

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.

Check out all the other Azure certificate study guides

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

ETL and ELT processing

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

Databases

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 solutions

Types of cloud services

Describe Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines

What is Azure SQL Database?

What is Azure SQL Managed Instance?

What is SQL Server on Azure Virtual Machines?

Describe Azure Synapse Analytics

What is Azure Synapse Analytics?

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?

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 the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)

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

Create an Azure SQL Database single database

Use PowerShell to create a database & configure a firewall rule

Use Azure CLI to create a database & configure a firewall rule

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

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

Compare Data Definition Language (DDL) versus Data Manipulation Language (DML)

Difference between DDL and DML in DBMS

Query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL

Use Azure Data Studio to connect & query PostgreSQL

Use MySQL Workbench to connect & query data in Azure Database for MySQL

Azure portal’s query editor to query an Azure SQL Database

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 provisioning and deployment of non-relational data services

Azure Cosmos account, database, container & items from the Azure portal

Create Apache HBase cluster in Azure HDInsight using ARM template

Describe the method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)

Azure Cosmos account, database from the Azure portal

Create an Azure Cosmos DB by using an ARM template

Create an Azure Cosmos DB database with PowerShell

Create an Azure Cosmos account, database using Azure CLI

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

Configure IP firewall in Azure Cosmos DB

Security in Azure Cosmos DB: Overview

Secure access to data in Azure Cosmos DB

Data encryption in Azure Cosmos DB

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

Diagnose & troubleshoot issues when using Azure Cosmos DB .NET SDK

Troubleshoot issues with an IP access control policy

Authorization fails for CosmosDB created over portal #662

Identify management tools for non-relational data

Work with data using Azure Cosmos explorer

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 warehousings such as Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight

Introduction to Azure Data Lake Storage Gen2

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., Azure HDInsight, 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 preparing for other Azure certification exams, check out the Azure study guide for those exams. 

Follow Me to Receive Updates on DP-900 Exam


Want to be notified as soon as I post? Subscribe to the 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 DP-900 Study Guide in Your Network

You may also like

Leave a Reply

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