Hello, you are using an old browser that's unsafe and no longer supported. Please consider updating your browser to a newer version, or downloading a modern browser.
The Microsoft Certified: Fabric Analytics Engineer Associate is Microsoft's certification for the people who turn Fabric lakehouse and warehouse data into secured semantic models the business can query. This October 2026 guide covers the DP-600 exam, the three domains and weights in the October 19, 2026 outline, the 100-minute format and 700 passing score, the $165 fee, the free annual renewal, DoD 8140 status, and the roles it leads to.
The Microsoft Certified: Fabric Analytics Engineer Associate, earned by passing exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric, is Microsoft's role-based certification for the people who design, build and manage analytics assets in Fabric.
Microsoft Fabric is Microsoft's software-as-a-service analytics platform. Data engineering, data warehousing, real-time analytics and Power BI all run in it, on top of one shared data lake called OneLake. The analytics engineer works between the data engineers who land the data and the analysts who report on it. They shape lakehouse and warehouse data into star schemas, lock it down, and build the semantic models that Power BI reports query. DP-600 tests that work, and Microsoft expects you to query data in three languages: SQL, KQL (Kusto Query Language) and DAX (Data Analysis Expressions).
DP-600 carries no formal prerequisites. It is issued and maintained by Microsoft, and the current skills-measured outline took effect on October 19, 2026.
Access controls, sensitivity labels, version control, deployment pipelines and the XMLA endpoint. 25 to 30%.
Getting, transforming and querying data with SQL, KQL, DAX and the Visual query editor. The largest domain at 45 to 50%.
Storage modes, relationships, DAX, Direct Lake and incremental refresh. 25 to 30%.
Four things that set the Fabric Analytics Engineer apart from the other Microsoft data credentials in 2026.
Fabric puts lakehouses, warehouses, real-time data and Power BI in one platform, and DP-600 is the Microsoft certification written for the person who turns that data into models the business can use. Microsoft tags it for both the data engineer and the data analyst roles, which matches how the job sits between the two.
Microsoft expects DP-600 candidates to query and analyze data with SQL, KQL and DAX, and the Prepare data domain has an objective for each one, plus the Visual query editor. That mix is the clearest sign the exam covers the whole analytics layer, from the warehouse and the Eventhouse up to the semantic model.
Semantic models, DAX, storage modes and deployment pipelines are Power BI territory, so DP-600 is a natural step for experienced Power BI people moving into Fabric. Our guide to Microsoft certifications shows where it sits next to PL-300, the Power BI Data Analyst exam, on the data analyst path.
DP-600 is valid for one year and renews free through an unproctored, open-book assessment on Microsoft Learn. The renewal window opens six months before your expiration date, and there is no limit on renewal attempts. Microsoft doesn't claim a DoD 8140 mapping for DP-600. The current matrix is published at the DoD Cyber Exchange.
Its value comes from the platform instead. Organizations that run Power BI and build their analytics in Fabric need people who can model, secure and deploy it, and DP-600 is the credential Microsoft wrote for that job.
The certification, the DP-600 exam, and how to keep the credential active, as of October 2026.
DP-600 covers the analytics layer of Fabric. From here, most people move upstream into data engineering, across to Azure Databricks, or deeper into the SQL platform. The three below are the common next steps.
The other half of Fabric. DP-700 covers ingesting and transforming data, securing and managing an analytics solution, and monitoring and optimizing it, with SQL, PySpark and KQL. The lakehouse, warehouse and Eventhouse work in DP-600 carries straight over.
For teams whose lakehouse runs on Azure Databricks instead of, or next to, Fabric. It covers integrating and modeling data, building and deploying optimized pipelines, and troubleshooting and maintaining Databricks workloads, in a 120-minute exam.
For analytics engineers who end up owning the SQL side. DP-300 covers administering SQL Server database infrastructure across cloud, on-premises and hybrid setups with Microsoft's managed relational database services, a good pairing with the warehouse and SQL work in DP-600.
DP-600 sits at the associate tier of Microsoft's role-based data path. It builds on Power BI and data fundamentals, and from there the path branches into data engineering and the SQL platform.
Helpful groundwork, not required
The Fabric analytics credential
Pick your path
Two questions to answer before you commit: can you sit it, and should you pursue DP-600 specifically. The first one is easy.
No prerequisite credential required.
DP-600 has no formal prerequisites, and you don't need PL-300 or DP-900 first. You register through Pearson VUE and sit it at a test center or online with a proctor. The exam is offered in English, Japanese, Chinese (Simplified), German, French, Spanish and Portuguese (Brazil). If your language isn't on that list, you can request an extra 30 minutes.
You learn Direct Lake by configuring it.
Microsoft expects subject matter expertise with semantic models, warehouses and lakehouses, plus working SQL, KQL and DAX. Several objectives ask you to choose: between data stores, between storage modes, between the two Direct Lake options. Those choices only feel obvious after you have built the items yourself, so study with a real Fabric workspace open.
DP-600 maps to the analytics and BI roles that build on Microsoft Fabric and Power BI, the people who prepare data and own the semantic models reports depend on.
The role DP-600 is named for. Turns raw data in a Fabric lakehouse or warehouse into secured, reusable semantic models that analysts and report builders can work from.
Builds the models, measures and reports a business runs on. DP-600 covers the modeling, DAX and deployment work that sits behind a finished Power BI report.
Moves past report building into the model underneath, with storage modes, composite models, calculation groups and Direct Lake. A natural step up for people who already hold PL-300.
Designs star schemas, views and stored procedures in a Fabric warehouse or lakehouse, and keeps them fast and correct as data volumes grow.
Queries the same data with SQL, KQL and DAX and prepares it for other people to use. DP-600 shows you can work beyond a single report or spreadsheet.
Helps organizations plan and build analytics in Fabric, from workspace security and deployment pipelines to the semantic models their reporting depends on.
DP-600 sits between the Power BI Data Analyst and the Fabric Data Engineer. All three are Microsoft associate exams with the same length, fee and passing score, so the real difference is the work each one tests.
| Fabric Analytics Engineer (DP-600) | Power BI Data Analyst (PL-300) | Fabric Data Engineer (DP-700) | |
|---|---|---|---|
| Issuer | Microsoft | Microsoft | Microsoft |
| Level | Associate | Associate | Associate |
| Focus | Analytics assets and semantic models in Fabric | Preparing, modeling and visualizing data in Power BI | Ingesting, transforming and orchestrating data in Fabric |
| Languages and Tools | SQL, KQL, DAX | Power Query, DAX | SQL, PySpark, KQL |
| Prerequisites | None | None | None |
| Exam | Count not published, 100 min | Count not published, 100 min | Count not published, 100 min |
| Passing Score | 700 of 1000 | 700 of 1000 | 700 of 1000 |
| Cost | $165 | $165 | $165 |
| Validity | 1 year, free renewal | 1 year, free renewal | 1 year, free renewal |
| Best For | Analytics engineers and BI developers | Report and data analysts | Data engineers |
Costs are US prices as of October 2026 and vary by country or region. Microsoft claims no DoD 8140 mapping for any of the three. PL-300 facts reflect its April 20, 2026 outline, and DP-600 and DP-700 both moved to new outlines on October 19, 2026.
Certification Matchups: the published facts, strengths and weak spots of 33 certifications, side by side.
Our Fabric Analytics Engineer boot camp covers all three DP-600 domains in four days of live, instructor-led training, online or in person. You get Official Microsoft Courseware, hosted Fabric workspaces for the labs, practice questions mapped to the domains, your $165 exam voucher, and an exam retake included.
Where DP-600 fits on the Microsoft path, how exam day and scoring work, and where Fabric shows up in the market.
The full Microsoft map, from fundamentals to expert, with role-by-role picks. Its data analyst path pairs PL-300 for Power BI work with DP-600 for Microsoft Fabric.
Which Microsoft exams people actually sit and budget for this year, what each one costs, and why PL-300 is the pick for anyone writing reports executives read.
MCSA is gone. This guide maps each old MCSA track to its modern replacement, including PL-300 for BI reporting and the Fabric Data Engineer Associate for analytics platform work.
From MCSE to role-based exams to AI-era credentials. Why associate certifications now expire every year, and why a free annual check beats a paid recertification exam.
Check-in, breaks, online proctoring and retake windows compared across vendors, including Microsoft's 24-hour first retake and its waiver rule for connection failures.
How to read a practice test result, and why Microsoft's 700 on a 1 to 1,000 scale is not the same as getting 70 percent of the questions right.
Which enterprises run on Azure and what they run there, including the data and analytics work built on Synapse, Fabric, Databricks and Power BI.
The DP-600 exam is organized into three domains, each carrying its own weight. Prepare data is by far the heaviest at 45 to 50 percent, close to half the exam. If you come from Power BI, much of the semantic model domain will feel familiar, so the SQL and KQL objectives in Prepare data are where extra study time pays off. Click any domain for what it covers.
Security and governance first: workspace-level and item-level access controls, row-level, column-level, object-level and file-level access control, sensitivity labels and item endorsement. Then the development lifecycle, with version control for a workspace, Power BI Desktop projects (.pbip), deployment pipelines, impact analysis of downstream dependencies from lakehouses, warehouses, dataflows and semantic models, deploying semantic models through the XMLA endpoint, and reusable assets such as Power BI template (.pbit) files, Power BI data source (.pbids) files and shared semantic models.
The heaviest domain, close to half the exam. Getting data covers data connections, discovery through the OneLake catalog and Real-Time hub, choosing between data stores, and OneLake integration for Eventhouse and semantic models. Transforming data covers views, functions and stored procedures, star schemas for a lakehouse or warehouse, denormalizing, aggregating, merging and joining, and fixing duplicates, missing data, null values and column data types. Querying covers selecting, filtering and aggregating data with the Visual query editor, SQL, KQL and DAX.
Designing and building models: choosing a storage mode, star schemas, bridge tables and many-to-many relationships, DAX variables and functions (iterators, table filtering, windowing and information functions), calculation groups, dynamic format strings, field parameters, the large semantic model storage format and composite models. Optimizing enterprise-scale models covers query and report visual performance, DAX performance, Direct Lake fallback and refresh behavior, Direct Lake on OneLake versus Direct Lake on SQL analytics endpoint, and incremental refresh.
Domains and weights reflect the Microsoft DP-600 skills-measured outline as of October 19, 2026, which made minor changes to the Query and analyze data objectives. Microsoft updates the English exam first and localized versions about eight weeks later, so confirm the current outline on Microsoft Learn before scheduling.
The questions candidates ask most often when researching the Microsoft Fabric Analytics Engineer certification.
The Microsoft Certified: Fabric Analytics Engineer Associate, earned by passing exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric, is Microsoft's role-based certification for people who design, create and manage analytics assets such as semantic models, warehouses and lakehouses in Microsoft Fabric. It covers security and governance, the development lifecycle, data preparation, and semantic model design and optimization.
The current exam is DP-600, and its skills-measured outline took effect on October 19, 2026. That update made minor changes to the Query and analyze data objectives and left the audience profile unchanged. As of October 2026, DP-600 is not on Microsoft's list of exams scheduled to retire, and no replacement has been announced.
No. DP-600 has no formal prerequisites, so you can register and sit the exam without holding PL-300, DP-900 or any other certification first. Microsoft does expect subject matter expertise with semantic models, warehouses and lakehouses, and the ability to query and analyze data with SQL, KQL and DAX.
The three domains are Maintain a data analytics solution (25 to 30 percent), Prepare data (45 to 50 percent), and Implement and manage semantic models (25 to 30 percent). Prepare data is close to half the exam. It covers getting, transforming and querying data with SQL, KQL, DAX and the Visual query editor.
Microsoft does not publish a question count for DP-600. Its general guidance is that most Microsoft certification exams have 40 to 60 questions, and the number can vary. You have 100 minutes for the exam, and Microsoft suggests setting aside 120 minutes of seat time for the instructions and the candidate agreement. Microsoft doesn't list question types for individual exams, but its exam sandbox shows the formats you may see, including multiple choice, drag and drop, hot area, build list and case studies.
You need 700 on a scale of 1 to 1,000 to pass. Microsoft uses scaled scoring, so 700 does not mean 70 percent correct. The passing score takes the difficulty of the questions into account, which is why a raw percentage won't tell you whether you passed.
As of October 2026, the DP-600 exam costs $165 USD in the United States. Microsoft sets the price by the country or region where the exam is proctored, and you schedule it through Pearson VUE. Training Camp's Fabric Analytics Engineer boot camp includes the $165 exam voucher and an exam retake in the course price.
No DoD 8140 mapping is claimed for it. Microsoft doesn't list DP-600 against a DoD 8140 work role, so don't count on it to satisfy a cyber-coded position requirement on its own. Its value is with employers that build analytics on Microsoft Fabric and Power BI. See the full DoD 8140 work role paths.
The Fabric Analytics Engineer Associate is valid for one year. You renew it free by passing an unproctored, open-book online assessment on Microsoft Learn before it expires. The renewal window opens six months before your expiration date, and there is no limit on renewal attempts. If the certification lapses, you have to pass DP-600 again.
DP-600 maps to roles such as Analytics Engineer, BI Developer, Power BI Developer, Data Warehouse Developer, Senior Data Analyst and Analytics Consultant. These are the people who prepare data in Fabric and build the semantic models that reports and dashboards run on.
Take PL-300 if your job is building Power BI reports and models for business users. It covers preparing, modeling and visualizing data and managing Power BI, with Power Query and DAX. Take DP-600 if you also work with lakehouses, warehouses, and Fabric security and deployment, and you need SQL and KQL alongside DAX. Neither is a prerequisite for the other, so pick the one that matches the work you do now.
Both are Microsoft Fabric associate certifications with a 100-minute exam, a $165 fee and a 700 passing score. DP-700, the Fabric Data Engineer, focuses on ingesting, transforming and orchestrating data with SQL, PySpark and KQL. DP-600 focuses on preparing that data for analysis and building the semantic models on top, with SQL, KQL and DAX. Look at where your week goes. Pipelines and Spark notebooks point to DP-700, and models, measures and reports point to DP-600.
DP-600 is an associate-level exam that rewards hands-on Fabric and Power BI experience. Much of the difficulty is breadth. You switch between SQL, KQL and DAX, and several objectives ask you to choose between options, such as data stores, storage modes, and Direct Lake on OneLake versus Direct Lake on SQL analytics endpoint. Time spent building real lakehouses and semantic models makes the biggest difference.
For anyone building analytics on Microsoft Fabric or moving Power BI work into Fabric, yes. It is the Microsoft credential written for the analytics engineer role, it renews free each year, and the October 2026 outline update shows Microsoft is keeping it current. The case is weaker if you only build reports, where PL-300 fits better, or if your data platform isn't Microsoft.
Whether you're weighing the certification, planning a Fabric skills path, or arranging analytics training for a team, tell us where you are and we'll help you map out the right path.