Fabric Data Engineer Training by Sai Phanindra Tholeti | Microsoft Fabric and Azure Data Engineering

#DP 900

This exam is an opportunity to demonstrate your knowledge of core data concepts and related Microsoft Azure data services. As a candidate for this exam, you should have familiarity with Exam DP-900’s self-paced or instructor-led learning material.

Kickstart Your Data Career with DP-900 Certification

You should be familiar with:

✅The concepts of relational and non-relational data.
✅Different types of data workloads such as transactional or analytical.
✅You can use Azure Data Fundamentals 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.

Modules We Learn

✅Module 1: Cloud Concepts
✅Module 2: Core Azure Services
✅Module 3: Azure Solutions and Management Tools
✅Module 4: Azure Storage
✅Module 5: Azure Security, Privacy, Compliance and Trust
✅Module 6: Azure Pricing and Support
✅Module 7: Azure Data Fundamentals
✅Module 8: DP 900 Exam Guidance

Describe core data concepts (25–30%)

CH1: Describe ways to represent data

Describe features of structured data
Describe features of semi-structured
Describe features of unstructured data

CH2: Identify options for data storage

Describe common formats for data files
Describe types of databases

CH3: Describe common data workloads

Describe features of transactional workloads
Describe features of analytical workloads

CH4: Identify roles and responsibilities for data workloads

Describe responsibilities for database administrators
Describe responsibilities for data engineers
Describe responsibilities for data analysts

Identify considerations for relational data on Azure (20–25%)

CH1: Describe relational concepts

Identify features of relational data
Describe normalization and why it is used
Identify common structured query language (SQL) statements
Identify common database objects

CH2: Describe relational Azure data services

Describe the Azure SQL family of products including Azure SQL Database,
Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines
Identify Azure database services for open-source database systems

Describe considerations for working with non-relational data on Azure (15–20%)

CH1: Describe capabilities of Azure storage

Describe Azure Blob storage
Describe Azure File storage
Describe Azure Table storage

CH2: Describe capabilities and features of Azure Cosmos DB

Identify use cases for Azure Cosmos DB
Describe Azure Cosmos DB APIs

Describe an analytics workload on Azure (25–30%)

CH1: Describe common elements of large-scale analytics

Describe considerations for data ingestion and processing
Describe options for analytical data stores
Describe Microsoft cloud services for large-scale analytics, including Azure Databricks and Microsoft Fabric

CH2: Describe consideration for real-time data analytics

Describe the difference between
batch and streaming data
Identify Microsoft cloud services for real-time analytics

CH3: Describe data visualization in Microsoft Power BI

Identify capabilities of Power BI
Describe features of data models in Power BI
Identify appropriate visualizations for data

Azure Data Engineer roadmap with Azure Data Factory, Databricks, Spark, and Delta Lake

What is the DP-900 certification exam?

DP-900 (Microsoft Azure Data Fundamentals) is an entry-level Microsoft certification that validates your knowledge of core data concepts and Azure data services — including relational data, non-relational data, and analytics workloads on Azure.

Who should take the DP-900 exam?

Freshers entering the data/cloud domain
IT professionals exploring Azure data services
Business analysts, developers, or DBAs starting their cloud journey
Anyone with no prior Azure experience — beginner-friendly!

What are the prerequisites for DP-900?

There are no mandatory prerequisites. Basic familiarity with data concepts is helpful, but all topics are covered from scratch. No coding experience is required.

What topics are covered in the DP-900 exam?

The exam covers 4 major areas:

Core Data Concepts (25–30%)
Relational Data on Azure (20–25%)
Non-Relational Data on Azure (15–20%)
Analytics Workloads on Azure (25–30%) — including Power BI, Azure Synapse, and Microsoft Fabric

Can DP-900 help me get a job or advance my career?

Yes! DP-900 is a strong foundation cert that adds credibility to your profile. It also prepares you for higher-level Azure certifications like DP-300 (Azure Database Administrator) and DP-700/DP-800 (Microsoft Fabric Engineer).

What training modes does SQL School offer for DP-900?

SQL School offers two modes:

LIVE Online Training — Instructor-led, interactive, with step-by-step guidance and assignments
Self-Paced Videos — On-demand, practical videos with concept-wise assignments
Both follow the same curriculum. Trainer support available for doubts & reviews.

How long does it take to prepare for DP-900?

With focused study, most candidates can prepare in 2–4 weeks. SQL School’s structured training covers all exam objectives with hands-on practice, making preparation faster and more effective.