DP-600T00 Microsoft Fabric Analytics Engineer

1 – Introduction to end-to-end analytics using Microsoft Fabric

• Explore end-to-end analytics with Microsoft Fabric
• Data teams and Microsoft Fabric
• Enable and use Microsoft Fabric

2 – Get started with lakehouses in Microsoft Fabric

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

3 – Use 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

4 – Work 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

5 – Orchestrate processes and data movement with Microsoft Fabric

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

6 – Ingest 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

7 – Get 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

8 – Get 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

9 – Get started with data science in Microsoft Fabric

• Understand the data science process
• Explore and process data with Microsoft Fabric
• Train and score models with Microsoft Fabric

10 – Administer a Microsoft Fabric environment

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

11 – Introduction to end-to-end analytics using Microsoft Fabric

• Explore end-to-end analytics with Microsoft Fabric
• Data teams and Microsoft Fabric
• Enable and use Microsoft Fabric

12 – Get 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

13 – Load 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

14 – Query 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

15 – Monitor a Microsoft Fabric data warehouse

• Monitor capacity metrics
• Monitor current activity
• Monitor queries

16 – Secure a Microsoft Fabric data warehouse

• Explore dynamic data masking
• Implement row-level security
• Implement column-level security
• Configure SQL granular permissions using T-SQL

17 – Add measures to Power BI Desktop models

• Create simple measures
• Create compound measures
• Create quick measures
• Compare calculated columns with measures

18 – Design scalable semantic models

• Choose the best storage mode
• Configure semantic models for large data
• Work with relationships
• Write DAX for readability with complex calculations
• Create dynamic calculation elements

19 – Optimize a model for performance in Power BI

• Review performance of measures, relationships, and visuals
• Use variables to improve performance and troubleshooting
• Reduce cardinality
• Optimize DirectQuery models with table level storage
• Create and manage aggregations

20 – Create and manage Power BI assets

• Create reusable Power BI assets
• Manage development lifecycle for Power BI assets
• Use lineage view and endorse data assets
• Manage a Power BI semantic model using XMLA endpoint

21 – Enforce Power BI model security

• Restrict access to Power BI model data
• Restrict access to Power BI model objects
• Apply good modeling practices

22 – Administer a Microsoft Fabric environment

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

23 – Secure data access in Microsoft Fabric

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

24 – Secure a Microsoft Fabric data warehouse

• Explore dynamic data masking
• Implement row-level security
• Implement column-level security
• Configure SQL granular permissions using T-SQL

25 – Govern data in Microsoft Fabric with Purview

• Govern data in Microsoft Fabric
• Why use Microsoft Purview with Microsoft Fabric?
• Govern data in the Microsoft Purview hub