Study guide
DP-600 study guide
What the exam covers, how much each part weighs and how to study, based on Microsoft’s official study guide.
The exam changes often. Always check the official page before you book it.
About the exam
- Exam name
- Implementing Analytics Solutions Using Microsoft Fabric
- Passing score
- 700 or higher, on a 1 to 1000 scale. It is a scaled score: it does not mean 70% of correct answers.
- Duration
- 100 minutes.
- Languages
- Includes Portuguese (Brazil). English is updated first; other languages about 8 weeks later. If the exam is not available in your language, you can request 30 extra minutes.
- Price
- USD 99 in Brazil. The price varies by the country where you take the exam.
- Renewal
- Yearly and free, through an online assessment on Microsoft Learn (no need to retake the exam).
- If you fail
- You can retake it 24 hours after the first attempt. For later attempts, the waiting time varies.
Candidate profile
Someone with expertise in designing, creating and managing analytical assets such as semantic models, warehouses and lakehouses.
- Prepare and enrich data for analysis
- Secure and maintain analytics assets
- Implement and manage semantic models
You are also expected to query and analyze data with SQL, KQL and DAX.
Domain weights
- Maintain a data analytics solution25–30%
- Prepare data45–50%
- Implement and manage semantic models25–30%
Prepare data is almost half of the exam. People coming from Power BI tend to underestimate this domain. A sensible time split is ~30% / 45% / 25%.
Microsoft states that most questions cover GA features, but the exam may include Preview features if they are commonly used.
Skills measured
The official topics for each domain. Tap a domain to open it.
1Maintain a data analytics solution25–30%11 topics
Implement security and governance
- Workspace-level access controls
- Item-level access controls
- Row-level (RLS), column-level (CLS), object-level and file-level access control
- Apply sensitivity labels to items
- Endorse items (Promoted / Certified)
Official docs:Fabric permission model (opens in a new tab)Row-level security (opens in a new tab)Column-level security (opens in a new tab)Apply sensitivity labels (opens in a new tab)Endorsement (Promoted / Certified) (opens in a new tab)
Maintain the analytics development lifecycle
- 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 through the XMLA endpoint
- Create and update reusable assets: .pbit templates, .pbids data source files and shared semantic models
Official docs:Git integration (opens in a new tab)Power BI Desktop projects (.pbip) (opens in a new tab)Deployment pipelines (opens in a new tab)Impact analysis (opens in a new tab)XMLA endpoint (opens in a new tab)
2Prepare data45–50%15 topics
Get data
- Create a data connection
- Discover data with the OneLake catalog and Real-Time hub
- Ingest or access data as needed
- Choose between different data stores (lakehouse × warehouse × eventhouse)
- Implement OneLake integration for Eventhouse and semantic models
Official docs:Choose a data store (opens in a new tab)OneLake catalog (opens in a new tab)Real-Time hub (opens in a new tab)Eventhouse OneLake availability (opens in a new tab)
Transform data
- Create views, functions and stored procedures
- Enrich data with new columns or tables
- Implement a star schema in a lakehouse or warehouse
- Denormalize, aggregate, merge/join
- Identify and resolve duplicate, missing or null data
- Convert column types and filter
Official docs:Dimensional modeling in Fabric Data Warehouse (opens in a new tab)Dataflow Gen2 (opens in a new tab)
Query and analyze data
- Select, filter and aggregate with the Visual query editor
- ... with SQL
- ... with KQL
- ... with DAX
Official docs:Visual query editor (opens in a new tab)SQL query editor (opens in a new tab)KQL queryset (opens in a new tab)DAX query view (opens in a new tab)
Study tip: answer the same 3 business questions in all 4 languages.
3Implement and manage semantic models25–30%12 topics
Design and build semantic models
- Choose a storage mode
- Implement a star schema in the semantic model
- Relationships, including bridge tables and many-to-many
- Calculations with DAX variables and functions such as iterators, table filtering, windowing and information functions
- Calculation groups, dynamic format strings and field parameters
- Identify use cases for and configure the large semantic model storage format
- Design and build composite models
Official docs:Storage mode (opens in a new tab)Star schema (opens in a new tab)Many-to-many relationships (opens in a new tab)Calculation groups (opens in a new tab)Field parameters (opens in a new tab)Large semantic models (opens in a new tab)Composite models (opens in a new tab)
Optimize enterprise-scale semantic models
- Improve query and report visual performance
- 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
Official docs:Optimization guide for Power BI (opens in a new tab)Performance Analyzer (opens in a new tab)Direct Lake overview (opens in a new tab)Direct Lake: OneLake × SQL (opens in a new tab)Incremental refresh (opens in a new tab)
Direct Lake in 30 seconds
- Direct Lake loads data straight from OneLake, with no import step.
- Direct Lake on SQL: the expression points to the SQL analytics endpoint, which is used to discover schema and security and allows fallback to DirectQuery. Use it when you rely on security rules defined on the SQL analytics endpoint or need the fallback.
- Direct Lake on OneLake: the expression points straight to OneLake storage; it supports composite models.
Direct Lake overview (opens in a new tab)Direct Lake: OneLake × SQL (opens in a new tab)
Study strategy
- Don’t memorize, actually learn. The goal is to be ready for the job and for technical interviews.
- Follow the official Microsoft Learn path for DP-600 (the certification page lists the learning paths).
- Do the hands-on labs from the mslearn-fabric repository, not just the theory.
- Read the official documentation: many questions come from it.
- Use the official Practice Assessment only to validate, not as your main guide.
- Practice on a Fabric trial capacity and document what you learn (e.g. LinkedIn posts).
- Try the exam sandbox before exam day so you don’t learn the interface on the spot.
8-week plan
6 to 8 hours a week, with time split according to each domain’s weight.
- Weeks1–2
Fabric fundamentals and Get data (lakehouse × warehouse × eventhouse, OneLake catalog, Real-Time hub)
Hands-on task: Ingest the same dataset into a lakehouse and a warehouse and compare
Official docs:What is a lakehouse? (opens in a new tab)What is data warehousing? (opens in a new tab)Choose a data store (opens in a new tab)OneLake catalog (opens in a new tab)Real-Time hub (opens in a new tab)
- Weeks3–4
Transform and Query (star schema, views, SQL, KQL, DAX, Visual query editor)
Hands-on task: Model a messy file into a star schema and answer 3 questions in all 4 languages
Official docs:Dimensional modeling (opens in a new tab)Visual query editor (opens in a new tab)SQL query editor (opens in a new tab)KQL queryset (opens in a new tab)DAX query view (opens in a new tab)
- Weeks5–6
Semantic models (storage modes, advanced DAX, calculation groups, Direct Lake, incremental refresh)
Hands-on task: Take a slow report and make it measurably faster
Official docs:Storage mode (opens in a new tab)Calculation groups (opens in a new tab)Direct Lake overview (opens in a new tab)Incremental refresh (opens in a new tab)Performance Analyzer (opens in a new tab)
- Weeks7
Security, governance and lifecycle (RLS/CLS/OLS/file-level, labels, git, .pbip, deployment pipelines, XMLA)
Hands-on task: Set up a workspace with Git + a deployment pipeline
Official docs:Fabric permission model (opens in a new tab)Row-level security (opens in a new tab)Apply sensitivity labels (opens in a new tab)Git integration (opens in a new tab)Deployment pipelines (opens in a new tab)XMLA endpoint (opens in a new tab)
- Weeks8
Practice Assessment, timed mock exam, sandbox, gap review
Hands-on task: Redo (don’t reread) everything that scored below 70%
Official docs:Practice Assessment DP-600 (opens in a new tab)Exam sandbox (opens in a new tab)Study guide DP-600 (opens in a new tab)
DP-600 × DP-700 × PL-300
| Exam | Focus |
|---|---|
| PL-300 | Data analyst in Power BI |
| DP-600 | Analytics engineer: semantic models, star schema, DAX, Direct Lake, analytics governance |
| DP-700 | Data engineer: ingestion, pipelines, transformation, orchestration |
DP-600 and DP-700 share lakehouse and warehouse fundamentals.
Resources and links
- Study guide for Exam DP-600(opens in a new tab)Skills measured, change log and study links
- Microsoft Certified: Fabric Analytics Engineer Associate(opens in a new tab)Certification page
- Practice Assessment DP-600(opens in a new tab)Free official practice test
- Exam sandbox(opens in a new tab)Try the exam interface
- Microsoft Fabric documentation(opens in a new tab)
- Exam Readiness Zone(opens in a new tab)Prep videos
- mslearn-fabric(opens in a new tab)Official hands-on labs
- Understand the Fabric security model(opens in a new tab)
- Govern data in Fabric(opens in a new tab)