- Worth 25 to 30% of DP-600, with 11 skills in the study guide. We teach and practice each one
- Implement workspace-level access controls
- Implement item-level access controls
- Implement row-level, column-level, object-level, and file-level access control
- Apply sensitivity labels to items
- Endorse items
- Configure version control for a workspace
- Create and manage a Power BI Desktop project (.pbip)
- Create and configure deployment pipelines
- Perform impact analysis of downstream dependencies from lakehouses, warehouses, dataflows, and semantic models
- Deploy and manage semantic models by using the XMLA endpoint
- Create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models
Microsoft Certification Training Course
Fabric Analytics Engineer Associate (DP-600) Certification Training Course
We'll get you ready for Exam DP-600, the Microsoft Fabric credential for analytics engineers who prepare data and build semantic models.
Course focus: Maintaining a Fabric analytics solution, preparing data, and building and tuning semantic models, mapped to the DP-600 study guide.
Course Overview
What the DP-600 course covers and who it's for.
Per Microsoft, DP-600 is for people who design, create and manage analytical assets such as semantic models, warehouses and lakehouses, and who query data with SQL, KQL and DAX.
Preparing data is 45 to 50% of the exam, so most of our lab time goes into getting, transforming and querying data in Fabric. We also cover security, deployment pipelines, Direct Lake and DAX performance.
Microsoft says DP-600 candidates prepare and enrich data for analysis, secure and maintain analytics assets, and implement and manage semantic models. You work with architects, analysts, engineers and admins, and you query data with SQL, KQL and DAX.
Fabric puts lakehouses, warehouses and Power BI in one place, and the analytics engineer is the person who ties them together. DP-600 is the credential for that role.
Accumentum is an independent training provider. We aren't a Microsoft partner and this isn't official Microsoft training. Microsoft sets exam content, prices and policies, so check learn.microsoft.com before you book.
Course Objectives
Get ready for DP-600 the way the exam is built.
01
Cover the Whole Study Guide
Work through all 3 skill areas in Microsoft's DP-600 study guide, weighted the way the exam weights them.
02
Go Deep on the Biggest Domain
Prepare data is 45 to 50% of the exam per Microsoft, so it gets the most class time.
03
Practice Hands-On
Work through the tasks the DP-600 study guide lists, hands on.
04
Master Maintain a data analytics solution
Microsoft lists 11 skills here, worth 25 to 30%. We practice all of them, from the first, implement workspace-level access controls, through the last, create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models.
05
Master Prepare data
Microsoft lists 18 skills here, worth 45 to 50%. We practice all of them, from the first, create a data connection, through the last, select, filter, and aggregate data by using DAX.
06
Master Implement and manage semantic models
Microsoft lists 12 skills here, worth 25 to 30%. We practice all of them, from the first, choose a storage mode, through the last, implement incremental refresh for semantic models.
07
Be Ready for Test Day
We practice the question styles Microsoft uses and walk through how scheduling, scoring and renewal work.
Who Should Attend
- Power BI developers moving into Fabric.
- Data analysts who build models and warehouses.
- BI and analytics engineers.
- PL-300 holders looking for the next step.
Prerequisites
- Microsoft doesn't require another certification first, and we don't have enrollment prerequisites either.
- Working knowledge of SQL, DAX and Power BI helps a lot.
Pathway Map
The DP-600 course in 3 modules.
Each module is one skill area from the official study guide, with its exam weight.
Course Content
- Worth 45 to 50% of DP-600, with 18 skills in the study guide. We teach and practice each one
- Create a data connection
- Discover data by using OneLake catalog and Real-Time hub
- Ingest or access data as needed
- Choose between different data stores
- Implement OneLake integration for Eventhouse and semantic models
- Create views, functions, and stored procedures
- Enrich data by adding new columns or tables
- Implement a star schema for a lakehouse or warehouse
- Denormalize data
- Aggregate data
- Merge or join data
- Identify and resolve duplicate data, missing data, or null values
- Convert column data types
- Filter data
- Select, filter, and aggregate data by using the Visual query editor
- Select, filter, and aggregate data by using SQL
- Select, filter, and aggregate data by using KQL
- Select, filter, and aggregate data by using DAX
- Worth 25 to 30% of DP-600, with 12 skills in the study guide. We teach and practice each one
- Choose a storage mode
- Implement a star schema for a semantic model
- Implement relationships, such as bridge tables and many-to-many relationships
- Write calculations that use DAX variables and functions, such as iterators, table filtering, windowing, and information functions
- Implement calculation groups, dynamic format strings, and field parameters
- Identify use cases for and configure large semantic model storage format
- Design and build composite models
- Implement performance improvements in queries and report visuals
- Improve DAX performance
- Configure Direct Lake, including default fallback and refresh behavior
- Choose between Direct Lake on OneLake and Direct Lake on SQL analytics endpoint
- Implement incremental refresh for semantic models
Course Features
How we teach DP-600.
Instructor-Led Classes
Live instruction with time for questions, so you aren't figuring out the hard parts alone.
Hands-On Practice
Practice on the tasks in the DP-600 study guide.
Study Guide Mapping
Every module maps to a skill area in Microsoft's DP-600 study guide.
Exam Strategy
Practice questions plus tips on scheduling, timing and what to expect on test day.
Certification Exam
About the DP-600 exam.
DP-600 Exam Readiness
Our students pass at a 98.8% rate across Accumentum courses. We'll get you ready for DP-600 the same way.
Per Microsoft, DP-600 is the exam for Microsoft Certified: Fabric Analytics Engineer Associate. Microsoft lists 100 minutes of exam time for associate exams like this one. You need a score of 700 or greater to pass. Microsoft sets the price by country and shows it on the exam page.
Full details are on the official certification page and the DP-600 study guide.
Accumentum is an independent training provider. We aren't a Microsoft partner and this isn't official Microsoft training. Microsoft sets exam content, prices and policies, so check learn.microsoft.com before you book.
Inside the Course
A closer look at each DP-600 domain.
The course starts with maintaining an analytics solution. Workspace settings, security and governance, version control, deployment pipelines, and managing lifecycle across development, test and production. These skills keep analytics reliable once more than one person touches them.
Preparing data is the biggest domain, so it gets the most time. You'll ingest or access data in Fabric, then select, filter, aggregate and shape it with SQL, KQL and DAX. You'll also decide when to use a lakehouse, a warehouse or an eventhouse.
The semantic model domain covers storage modes including Direct Lake, relationships, DAX measures, calculation groups, field parameters and row level security. We also cover performance work, from faster queries and report visuals to better DAX, and choosing between the two Direct Lake options Microsoft lists.
Throughout the course we connect each skill to what report users see. A well built semantic model loads a report in a second. A poor one can time out.
If you already passed PL-300, DP-600 is the natural next step. It takes the Power BI skills you have and adds the data engineering and modeling work behind them.
Here's how a typical week of class runs. We review the last domain, teach the new skills with live demos, and then you build it yourself in a Fabric workspace. You'll bring data in, shape it with SQL, build a semantic model on top, write the DAX measures, secure it with row level security and deploy it through a pipeline. By the last week you'll have built a small analytics solution end to end, the way an analytics engineer would at work.
We also cover choosing between options, since the exam asks a lot of which one questions. Lakehouse or warehouse, import or Direct Lake, dataflow or notebook. We compare them on cost, speed and who maintains them.
Study Plan
A study plan for DP-600 built from the study guide.
Time follows Microsoft's domain weights, so you study what the exam asks most.
Step 1: Maintain a data analytics solution
Spend about 30% of your study time here. First, implement workspace-level access controls. Then configure version control for a workspace. Last, create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models.
Step 2: Prepare data
Spend about 50% of your study time here. First, create a data connection. Then aggregate data. Last, select, filter, and aggregate data by using DAX.
Step 3: Implement and manage semantic models
Spend about 30% of your study time here. First, choose a storage mode. Then design and build composite models. Last, implement incremental refresh for semantic models.
Step 4: Review and book
Take Microsoft's free practice assessment, review the domains you scored lowest in, and book the exam once you're scoring well.
Official Resources
Where to check DP-600 facts on Microsoft Learn.
Microsoft changes exams often. These are the pages we teach from.
Exam Domains
How Microsoft weights the DP-600 exam.
From the official DP-600 study guide. Bigger domains get more questions.
Maintain a data analytics solution
25 to 30% of the exam. 11 skills listed by Microsoft.
Prepare data
45 to 50% of the exam. 18 skills listed by Microsoft.
Implement and manage semantic models
25 to 30% of the exam. 12 skills listed by Microsoft.
Exam and Course Format
What test day and class look like for DP-600.
DP-600 is a associate level exam. Microsoft lists 100 minutes of exam time for associate exams like this one. Microsoft scores exams from 1 to 1000 and you need 700 or greater to pass.
You can book DP-600 through the exam page on Microsoft Learn, where Microsoft shows the price for your country and the delivery options it offers. Microsoft also has a free exam sandbox there so you can see the question layout before test day.
Our course runs instructor-led. We teach each domain in study guide order, practice the tasks, and finish with review on the areas you miss most.
Career Paths
Where DP-600 fits in your career.
Analytics engineer
Build the warehouses, lakehouses and models reports run on.
Power BI developer
Move from reports into Fabric data modeling and Direct Lake.
BI developer
Own the semantic layer and its performance.
Data analyst
Take on more of the data prep and modeling work.
Funding and PathPay
Ways to pay for DP-600 training.
Accumentum is an Army CA and Air Force COOL Approved Vendor. If you're a soldier or airman, ask us whether Army Credentialing Assistance or Air Force COOL can fund this course for you.
PathPay lets you spread tuition into monthly payments instead of paying it all up front. You can see the plans on the PathPay page or ask us which plan fits this course.
Employers often pay for Microsoft training too. Ask us for a quote or invoice your company can use.
See PathPay plans, Army Credentialing Assistance training and Air Force COOL training.
Frequently Asked Questions
Common questions about our DP-600 course.
DP-600 is the exam for Microsoft Certified: Fabric Analytics Engineer Associate, a associate level credential. Details are on the official page at https://learn.microsoft.com/en-us/credentials/certifications/fabric-analytics-engineer-associate/
No. We're an independent training provider and we aren't a Microsoft partner. Our course follows Microsoft's public study guide. Microsoft offers free self-paced training on Microsoft Learn too.
Microsoft sets the price by country and shows it on the exam page when you pick your location. Check it there before you book.
Microsoft lists 100 minutes of exam time for associate exams like this one. A score of 700 or greater is needed to pass.
Fundamentals certifications don't expire. Associate, expert and specialty certifications are valid for one year and you renew for free online on Microsoft Learn.
Microsoft doesn't require another certification first, and we don't have enrollment prerequisites either. Working knowledge of SQL, DAX and Power BI helps a lot.
Instructor-led, with hands-on practice and exam prep. Ask us about upcoming class dates.
DP-600 is for analytics engineers who model and serve data. DP-700 is for data engineers who ingest, transform and orchestrate it. Both use Microsoft Fabric.
No. Microsoft doesn't require it, but Power BI and DAX experience helps a lot.
Microsoft lists SQL, KQL and DAX in the study guide.
Preparing data, at 45 to 50% of the exam per Microsoft.
Lakehouses, warehouses, eventhouses, dataflows, notebooks, pipelines and semantic models, per Microsoft's study guide. You'll also manage workspaces, version control and deployment pipelines.
Yes. You'll implement workspace and item level access, row level, column level and object level security, and sensitivity labels, all inside the maintain domain.
Partly. Semantic models are a full domain, so DAX and modeling matter a lot. But you'll also prepare data in Fabric, which goes well past Power BI Desktop.
It depends on your Fabric and Power BI experience. Students who already build models in Power BI usually need less time on the semantic model domain and more on data prep.
Yes. Analytics teams often train together so everyone builds models and pipelines the same way. Ask us about group options.
Accumentum is an Army CA and Air Force COOL Approved Vendor. If you're a soldier or airman, ask us whether Army Credentialing Assistance or Air Force COOL can fund this course for you.
PathPay lets you spread tuition into monthly payments instead of paying it all up front. You can see the plans on the PathPay page or ask us which plan fits this course.
Use the registration page linked below, or email info@accumentum.net and we'll follow up with dates and next steps.
Enrollment
Enroll in DP-600 training with Accumentum.
Enroll in our DP-600 course to get ready for the Fabric Analytics Engineer Associate exam with instructor-led classes and hands-on practice.
For dates and next steps, use the registration page linked below or email info@accumentum.net.
Ready to start on DP-600?
Tell us your target date and we'll help you plan the path.