Fabric DP-700 glossary of warehouse design, pipelines, ingestion, transformation, and governance terms.
Use this glossary when Microsoft Certified: Fabric Data Engineer Associate (DP-700) terms start to blur together. The goal is practical recognition, not encyclopedia coverage.
| Term | Exam meaning |
|---|---|
| OneLake | Fabric data lake foundation for storing and sharing organizational data. |
| Lakehouse | Fabric workload combining data lake storage with analytical tables and processing. |
| Warehouse | Relational analytics store optimized for SQL-based warehousing scenarios. |
| Dataflow | Low-code data preparation and transformation workflow. |
| Pipeline | Orchestration workflow that moves or transforms data across steps. |
| Delta table | Table format supporting reliable lakehouse storage, transactions, and versioned data behavior. |
| Pair | How to separate them |
|---|---|
| Ingestion and transformation vs Lakehouse and warehouse design | Ask which layer the scenario is testing, then match the answer to that layer only. |
| Control vs evidence | A control changes behavior; evidence proves behavior or supports investigation. |
| Managed service vs custom build | Managed services win for lower operational effort unless the requirement needs unsupported customization. |
| Prevention vs detection | Prevention blocks or reduces a bad event; detection finds or reports that it happened. |
Do not memorize terms in isolation. For each term, write one scenario where it is the best answer, one scenario where it is a distractor, and one signal that proves it worked.