Training DP-600: Microsoft Fabric Analytics Engineer

The modules below are discussed during the course.

Module 1: Ingest Data with Dataflows Gen2 inMicrosoft Fabric

• Describe Dataflow (Gen2) capabilities
• Create Dataflow (Gen2) solutions
• Include a Dataflow (Gen2) in a pipeline

Module 2: Use Data Factory Pipelines inMicrosoft Fabric

• Describe pipeline capabilities
• Use the Copy Data activity
• Create pipelines based on templates
• Run and monitor pipelines

Module 3: Use Apache Spark in Microsoft Fabric

• Configure Spark in a workspace
• Identify scenarios for Spark notebooks and jobs
• Use Spark dataframes to analyze data
• Use Spark SQL to query data
• Visualize data in a Spark notebook

Module 4: Work with Lakehouses in Microsoft Fabric

• Describe features of lakehouses
• Create a lakehouse
• Ingest data into a lakehouse
• Query lakehouse tables with SQL
• Use medallion architecture principles
• Analyze data with DirectLake in Power BI

Module 5: Work with Delta Lake Tables in Microsoft Fabric

• Understand Delta Lake and delta tables
• Create and manage delta tables with Spark
• Query and transform data in delta tables
• Use delta tables with Spark structured streaming

Module 6: Understand Scalability and OptimizePerformance in Power BI

• Describe scalable data models
• Implement data modeling best practices
• Use large dataset storage format
• Create Power BI model relationships
• Optimize queries with Performance Analyzer
• Troubleshoot DAX performance with DAX Studio
• Optimize data models with Tabular Editor
• Enforce model security with RLS and OLS