DP-700 practice questionsMicrosoft certification practice
← Interview & exam prep
Microsoft certification practice

DP-700 practice questions

12 exam-style questions for DP-700 — Fabric Data 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

  • Implement and manage an analytics solution
  • Ingest and transform data
  • Monitor and optimize an analytics solution
Official DP-700 exam page ↗

Beginner 6 questions

1To ingest and orchestrate data movement on a schedule in Fabric, you use a…

  1. Slicer
  2. Report
  3. Data pipeline (Data Factory)
  4. Bookmark
  5. Semantic model
Show answerHide answer

C · Data pipeline (Data Factory) Data pipelines schedule and orchestrate ingestion and movement.

2To process large datasets with Spark in Fabric, you write code in a…

  1. Dashboard
  2. Slicer
  3. Notebook
  4. Measure
  5. Report
Show answerHide answer

C · Notebook Notebooks run Spark for scalable data engineering.

3The open table format underpinning Fabric Lakehouse tables is…

  1. XLSX
  2. CSV
  3. A proprietary format
  4. XML
  5. Delta Lake (Parquet + transaction log)
Show answerHide answer

E · Delta Lake (Parquet + transaction log) Fabric tables are Delta (Parquet data + a transaction log).

4For low-latency, continuous event data in Fabric you use…

  1. A Report
  2. Real-Time Intelligence / Eventstream
  3. A Warehouse
  4. A bookmark
  5. A Dataflow
Show answerHide answer

B · Real-Time Intelligence / Eventstream Real-Time Intelligence (Eventstream/KQL) handles streaming events.

5Loading only new or changed source rows on each run is called…

  1. Truncate and load
  2. Full reload
  3. Caching
  4. Incremental load
  5. Snapshotting
Show answerHide answer

D · Incremental load Incremental loading processes just the delta, saving time and cost.

6In a medallion architecture, raw ingested data lands in the…

  1. Gold layer
  2. Bronze layer
  3. Warehouse
  4. Silver layer
  5. Serving layer
Show answerHide answer

B · Bronze layer Bronze holds the raw, as-ingested data.

Intermediate 6 questions

7Which technique streams inserts, updates and deletes from a source database into Fabric?

  1. Full export nightly
  2. Manual copy
  3. Screenshots
  4. Caching
  5. Change Data Capture (CDC)
Show answerHide answer

E · Change Data Capture (CDC) CDC captures row-level changes to keep downstream in sync.

8To make a pipeline safe to re-run without creating duplicates, you design it to be…

  1. Append-only blindly
  2. Manual
  3. Random
  4. Idempotent (keyed upserts)
  5. Volatile
Show answerHide answer

D · Idempotent (keyed upserts) Idempotent, keyed upserts let retries run without double-loading.

9To query a real-time (KQL) dataset in Fabric, you use…

  1. DAX
  2. MDX
  3. M
  4. VBA
  5. KQL (Kusto Query Language)
Show answerHide answer

E · KQL (Kusto Query Language) Real-Time Intelligence datasets are queried with KQL.

10Partitioning large Delta tables by date primarily improves…

  1. Storage cost only
  2. Schema enforcement
  3. Security
  4. Row uniqueness
  5. Query performance via partition pruning
Show answerHide answer

E · Query performance via partition pruning Pruning lets queries scan only the relevant partitions.

11To monitor pipeline runs, durations and failures in Fabric, you use the…

  1. Slicer
  2. Report view
  3. Model view
  4. Monitoring hub
  5. Gateway
Show answerHide answer

D · Monitoring hub The Monitoring hub tracks runs and surfaces failures.

12Spark job performance often improves by reducing…

  1. The number of columns shown
  2. The partition count to one
  3. The schema
  4. Data shuffles and many small files
  5. The cluster size only
Show answerHide answer

D · Data shuffles and many small files Excessive shuffles and small files are common Spark bottlenecks.

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