Implementing a Lakehouse with Microsoft Fabric (DP-601) (M-DP601)

Module 1: Introduction to end-to-end analytics using Microsoft Fabric

• • Describe end-to-end analytics in Microsoft Fabric

Module 2: Get started with lakehouses in Microsoft Fabric

• • Describe core features and capabilities of lakehouses in Microsoft Fabric
• • Create a lakehouse
• • Ingest data into files and tables in a lakehouse
• • Query lakehouse tables with SQL

Module 3: Use Apache Spark in Microsoft Fabric

• • Configure Spark in a Microsoft Fabric workspace
• • Identify suitable scenarios for Spark notebooks and Spark jobs
• • Use Spark dataframes to analyze and transform data
• • Use Spark SQL to query data in tables and views
• • Visualize data in a Spark notebook

Module 4: Work with Delta Lake tables in Microsoft Fabric

• • Understand Delta Lake and delta tables in Microsoft Fabric
• • Create and manage delta tables using Spark
• • Use Spark to query and transform data in delta tables
• • Use delta tables with Spark structured streaming

Module 5: Ingest Data with Dataflows Gen2 in Microsoft Fabric

• • Describe Dataflow capabilities in Microsoft Fabric
• • Create Dataflow solutions to ingest and transform data
• • Include a Dataflow in a pipeline

Module 6: Use Data Factory pipelines in Microsoft Fabric

• • Describe pipeline capabilities in Microsoft Fabric
• • Use the Copy Data activity in a pipeline
• • Create pipelines based on predefined templates
• • Run and monitor pipelines

Module 7: Organize a Fabric lakehouse using medallion architecture design

• • Describe the principles of using the medallion architecture in data management.
• • Apply the medallion architecture framework within the Microsoft Fabric environment.
• • Analyze data stored in the lakehouse using DirectLake in Power BI.
• • Describe best practices for ensuring the security and governance of data stored in the medallion architecture.