Microsoft Fabric Data Engineer (DP-700T00)

Reference : DP-700T00

Duration : 4 days

This course covers methods and practices to implement data engineering solutions by using Microsoft Fabric. Students will learn how to design and develop effective data loading patterns, data architectures, and orchestration processes. Objectives for this course include ingesting and transforming data and securing, managing, and monitoring data engineering solutions. This course is designed for experienced data professionals skilled at data integration and orchestration, such as those with the DP-203: Azure Data Engineer certification.

Audience

The audience for this course is data professionals with experience in data extraction, transformation, and loading. DP-700 is designed for professionals who need to create and deploy data engineering solutions using Microsoft Fabric for enterprise-scale data analytics. Learners should also have experience at manipulating and transforming data with one of the following programming languages: Structured Query Language (SQL), PySpark, or Kusto Query Language (KQL).

Prerequisites

• Experience with Power BI (creating reports and dashboards)

• Basic understanding of data warehouse concepts

• Familiarity with SQL fundamentals

• Basic knowledge of cloud computing concepts

• Experience in data analysis

• Experience working with relational databases

• Basic understanding of data modeling

• Familiarity with Microsoft Excel

Objectives

• Understand the concepts of end-to-end data analytics with Microsoft Fabric.
• Explore and implement data ingestion solutions.
• Use Apache Spark and manage Delta Lake tables in Fabric environments.
• Orchestrate pipeline processes and optimize data flows.
• Design data architectures, such as medallion architecture, with Fabric.
• Implement real-time analytics and event streams.
• Deploy and manage Fabric data warehouses, including loading, monitoring, and securing data.
• Integrate and automate CI/CD processes with Fabric.
• Configure and administer data security and permissions.
• Use monitoring tools to optimize resource utilization in Fabric.

Contents

Learning Path 1: Explore end-to-end analytics with Microsoft Fabric

• Describe end-to-end analytics in Microsoft Fabric
• Understand data teams and roles that use Fabric
• Describe how to enable and use Fabric

Learning Path 2: Get started with lakehouses in Microsoft Fabric

• Describe end-to-end analytics in Microsoft Fabric
• Understand data teams and roles that use Fabric
• Describe how to enable and use Fabric

Learning Path 3: Use Apache Spark in Microsoft Fabric

• Describe end-to-end analytics in Microsoft Fabric
• Understand data teams and roles that use Fabric
• Describe how to enable and use Fabric

Learning Path 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
• Optimize delta tables
• Use delta tables with Spark structured streaming

Learning Path 5: Ingest data with Dataflows (Gen2) in Microsoft Fabric

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

Learning Path 6: Orchestrate processes and data movement

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

Learning Path 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.
• Analyze data stored in the lakehouse using DirectLake in Power BI.

Learning Path 8: Get started with Real-Time Intelligence in Microsoft Fabric

• Understand real-time data analytics concepts
• Explore core components of Real-Time Intelligence in Microsoft Fabric

Learning Path 9: Use real time Eventstreams in Microsoft Fabric

• Establish source and destinations in Microsoft Fabric Eventstreams.
• Capture, transform, and route data using Microsoft Fabric Eventstreams.

Learning Path 10: Work with real-time data in a Microsoft Fabric eventhouse

• Create an eventhouse in Microsoft Fabric
• Query real-time data by using Kusto Query Language (KQL)
• Create materialized views and stored functions in a KQL database

Learning Path 11: Get started with data warehouses in Microsoft Fabric

• Describe data warehouses in Fabric.
• Understand a data warehouse vs a data Lakehouse.
• Work with data warehouses in Fabric.
• Create and manage fact tables and dimensions within a data warehouse.

Learning Path 12: Load data into a Microsoft Fabric data warehouse

• Strategies to load data into a data warehouse in Microsoft Fabric.
• Build a data pipeline to load a warehouse in Microsoft Fabric.
• Load data in a warehouse using T-SQL.
• Load and transform data with dataflow (Gen 2).

Learning Path 13: Monitor a Microsoft Fabric data warehouse

• Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
• Monitor current activity in the data warehouse with dynamic management views.
• Monitor querying trends with query insights views.

Learning Path 14: Secure a Microsoft Fabric data warehouse

• Learn the concepts of securing a data warehouse in Microsoft Fabric.
• Implement dynamic data masking, row-level security, and column-level security.
• Configure granular permissions using T-SQL.

Learning Path 15: Implement continuous integration/continuous delivery

(CI/CD)

• Define CI/CD and describe how it's implemented in Fabric.
• Implement version control and Git integration.
• Use deployment pipelines to automate the deployment process.
• Automate CI/CD using Fabric APIs.

Learning Path 16: Monitor activities in Microsoft Fabric

• Apply monitoring concepts to Microsoft Fabric.
• Use Monitoring Hub in Microsoft Fabric.
• Trigger actions using Activator in Microsoft Fabric.

Learning Path 17: Secure data access in Microsoft Fabric

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

Learning Path 18 : Administer Microsoft Fabric

• Describe Fabric admin tasks
• Navigate the admin center
• Manage user access