FREE DP-600 Exam Guide 2026: Pass Microsoft Fabric Analytics Engineer (Direct Lake, DAX, Semantic Models)
Video
A Fabric workspace needs a user who can create and edit reports and semantic models but must not manage workspace membership or settings. Which workspace role should you assign?
Dp600 Maintain Analytics Solution
Question · Easy
Star schema: a city pop love song to a fact table
Short
Free 2026 DP-600 study guide: Microsoft Fabric Analytics Engineer Associate exam format, $165 fee, 700/1000 passing score, verified July 2026 skills (Maintain 25-30%, Prepare Data 45-50%, Semantic Models 25-30%), and 8-12 week study plan.
Blog
What is a Fabric workspace and what boundary does it define?
Fabric Platform & Workspaces
Flashcard
You need to let an executive review one certified semantic model without giving access to every item in the workspace. What is the best approach?
Question · Medium
Table format made of Parquet data files plus a file-based transaction log, used for all data stored in Fabric.
Get data
Guess the Term
DP-600 Exam Overview & Fabric Foundations
1.1 What DP-600 Certifies
Study guide
Cheat sheet
A sales semantic model must show each regional manager only the rows for that manager's territory. Which security technique should you implement?
Read the clue and guess the term in 6 tries.
Game
Order the four Fabric workspace roles from most to least privileged.
Finance analysts should be able to query an employee table but must never see the Salary column. Which control best fits this requirement?
Engine that is the lakehouse's primary development tool, supporting Python, Scala, R, and SQL.
A model contains a confidential table of executive bonuses that should be completely hidden from most report authors. Which control should you use?
Workspace role vs single-item access — which should you use first when sharing?
A shared lakehouse contains a folder of HR export files that only the HR team should read. Which control maps most directly to that requirement?
Kind of schema that classifies model tables as dimension or fact, widely adopted by relational data warehouses.
Transform data
1.2 Exam Logistics & Blueprint
A compliance team wants users to see that a warehouse contains confidential data and have downstream controls respect that classification. What should you apply?
Swap tiles to line up three of the same term.
Term Match
What is a Fabric domain (governance), and does it grant data access?
A semantic model has been formally reviewed and approved as the organization's authoritative source for finance reporting. Which endorsement status is most appropriate?
T-SQL statement that inserts, updates, or deletes rows in a target table based on a join with a source table.
Which workspace role is intended for users who only need read-only access to reports and other published content?
RLS vs CLS vs OLS — what does each restrict?
Security & Access Control
A data platform lead must manage workspace settings, control access, and administer every item in a Fabric workspace. Which role should the lead have?
Value that means unknown — not empty, not zero — and never equals another one of itself.
1.3 Microsoft Fabric Platform Fundamentals
An executive should see a single report but should not browse the rest of the workspace contents. What is the best design?
Flip two cards at a time to find matching terms.
Term Pairs
Does a sensitivity label control who can access data?
A semantic model already uses workspace permissions, but users still need to be restricted to their own regional rows. Which additional control is required?
Transact-SQL function that converts an expression to another data type using the form (expression AS data_type), without CONVERT's style argument.
You must ensure a report exported from a sensitive semantic model carries clear classification guidance for users and downstream tools. Which Fabric capability helps most?
What is OneLake file/folder security used for?
A Fabric development team wants report and model files stored in a text-based project format so they can use Git branching and pull requests. Which artifact format should they adopt?
Standard behind the single engine that both a Fabric warehouse and a lakehouse use, whose dialect reads Delta tables in the lakehouse's read-only endpoint.
Filter and aggregate
Maintain a Data Analytics Solution (25-30%)
2.1 Workspace & Item Security
You want to distribute a reusable file that opens Power BI Desktop already pointed at a specific data source, but without shipping a full report. Which file type should you create?
Find five hidden terms in a grid of letters.
Term Search
List the access layers DP-600 expects you to reason about, broad to fine.
Which reusable asset should you use when you want to provide a starter report and model structure without including the imported data itself?
Read-only, pipe-based syntax for exploring telemetry, metrics, and logs in a Fabric eventhouse.
A Fabric workspace needs to participate in a Git-based development lifecycle. What should you configure first?
Loading more…
