Microsoft Fabric Analytics Engineer Associate

The Microsoft Fabric Analytics Engineer Associate (DP-600) certification validates expertise in designing, creating, and deploying enterprise-scale analytics solutions using Microsoft Fabric. Microsoft Fabric is a unified analytics platform that brings together data engineering, data science, real-time analytics, and business intelligence. Analytics engineers certified in DP-600 can implement lakehouses, data warehouses, pipelines, semantic models, and reports within the Fabric ecosystem.

Request Training Email Inquiry

What is the Microsoft Fabric Analytics Engineer Associate (DP-600) Certification?

Who Should Take This Course?

Data engineers building end-to-end analytics pipelines in Microsoft Fabric
BI developers migrating Power BI solutions to Microsoft Fabric
Data architects designing lakehouse and data warehouse solutions
Analytics engineers implementing OneLake-based data platforms
Data scientists integrating notebooks and ML experiments in Fabric
Enterprise architects planning Microsoft Fabric adoption strategies

What You Will Learn in the DP-600 Course

A comprehensive curriculum covering all exam objectives with hands-on labs and real-world practice.

Plan, Implement, and Manage a Solution for Data Analytics

Set up and govern a Microsoft Fabric workspace and analytics environment.

Microsoft Fabric architecture — OneLake, workspaces, and capacities
Fabric workspace setup — roles, permissions, and deployment pipelines
OneLake — unified storage, shortcuts, and mirroring from external sources
Microsoft Purview integration — governance, lineage, and sensitivity labels
Capacity management — Fabric SKUs, resource allocation, and monitoring

Implement and Manage a Lakehouse

Build and manage data engineering solutions using Fabric Lakehouse.

Fabric Lakehouse — Delta tables, files, and OneLake storage structure
Data ingestion — pipelines, dataflows, and notebook-based ingestion
Apache Spark in Fabric — notebooks, Spark pools, and job scheduling
Delta Lake operations — ACID transactions, time travel, and Z-ordering
Medallion architecture — bronze, silver, and gold layer patterns

Implement and Manage a Data Warehouse

Design and operate Fabric Warehouse solutions for structured analytics.

Fabric Warehouse — SQL-based analytics over OneLake Delta tables
T-SQL in Fabric Warehouse — DDL, DML, and stored procedures
Cross-item queries — querying across Lakehouse and Warehouse
Table distributions and indexing for Fabric Warehouse performance
Data ingestion into Fabric Warehouse using COPY INTO and pipelines

Implement and Manage Intelligence

Build semantic models and reports with Power BI in Fabric.

Direct Lake mode — semantic models over OneLake without import
DAX in Fabric — calculations, measures, and calculation groups
Power BI reports and dashboards within Fabric workspaces
Real-time analytics with KQL databases and Eventstream
AI and machine learning — notebooks, experiments, and model scoring in Fabric

Course Prerequisites

Pre-requisites training is free when you purchase the course from ProSupport

Power BI Data Analyst (PL-300) or strong Power BI experience
Azure Data Engineer (DP-203) or data engineering background
Proficiency in SQL — T-SQL for data querying and transformation
Python or PySpark experience for notebook-based data engineering
Familiarity with data warehousing concepts — star schema, ETL/ELT
Understanding of Delta Lake and Apache Spark fundamentals

Exam Information

Everything you need to know about the DP-600 certification exam.

Exam Component	Details
Exam Name	Implementing Analytics Solutions Using Microsoft Fabric
Exam Code	DP-600
Exam Type	Multiple Choice, Case Studies, Drag-and-Drop, Active Screen
Total Questions	40–60
Passing Score	700 (out of 1000)
Exam Duration	100 minutes
Language	English, Japanese, Chinese (Simplified), Korean, Spanish, German, French, Portuguese (Brazil)
Exam Provider	Microsoft / Pearson VUE
Exam Focus	Planning, implementing, and managing Microsoft Fabric lakehouse, warehouse, and intelligence solutions
Exam Registration	Register at microsoft.com/en-us/learning or via Pearson VUE testing centers
Retake Policy	24 hours before first retake; 14 days before subsequent retakes; 5 attempts per year
Certification Validity	1 year — renewable via free online renewal assessment on Microsoft Learn