← 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
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…
- Slicer
- Report
- Data pipeline (Data Factory)
- Bookmark
- 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…
- Dashboard
- Slicer
- Notebook
- Measure
- Report
Show answerHide answer
C · Notebook Notebooks run Spark for scalable data engineering.
3The open table format underpinning Fabric Lakehouse tables is…
- XLSX
- CSV
- A proprietary format
- XML
- 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…
- A Report
- Real-Time Intelligence / Eventstream
- A Warehouse
- A bookmark
- 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…
- Truncate and load
- Full reload
- Caching
- Incremental load
- 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…
- Gold layer
- Bronze layer
- Warehouse
- Silver layer
- 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?
- Full export nightly
- Manual copy
- Screenshots
- Caching
- 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…
- Append-only blindly
- Manual
- Random
- Idempotent (keyed upserts)
- 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…
- DAX
- MDX
- M
- VBA
- 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…
- Storage cost only
- Schema enforcement
- Security
- Row uniqueness
- 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…
- Slicer
- Report view
- Model view
- Monitoring hub
- Gateway
Show answerHide answer
D · Monitoring hub The Monitoring hub tracks runs and surfaces failures.
12Spark job performance often improves by reducing…
- The number of columns shown
- The partition count to one
- The schema
- Data shuffles and many small files
- 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 →
More microsoft certification practice