DP-700: Microsoft Fabric Data Engineer Associate – Course Outline

1. Introduction to Microsoft Fabric

• Overview of Microsoft Fabric
• Key components: Data Factory, Synapse, Power BI, Data Activator
• Understanding the unified data platform
• Role of a Data Engineer in Microsoft Fabric

2. Ingesting and Transforming Data with Dataflows Gen2

• Ingesting data using Dataflows Gen2
• Transforming data using Power Query
• Data pipeline concepts and activities
• Managing and monitoring pipelines

3. Managing Data in OneLake and Lakehouses

• Introduction to OneLake
• Creating and managing lakehouses
• Working with files and tables
• Partitioning, indexing, and optimization

4. Data Engineering with Apache Spark in Fabric

• Introduction to Spark in Microsoft Fabric
• Writing PySpark notebooks
• Data wrangling and processing with Spark
• Managing compute and performance

5. Building Data Pipelines with Data Factory

• Create and manage pipelines in Fabric
• Mapping and wrangling data flows
• Pipeline triggers and dependencies
• Monitoring and troubleshooting pipelines

6. Creating and Managing Data Warehouses

• Data warehouse vs lakehouse concepts
• Designing a Fabric data warehouse
• Ingesting data into warehouses
• Querying with T‑SQL in Fabric

7. Designing End-to-End Data Solutions

• Integrating lakehouses, data warehouses, and Power BI
• Orchestrating pipelines and activities
• Real-time analytics and alerting with Data Activator
• Best practices for performance and scalability

8. Security, Governance & Monitoring

• Data access and workspace roles
• Row-level and column-level security
• Monitoring Fabric workloads and diagnostics
• Integration with Microsoft Purview

9. Data Governance & Compliance

• Implement data classification and labeling
• Secure sensitive data with RLS & CLS
• Integrate with Purview for governance
• Track lineage and auditing within workspaces

10. Automation with Fabric Pipelines

• Automate end-to-end data workflows
• Schedule and trigger pipelines
• Use Fabric API & Logic Apps for integration
• Error handling and retry strategies