Examers.io
ExamsOrganizationsHow it worksPricingHelp & FAQ
Sign inStart free
MICROSOFT

Microsoft Certified:Fabric Data Engineer Associate

DP-700Fabric Data Engineer Associate

The Microsoft Certified: Fabric Data Engineer Associate certification validates your expertise in data loading patterns, data architectures, and orchestration processes. It is designed for data engineers responsible for designing and deploying data engineering solutions. Earning it demonstrates your ability to work with SQL, PySpark, and KQL to transform and manage data effectively.

Practice Free Questions

338 practice questions · Updated 2026-07-21

3Domains
10Objectives
83Concepts
338Questions

DP-700 Curriculum

Every domain, objective, and concept the DP-700 exam measures.

Configure Microsoft Fabric workspace settings

4 concepts · 8 questions
  1. SparkWorkspaceConfiguration
  2. DomainWorkspaceConfiguration
  3. OneLakeWorkspaceConfiguration
  4. ApacheAirflowWorkspaceConfiguration

Implement lifecycle management in Fabric

7 concepts · 39 questions
  1. Version Control Configuration
  2. Branching Strategies
  3. Database Project Implementation
  4. Database Versioning
  5. Deployment Pipeline Creation
  6. Pipeline Configuration
  7. Continuous Integration and Deployment

Configure security and governance

11 concepts · 36 questions
  1. Workspace-Level Access Controls
  2. Item-Level Access Controls
  3. Row-Level Access Controls
  4. Column-Level Access Controls
  5. Object-Level Access Controls
  6. Folder/File-Level Access Controls
  7. Dynamic Data Masking
  8. Sensitivity Labels
  9. Item Endorsement
  10. Microsoft Fabric Audit Logs
  11. OneLake Security Configuration

Orchestrate processes

9 concepts · 39 questions
  1. Dataflow Gen 2 Overview
  2. Pipeline Overview
  3. Notebook Overview
  4. Choosing Orchestration Tools
  5. Schedule Design
  6. Event-Based Triggers
  7. Orchestration Patterns with Notebooks
  8. Orchestration Patterns with Pipelines
  9. Dynamic Expressions in Orchestration

Design and implement loading patterns

7 concepts · 35 questions
  1. Full Data Load Design
  2. Incremental Data Load Design
  3. Full Data Load Implementation
  4. Incremental Data Load Implementation
  5. Dimensional Model Preparation
  6. Streaming Data Loading Pattern Design
  7. Streaming Data Loading Pattern Implementation

Ingest and transform batch data

13 concepts · 48 questions
  1. Data Store Selection
  2. Data Transformation Tool Selection
  3. OneLake Shortcuts Management
  4. Implement Mirroring
  5. Pipeline Data Ingestion
  6. Data Transformation with PySpark
  7. Data Transformation with SQL
  8. Data Transformation with KQL
  9. Data Denormalization
  10. Data Grouping and Aggregation
  11. Handling Duplicate Data
  12. Handling Missing Data
  13. Handling Late-Arriving Data

Ingest and transform streaming data

7 concepts · 25 questions
  1. Streaming Engine Selection
  2. Native Tables vs OneLake Shortcuts
  3. Query Acceleration vs Standard Shortcuts
  4. Eventstreams Processing
  5. Spark Structured Streaming
  6. KQL Data Processing
  7. Windowing Functions Creation

Monitor Fabric items

4 concepts · 18 questions
  1. Data Ingestion Monitoring
  2. Data Transformation Monitoring
  3. Semantic Model Refresh Monitoring
  4. Alert Configuration

Identify and resolve errors

14 concepts · 60 questions
  1. Pipeline Error Identification
  2. Pipeline Error Resolution
  3. Dataflow Gen2 Error Identification
  4. Dataflow Gen2 Error Resolution
  5. Notebook Error Identification
  6. Notebook Error Resolution
  7. Eventhouse Error Identification
  8. Eventhouse Error Resolution
  9. Eventstream Error Identification
  10. Eventstream Error Resolution
  11. T-SQL Error Identification
  12. T-SQL Error Resolution
  13. OneLake Shortcut Error Identification
  14. OneLake Shortcut Error Resolution

Optimize performance

7 concepts · 30 questions
  1. Lakehouse Table Optimization
  2. Pipeline Optimization
  3. Data Warehouse Optimization
  4. Eventstreams Optimization
  5. Eventhouses Optimization
  6. Spark Performance Optimization
  7. Query Performance Optimization
Ready to practice?Test your knowledge with exam-style questions or take an intelligent quiz tailored to your level.
Practice Free Questions

Percentages reflect share of the current practice bank, not official exam weightings — no structured per-skill weight is published for DP-700, so none is invented.