DP-600 practice questionsMicrosoft certification practice
← 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
Take it as a timed test
Free PDF
All 389 questions & answers, in one file

DAX, Excel, Power BI, Fabric, certification practice and analyst interviews — every answer with the reason behind it. Print it, study it offline.

Instant download, plus the free Tuesday briefing. Unsubscribe in one click.

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…

  1. Report
  2. Warehouse
  3. Dataflow
  4. Lakehouse
  5. 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…

  1. Notebook
  2. Report
  3. Lakehouse
  4. Warehouse
  5. 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…

  1. A DAX measure
  2. A Notebook
  3. Dataflows Gen2
  4. A Report
  5. 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?

  1. Composite
  2. Dual
  3. DirectQuery
  4. Import
  5. 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…

  1. Notebook
  2. Report
  3. Warehouse
  4. Pipeline
  5. 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…

  1. Data pipeline
  2. Report
  3. Measure
  4. Bookmark
  5. 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…

  1. Shortcut
  2. Dataflow
  3. Pipeline
  4. Report
  5. 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…

  1. SQL endpoint
  2. REST API only
  3. Dataflow
  4. Gateway
  5. 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?

  1. Partition pruning
  2. Compression only
  3. Caching
  4. V-Order
  5. 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…

  1. A bookmark
  2. Object-level security only
  3. Row-level security (RLS)
  4. A pipeline
  5. 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…

  1. Raw
  2. Gold
  3. Platinum
  4. Bronze
  5. 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…

  1. Certified/shared semantic model
  2. Screenshot
  3. Dashboard only
  4. Gateway
  5. 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 →

Coming soon $19 one-time · early-access price
Prep Pro: full mock exams
  • Full-length, timed mock exams in the real PL-300, DP-600 and MO-201 format
  • Score breakdown by skill, with a study plan for your weak spots
  • New questions every month, written against the current exam outline

No payment now. We'll email you once, when it opens.

More microsoft certification practice