DP-600 exam tips: how to answer and manage time
The most useful DP-600 exam tip is to find the one requirement in a scenario that decides the answer: “no copy of the data”, “must roll back”, “never fall back to DirectQuery”, “only this one item”. Most questions have two plausible options, and a single constraint separates them. This page collects the habits that help most in 100 minutes.
Read the constraint first
Read the last sentence of a scenario before the body. It tells you what you must produce. Then skim the body for constraints: latency, language, security level, cost, who owns the data. Underline words such as “without copying”, “least effort”, “automatically”, “minimise” and “must not”. Eliminate every option that breaks one.
Match the keyword to the Fabric item
| If the scenario says | Think |
|---|---|
| Streaming, telemetry, KQL, time window | Eventhouse |
| T-SQL updates, transactions, stored procedures | Warehouse |
| Files, Spark, notebooks, Delta | Lakehouse |
| No copy, one copy of the data | Shortcut (or mirroring for databases) |
| Different data source per stage | Deployment rule |
| One item only | Item-level sharing |
| Users see only their rows | Row-level security |
| Same time calculation on many measures | Calculation group |
| Switch field shown by the user | Field parameter |
| Refresh only recent data | Incremental refresh |
| Predictable behaviour, no DirectQuery fallback | Direct Lake on OneLake |
Handling code questions
Microsoft’s audience profile names SQL, KQL and DAX, so expect snippets with gaps.
- T-SQL. Check clause order and the difference between
WHERE(rows) andHAVING(groups). For duplicates thinkROW_NUMBER(). - KQL. Operators are connected with the pipe and read top to bottom.
wherefilters,summarizeaggregates,projectselects columns. - DAX. Ask what the filter context is.
CALCULATEchanges it, an iterator evaluates row by row, and a variable is computed once.
If you are unsure, pick the option that is valid for the language and fits the requirement, then flag the question and return.
Time management
You have 100 minutes and the question count is not published. Work through quickly, answer what you know, mark the rest and come back. If there is a case study, read its requirements once, and use its tabs rather than re-reading everything for every question. Do not leave questions unanswered; make your best choice on every item before time ends.
Series of yes/no statements about one scenario often cannot be revisited after you move on, so settle each one before continuing.
Common traps
- Mixing up lakehouse and SQL analytics endpoint. The endpoint is for T-SQL reads; you cannot update tables through it.
- Assuming a workspace role honours data-level security. Higher roles can bypass many restrictions.
- Confusing endorsement with access. Certified does not grant or deny anything.
- Confusing field parameters with calculation groups. One switches fields, the other rewrites calculations.
- Forgetting framing. Direct Lake refresh updates metadata; it is not a data copy.
- Using DirectQuery by default. It is a trade-off, not an upgrade.
Preparation habits that help
- Build everything at least once in a real workspace.
- Do the free practice assessment early and late.
- Keep a mistake log by domain; the cheat sheet is a good template.
- Read the current documentation for features that are new; Microsoft says preview features may appear if they are commonly used.
- Check the outline update: what changed in October 2026.
The day itself
Test your equipment if you take it online, bring valid identification, and read the rules in the exam day guide. Sleep matters more than another hour of revision. If you fail, you can retake after 24 hours, but use the score report to target the weakest domain first.