Implement Data Engineering Solutions Using Microsoft Fabric DP-700

Module 1Ingest Data with Dataflows Gen2 in Microsoft Fabric

• Understand Dataflows Gen2 in Microsoft Fabric
• Explore Dataflows Gen2 in Microsoft Fabric
• Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
• Module assessment

Module 2Orchestrate processes and data movement with Microsoft Fabric

• Understand pipelines
• Use the Copy Data activity
• Use pipeline templates
• Run and monitor pipelines
• Module assessment

Module 3Use Apache Spark in Microsoft Fabric

• Prepare to use Apache Spark
• Run Spark code
• Work with data in a Spark dataframe
• Work with data using Spark SQL
• Visualize data in a Spark notebook

Module 4Work with real-time data in an Eventhouse in Microsoft Fabric

• Get started with an Eventhouse
• Use KQL effectively
• Materialized views and stored functions
• Module assessment

Module 5Introduction to end-to-end analytics using Microsoft Fabric

• Explore end-to-end analytics with Microsoft Fabric
• Explore data teams and Microsoft Fabric
• Enable and use Microsoft Fabric
• Module assessment

Module 6Get started with lakehouses in Microsoft Fabric

• Explore the Microsoft Fabric lakehouse
• Work with Microsoft Fabric lakehouses
• Explore and transform data in a lakehouse
• Module assessment

Module 7Use Apache Spark in Microsoft Fabric

• Prepare to use Apache Spark
• Run Spark code
• Work with data in a Spark dataframe
• Work with data using Spark SQL
• Visualize data in a Spark notebook
• Module assessment

Module 8Work with Delta Lake tables in Microsoft Fabric

• Understand Delta Lake
• Create delta tables
• Optimize delta tables
• Work with delta tables in Spark
• Use delta tables with streaming data
• Module assessment

Module 9Ingest Data with Dataflows Gen2 in Microsoft Fabric

• Understand Dataflows Gen2 in Microsoft Fabric
• Explore Dataflows Gen2 in Microsoft Fabric
• Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric

Module 10Orchestrate processes and data movement with Microsoft Fabric

• Understand pipelines
• Use the Copy Data activity
• Use pipeline templates
• Run and monitor pipelines
• Module assessment

Module 11Organize a Fabric lakehouse using medallion architecture design

• Describe medallion architecture
• Implement a medallion architecture in Fabric
• Query and report on data in your Fabric lakehouse
• Considerations for managing your lakehouse
• Module assessment

Module 12Get started with Real-Time Intelligence in Microsoft Fabric

• What is real-time data analytics?
• Real-Time Intelligence in Microsoft Fabric
• Ingest and transform real-time data
• Store and query real-time data
• Visualize real-time data
• Automate actions
• Module assessment

Module 13Use Eventstream in Microsoft Fabric

• Components of Eventstream
• Eventstream sources and destinations
• Eventstream transformations
• Module assessment

Module 14Work with real-time data in an Eventhouse in Microsoft Fabric

• Get started with an Eventhouse
• Use KQL effectively
• Materialized views and stored functions

Module 15Create Real-Time Dashboards with Microsoft Fabric

• Get started with real-time dashboards
• Organize and filter dashboard data
• Dashboard management and optimization
• Module assessment

Module 16Use Activator in Microsoft Fabric

• Configure Activator for your data
• Create rules in Activator
• Configure actions in Activator
• Module assessment

Module 17Introduction to end-to-end analytics using Microsoft Fabric

• Explore end-to-end analytics with Microsoft Fabric
• Explore data teams and Microsoft Fabric
• Enable and use Microsoft Fabric
• Module assessment

Module 18Get started with data warehouses in Microsoft Fabric

• Understand data warehouse fundamentals
• Understand data warehouses in Fabric
• Query and transform data
• Prepare data for analysis and reporting
• Secure and monitor your data warehouse
• Module assessment

Module 19Load data into a Microsoft Fabric data warehouse

• Explore data load strategies
• Use data pipelines to load a warehouse
• Load data using T-SQL
• Load and transform data with Dataflow Gen2
• Module assessment

Module 20Query a data warehouse in Microsoft Fabric

• Query data
• Use the SQL query editor
• Explore the visual query editor
• Use client tools to query a warehouse

Module 21Monitor a Microsoft Fabric data warehouse

• Monitor capacity metrics
• Monitor current activity
• Monitor queries
• Module assessment

Module 22Secure a Microsoft Fabric data warehouse

• Explore dynamic data masking
• Implement row-level security
• Implement column-level security
• Configure SQL granular permissions using T-SQL
• Module assessment
• Module 23: Implement continuous integration and continuous delivery (CI/CD) in Microsoft Fabric
• Understand Continuous Integration and Continuous Delivery (CI/CD)
• Implement version control and Git integration
• Implement deployment pipelines
• Automate CI/CD using Fabric APIs
• Module assessment

Module 24Monitor activities in Microsoft Fabric

• Understand monitoring
• Use Microsoft Fabric Monitor Hub
• Take action with Microsoft Fabric Activator
• Module assessment

Module 25Secure data access in Microsoft Fabric

• Understand the Fabric security model
• Configure workspace and item permissions
• Apply granular permissions
• Module assessment

Module 26Administer a Microsoft Fabric environment

• Understand the Fabric Architecture
• Understand the Fabric administrator role
• Manage Fabric security
• Govern data in Fabric

Module 27Use Activator in Microsoft Fabric

• Configure Activator for your data
• Create rules in Activator
• Configure actions in Activator