Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Exam Blueprint

Implement workspace-level access controls; Implement item-level access controls; Implement row-level, column-level, object-level, and file-level access control; Apply sensitivity labels to items; Endorse items

Configure version control for a workspace; Create and manage a Power BI Desktop project (.pbip); Create and configure deployment pipelines; Perform impact analysis of downstream dependencies from lakehouses, warehouses, dataflows, and semantic models; Deploy and manage semantic models by using the XMLA endpoint; Create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models

Create a data connection; Discover data by using OneLake catalog and Real-Time hub; Ingest or access data as needed; Choose between different data stores; Implement OneLake integration for Eventhouse and semantic models

Create views, functions, and stored procedures; Enrich data by adding new columns or tables; Implement a star schema for a lakehouse or warehouse; Denormalize data; Aggregate data; Merge or join data; Identify and resolve duplicate data, missing data, or null values; Convert column data types; Filter data

Select, filter, and aggregate data by using the Visual Query Editor; Select, filter, and aggregate data by using SQL; Select, filter, and aggregate data by using KQL; Select, filter, and aggregate data by using DAX