Skip to main content

#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.

This exam is intended for you, if you’re a candidate beginning to work with data in the cloud.

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.

LIVE ONLINESelf-Paced Videos

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

DP-600 Training FAQ's

What is DP-600 Job Role?

A DP-600 certified professional is an Azure Enterprise Data Analyst Associate who designs, builds, and deploys end-to-end analytics solutions using Microsoft Fabric. The role focuses on working with lakehouses, warehouses, dataflows, pipelines, data models, and Power BI to deliver enterprise-grade data analytics solutions. DP-600 professionals ensure data is integrated, secured, modeled, and visualized effectively for business insights.

What are the Job Roles of a DP-600 Certified Fabric Data Analyst?

💼 Top Job Roles:

1️⃣ Design and implement lakehouse and warehouse data models in Fabric
2️⃣ Build and manage data pipelines and dataflows for ingestion and transformation
3️⃣ Create enterprise semantic models for Power BI reporting
4️⃣ Implement security, governance, and compliance in analytics solutions
5️⃣ Optimize performance of Fabric data solutions and reports
6️⃣ Collaborate with data engineers, architects, and business stakeholders and more..!

What does our DP-600 Training course contains?

The course is carefully curated with below module:
👉🏻Module 1: MSSQL & TSQL Queries
👉🏻Module 2: Power BI

Who can join this course?

  • Freshers aspiring for Azure Database Administrator roles

  • SQL DBAs moving to cloud database administration

  • On-prem DBAs upgrading to Azure SQL solutions

  • IT professionals seeking DP-300 certification

  • Anyone wanting to manage cloud-based SQL workloads

No prior coding experience is required. All concepts are taught from scratch

What training modes are available?

Option 1:        LIVE Online Training  (100% Interactive, step by step, assignments)

Option 2:        Self Paced Videos (100% practical, step by step with concept wise assignments)

You may choose any one of these options, same curriculum!

I (Trainer) shall be available for doubts and clarifications, assignment check and review.

Why should I choose SQL School for DP-600 training?

👉🏻 Every session is Practical, Step by Step with Concept wise FAQs !!

👉🏻 100% results with on-time practice.  Daily Tasks for every session.

👉🏻 Concept wise tasks be submitted before next class for Job Waiters / Starters.

👉🏻 Concept wise tasks due for submission by Weekends for Working Professionals.

Training Modes

LIVE Online Training

Instructor Led

Self Paced Videos

 On-Demand

Corporate Training

With 100% Hands-On

Placement Partners

SQL School Fabric Data Analyst training certificate of completion issued in January 2026 with verification ID