DP-700: Microsoft Certified Fabric Data Engineer Associate

Discover how Microsoft Fabric unifies data engineering, data lakes, data science, and AI workloads in a single SaaS platform built on one lake for a shared source of truth.

Navigate fabric licensing by detailing storage pay-as-you-go rates, serverless compute capacities, and the tenant-capacity-workspace model, plus pay-as-you-go and reserved pricing and Power BI licensing nuances.

Explore the Microsoft Fabric portal by creating a workspace and a lakehouse. Query data via SQL analytics endpoint, work with delta lake and parquet storage, and leverage Power BI integration.

Explore data analytical engines in Microsoft Fabric, focusing on Apache Spark and the SQL analytics endpoint in the lakehouse, with startup and custom pools and capacity SKUs.

Transform and analyze CSV data in a fabric lake house using Apache Spark and the SQL analytics endpoint, enforcing schema with data frames and saving as Parquet and Delta tables.

Utilize lake house default semantic model on the delta table to build Power BI reports and clustered bar charts, and see how a data warehouse handles complex facts and dimensions.

Explore data lakehouse and one lake in Microsoft Fabric, merging data lake and data warehouse concepts, with delta lake and ACID ensuring reliable, scalable BI and AI workloads.

Discover how OneLake Explorer embeds into your file explorer to reveal Microsoft Fabric workspaces, lake houses, and parquet or delta format tables for quick data viewing.

Learn how Delta tables implement Delta Lake with acid transactions for reliable, open source storage. Distinguish managed and external tables, enable streaming, and optimize writes with vacuum and partitioning.

Engage in a hands-on lab to work with delta tables and optimize writes. Create managed and external tables, partition data, and stream IoT data in a lake house with Spark.

Data warehouses deliver high performance for structured queries and bi reporting. They use simple dimensional models and provide workload isolation when moving the gold layer analytics from the lake house.

Import a delta table from a lake house into a data warehouse, create a fact table, and load 2019 data via stored procedure to support bi, dimensions, and semantic modeling.

Explore semantic models in Microsoft Fabric and Power BI, linking data lakehouse and data warehouse tables to build facts and dimensions for insightful dashboards and BI reports.

Create and connect a semantic model in a data warehouse, linking the trip fact to date, geography, time, and Hackney license dimensions to drive Power BI reports and dashboards.

Learn data warehouse security in Microsoft Fabric, including workspace and item permissions, data protection, dynamic data masking, and row- and column-level controls, using Transact-SQL for granular access.

Engage in a hands-on lab to secure a Microsoft Fabric warehouse by applying dynamic data masking, row-level security, and column-level security through SQL queries and access control.

Monitor your data warehouse activities with dynamic management views and SQL queries in Microsoft Fabric, reviewing connections, sessions, and long-running and frequently run queries.

Understand the medallion architecture in Microsoft Fabric, building bronze, silver, and gold delta tables in a data lakehouse to power BI dashboards and AI and ML workloads.

Implement a medallion architecture in a fabric data lake house, moving a Covid-19 dataset from bronze to silver to gold and building a Power BI dashboard for 2021 aggregates.

Explore data flows and fabric pipelines that transform data in a no-code to low-code ETL, moving from data lake house to data warehouse for analysis and reporting.

Build and publish a data flow that imports Covid data from a GitHub raw URL into a data lake house, then run a pipeline to feed a Power BI dashboard.

Explore real-time intelligence in fabric by ingesting live data from sources such as azure cosmos db into event stream and event house, then build dashboards with kql and activator alerts.

Learn to set up an event stream and event house in Microsoft Fabric, ingest stock data, run KQL queries, build a real-time stock dashboard, and configure an alert activator.

Transform event streams from Azure Event Hub and Azure Cosmos DB change data capture feed, applying data manipulations and delivering to a destination for live dashboards with temporal windows.

Transform data in the event stream by adjusting field types, create a new table in the event house, then apply a group-by with hopping temporal windows to compute sums.

Build real-time dashboards in Microsoft Fabric using event streams and event houses, ingesting bicycle data to create interactive maps and bar charts with base queries and parameter-driven filtering.

Explore the fabric administrator role, including securing data with one lake access control and Purview governance, and configuring workspaces and capacities. Use admin portal, PowerShell, and activator for automation.

Explore secure data access in fabric by applying guardrails at three levels: workspace, individual fabric items, and lakehouse data, with role-based permissions and read/write controls.

Explore CI/CD in Fabric, linking Git version control, deployment pipelines, and Rest APIs to automate moving code from development to staging to production, with low-code and isolated environments.

Connect a git repository to a fabric workspace and deploy notebooks and data flow items through development, testing, and production environments in a no-code ci cd pipeline.

Enroll in the exam cram series to receive rapid two hour weekend revisions for Microsoft certifications, featuring AI901, AB731, AI300, AI103, and DP750.