DP-900.AE1
Microsoft Azure Data Fundamentals (DP-900)
Learn the basics of managing relational and non-relational databases, data analytics, and modern data warehouses in Azure.
- Practice in 13 Hands-On Labs — nothing to install
- 7 Interactive Lessons and 34 topics mapped to the official exam objectives
- 328 Practice Test Questions and 2 Full Length Tests
Beginner Self-paced · 1 year access
13 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
7Interactive Lessons
34Topics
13LiveLab
328Practice Test Questions
219Flashcards
117Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
If you’ve ever wanted to get ahead in cloud data without breaking a sweat, our Microsoft Certified Azure Data Fundamentals (exam DP-900) certification guide is the perfect start. You’ll learn the difference between relational and non-relational databases, explore Azure Synapse Analytics for end-to-end data solutions, and get hands-on with tools like Power BI for reporting. This beginner-friendly course makes mastering Azure data workloads and modern data warehouses a breeze.
- Learn to describe core data workloads such as transactional and analytical workloads, and their key differences
- Manage and work with relational databases using tools luke Azure SQL Databases, Azure Database for PostgreSQL, and Azure SQL Managed Instance
- Gain hands-on experience with Azure Cosmos DB and Azure Table Storage for managing nonrelational data, including key-value, column-family, and document data models
- Understand the fundamentals of data analytics such as batch processing, stream processing, and real-time analytics
- Learn to work with modern data warehouse solutions and implement en-to-end analytics using Azure Synapse Analytics
- Develop skills in managing and storing data using Azure Blob Storage, Data Lakes, and other Azure Storage options
- Sharpen your SQL skills by learning query techniques for managing and retrieving data from relational databases on Azure
- Deploy and manage databases and resources using Azure Resource Manager (ARM) templates
- Create HDInsight clusters and Azure Databricks for big data processing to manage Azure workloads.
Target Career Roles
- Security Architect
- IT Specialist/Cybersecurity Specialist
- Information Security Analyst
- Cybersecurity/IS Professional
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
7 Interactive Lessons · 34 topics01 Introduction 6 topics +
- 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
02 Core Data Concepts 4 topics +
- Describe Types of Core Data Workloads
- Describe Data Analytics Core Concepts
- Summary
- Exam Essentials
03 Relational Databases in Azure 6 topics · 6 LiveLab +
- Relational Database Features
- Relational Database Offerings in Azure
- Management Tasks for Relational Databases in Azure
- Query Techniques for SQL
- Summary
- Exam Essentials
6 LiveLab in this lesson — see the labs panel →
04 Nonrelational Databases in Azure 5 topics · 3 LiveLab +
- Nonrelational Database Features
- Azure Cosmos DB
- Management Tasks for Azure Cosmos DB
- Summary
- Exam Essentials
3 LiveLab in this lesson — see the labs panel →
05 File, Object, and Data Lake Storage 5 topics · 2 LiveLab +
- File and Object Storage Features
- Azure Storage
- Management Tasks for Azure Storage
- Summary
- Exam Essentials
2 LiveLab in this lesson — see the labs panel →
06 Modern Data Warehouses in Azure 5 topics · 2 LiveLab +
- Analytical Workload Features
- Modern Data Warehouse Components
- End-to-End Analytics with Azure Synapse Analytics
- Summary
- Exam Essentials
2 LiveLab in this lesson — see the labs panel →
07 Reporting with Power BI 3 topics +
- Power BI at a Glance
- Summary
- Exam Essentials
Hands-On Labs Our edge
13 LiveLabs- 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 Azure 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
Labs run in your browser — nothing to install.
03 / Exam details
Microsoft Azure Data Fundamentals (DP-900) Details
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.
Questions
40-60
(per exam)
Duration
60 minutes
(per exam)
Passing Score
700
(on a scale of 1000)
Exam Fee
USD 99 (Price based on the country or region in which the exam is proctored.)
(per exam)
Delivered by
Pearson VUE, Centriport
(in-person or online)
Question Format
Multiple-choice questions
single/multiple choice, performance-based
Practice Tests
328 Practice Questions
(mapped to official exam objectives)
Certification
DP-900.AE1
Microsoft credential
Ready to take the exam?
Add your official DP-900.AE1 exam voucher to your order.
Official Voucher · Fast delivery · Retake bundle available
Exam voucher is sold separately and not included with standard course.
04 / FAQs
Questions before you start
What is the Microsoft Certified Azure Data Fundamentals (DP-900) course?+
The Azure Data Fundamentals DP-900 certification certifies your skills and knowledge relating to the foundational concepts of data in Azure, including relational and non-relational databases, analytics workload, and data management in the cloud.
Do I need any experience before taking the DP-900 exam?+
While prior experience is not required, basic knowledge of databases and cloud computing will be helpful.
What is the Azure Data Fundamentals Certification cost?+
The cost of the DP-900 varies by country, but it’s typically around USD 99.
Who should take the DP-900 certification?+
The DP-900 certification is perfect for beginners in cloud data or IT professionals looking to enhance their understanding of Azure’s data services.
What is the format of the DP-900 certification exam?+
The exam includes multiple-choice, and drag-and-drop questions, usually lasting around 60 minutes.
What is the passing score for the DP-900 exam?+
To pass the DP-900 exam, you need a score of at least 700 out of 1000.
Where can I take the DP-900 certification exam?+
You can take the DP-900 exam online through Microsoft’s testing platform or at authorized Pearson VUE testing centers.
What are the prerequisites for this exam?+
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.
What is the exam registration fee?+
USD 99 (Price based on the country or region in which the exam is proctored.)
Where do I take the exam?+
Pearson VUE, Centriport
What is the format of the exam?+
Multiple-choice questions
How many questions are asked in the exam?+
The exam contains 40-60 questions.
What is the duration of the exam?+
60 minutes
What is the passing score?+
700
(on a scale of 100-1000)
What is the exam's retake policy?+
- 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.)
What is the validity of the certification?+
Usually two years
Where can I find more information about this exam?+
Keep going
You might also like
Join our DP-900 Exam Preparation Training!
Get fully prepared with our hands-on Azure Data Analytics training to pass the MS-900 certification exam.
- 1 year of full access
- 13 LiveLab included
- Certificate of completion
No credit card required