Microsoft Certified Azure Data Fundamentals (DP-900)

(DP-900.AE1) / ISBN : 9781644593912

This course includes

Prepare for the Microsoft Azure Data Fundamentals (DP-900) exam with the course Microsoft Certified Azure Data Fundamentals (DP-900). The course contains assessment questions, test sets, interactive lessons with knowledge checks and quizzes, and labs to provide a hands-on learning experience of Azure data fundamentals in a safe, online environment. The course covers DP-900 exam objectives comprehensively and it will also give you a broad understanding of data solutions in Azure. It is intended to help you understand the different approaches to storing data in Azure as well as how you can turn raw data into information used to make valuable business decisions. 

Here's what you will get

The Microsoft Azure Data Fundamentals (DP-900) exam will validate your knowledge of core data concepts and related Microsoft Azure data services. It is intended for candidates beginning to work with data in the cloud and they should be familiar with the concepts of relational and non-relational data, and different types of data workloads such as transactional or analytical. It can also be used to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate, but it is not a prerequisite for any of them.


11+ Lessons | 260+ Exercises | 100+ Quizzes | 219+ Flashcards | 117+ Glossary of terms


51+ Pre Assessment Questions | 2+ Full Length Tests | 63+ Post Assessment Questions | 130+ Practice Test Questions

Hand on lab

13+ LiveLab | 00+ Minutes

Here's what you will learn

Download Course Outline

  • Who Should Read This Course?
  • DP-900 Exam Objectives
  • Domain 1: Describe Core Data Components
  • Domain 2: Describe How to Work with Relational Data on Azure
  • Domain 3: Describe How to Work with Nonrelational Data on Azure
  • Domain 4: Describe an Analytics Workload on Azure

  • Describe Types of Core Data Workloads
  • Describe Data Analytics Core Concepts
  • Summary
  • Exam Essentials

  • Relational Database Features
  • Relational Database Offerings in Azure
  • Management Tasks for Relational Databases in Azure
  • Query Techniques for SQL
  • Summary
  • Exam Essentials

  • Nonrelational Database Features
  • Azure Cosmos DB
  • Management Tasks for Azure Cosmos DB
  • Summary
  • Exam Essentials

  • File and Object Storage Features
  • Azure Storage
  • Management Tasks for Azure Storage
  • Summary
  • Exam Essentials

  • Analytical Workload Features
  • Modern Data Warehouse Components
  • End-to-End Analytics with Azure Synapse Analytics
  • Summary
  • Exam Essentials

  • Power BI at a Glance
  • Summary
  • Exam Essentials

  • Questions

  • Set A
  • Set B

Hands-on LAB Activities

  • Creating a SQL Server VM in the Azure Portal
  • Creating an Azure SQL Database
  • Viewing Access with RBAC for a Resource Group
  • Using an ARM Template in the Portal
  • Deploying an ARM Template
  • Creating an Azure Database for PostgreSQL Servers

  • Creating a Table in Table Storage
  • Creating a Cosmos DB Account and Getting the ARM Template
  • Creating a Cosmos DB Account from the Azure Portal Using the ARM Template

  • Creating a Storage Account, Container, and Storage Blob Directory
  • Creating a Blob Container

  • Creating an HDInsight Cluster
  • Provisioning an Azure Databricks Workspace and Creating a Cluster

Exam FAQs

There are no pre-requisites for this exam but It is recommended that you should have at least six months of experience with the Azure Cloud in any role, including technical, managerial, sales, purchasing, or financial.

USD 99 (Price based on the country or region in which the exam is proctored.)

Pearson VUE, Centriport

Multiple-choice questions

The exam contains 40-60 questions.

60 minutes


(on a scale of 100-1000)

  • If you don’t pass an exam the first time, you must wait 24 hours before retaking it.
  • A 14-day waiting period is imposed between all subsequent attempts (up to 5).
  • You may not take a given exam more than five (5) times within a 12-month period from the first attempt. If you failed the exam 5 times, you’ll be eligible to retake it again 12 months from the date of your first attempt.
  • You cannot retake an exam you’ve passed unless your certification has expired.
  • You must pay to retake the exam (if applicable.)

Usually two years