← Interview & exam prep
Microsoft certification practice
DP-600 practice questions
12 exam-style questions for DP-600 — Fabric Analytics Engineer, each with the correct answer and why. Then take a timed practice test that also draws on the related skill banks.
12 questionsBeginner 6 · Intermediate 6Answers + explanations
Skills measured
- Maintain a data analytics solution
- Prepare and serve data
- Implement and manage semantic models
Official DP-600 exam page ↗
Beginner 6 questions
1You need files, Delta tables and a read-only SQL endpoint in one Fabric item. You create a…
- Report
- Warehouse
- Dataflow
- Lakehouse
- Notebook
Show answerHide answer
D · Lakehouse A Lakehouse combines file storage, Delta tables and a read-only SQL analytics endpoint.
2You need full T-SQL with read/write and multi-table transactions in Fabric. You use a…
- Notebook
- Report
- Lakehouse
- Warehouse
- Dataflow
Show answerHide answer
D · Warehouse The Fabric Warehouse is the full T-SQL, read/write engine.
3For low-code, repeatable transformation writing to a Lakehouse, you use…
- A DAX measure
- A Notebook
- Dataflows Gen2
- A Report
- A slicer
Show answerHide answer
C · Dataflows Gen2 Dataflows Gen2 provide low-code transforms with output destinations.
4Which storage mode does a default Lakehouse semantic model use for near-import speed with no refresh copy?
- Composite
- Dual
- DirectQuery
- Import
- Direct Lake
Show answerHide answer
E · Direct Lake Fabric auto-creates a Direct Lake semantic model over Lakehouse tables.
5To develop Spark/PySpark transformations interactively in Fabric, you open a…
- Notebook
- Report
- Warehouse
- Pipeline
- Dataflow
Show answerHide answer
A · Notebook Notebooks run Spark code (PySpark/Scala/SQL) in Fabric.
6To orchestrate scheduled, multi-activity data movement in Fabric, you build a…
- Data pipeline
- Report
- Measure
- Bookmark
- Semantic model
Show answerHide answer
A · Data pipeline Data pipelines (Data Factory) orchestrate multi-step workflows.
Intermediate 6 questions
7To reference data in ADLS Gen2 or Amazon S3 from OneLake without copying it, you create a…
- Shortcut
- Dataflow
- Pipeline
- Report
- Warehouse
Show answerHide answer
A · Shortcut Shortcuts virtualize external data into OneLake in place.
8To let Tabular Editor read and write your Fabric semantic model, you use the…
- SQL endpoint
- REST API only
- Dataflow
- Gateway
- XMLA endpoint
Show answerHide answer
E · XMLA endpoint The XMLA endpoint exposes the model to external tools for read/write.
9Which write-time optimization reorders Parquet to speed Direct Lake / VertiPaq reads?
- Partition pruning
- Compression only
- Caching
- V-Order
- Indexing
Show answerHide answer
D · V-Order V-Order rewrites Parquet for faster columnar reads.
10To restrict which rows each user sees in a Direct Lake semantic model, you implement…
- A bookmark
- Object-level security only
- Row-level security (RLS)
- A pipeline
- A shortcut
Show answerHide answer
C · Row-level security (RLS) RLS defined in the model filters rows per user.
11In a medallion architecture, the curated 'serving' layer is called…
- Raw
- Gold
- Platinum
- Bronze
- Silver
Show answerHide answer
B · Gold Bronze (raw) → Silver (cleaned) → Gold (curated/serving).
12To give report authors a governed, reusable set of measures, you publish a…
- Certified/shared semantic model
- Screenshot
- Dashboard only
- Gateway
- Personal PBIX
Show answerHide answer
A · Certified/shared semantic model A shared, endorsed semantic model centralizes trusted logic.
What changed lately? Latest Microsoft Fabric news, releases & questions →
More microsoft certification practice