Deploy and manage Git repositories in Fabric
Create and update reusable assets
Implement database projects
Implement workspace and item-level security
Implement row-level and column-level security
Configure security and governance
Implement Microsoft Purview integration
Orchestrate processes using pipelines and notebooks
Schedule and trigger data pipelines and Apache Airflow jobs
Design and implement a loading pattern for a Lakehouse
Design and implement a loading pattern for a Warehouse
Implement orchestration patterns with notebooks and pipelines, including parameters and dynamic expressions
Choose between Dataflow gen 2, a pipeline and a notebook
Implement a slowly changing dimension
Ingest data using Eventstream
Design and implement a loading pattern for streaming data
Ingest data using data pipelines
Transform data using Dataflows Gen2
Transform data using Spark notebooks
Transform data using T-SQL in the Warehouse
Choose between Query acceleration for OneLake shortcuts and standard OneLake shortcuts in Real-Time Intelligence
Transform data using KQL in Eventhouse
Denormalize data for analytics
Process data by using KQL
Create windowing functions
Handle late-arriving data
Configure OneLake shortcuts
Implement mirroring in Fabric
Monitor Fabric items using the Monitoring hub
Identify and resolve Eventstream errors
Identify and resolve T-SQL errors
Monitor Spark applications
Identify and resolve errors
Ingest and transform batch data
Monitor data pipeline runs
Configure alerts and notifications
Use Capacity Metrics app to monitor consumption
Identify and resolve pipeline and notebook errors
Configure Spark workspace settings
Optimize Lakehouse Delta table performance
Configure OneLake workspace settings
Implement item-level access controls
Implement dynamic data masking
Apply sensitivity labels to items
Optimize Warehouse query performance
Configure Apache Airflow workspace settings
Implement version control and CI/CD for analytics items
Design and implement schedules and event-based triggers
Implement DevOps and lifecycle governance
Create and manage OneLake shortcuts
Process data by using Eventstream
Identify and resolve pipeline errors
Choose an appropriate streaming engine
Monitor semantic model refresh
Implement workspace-level access controls
Implement and use Microsoft Fabric audit logs
Configure and implement OneLake security
Create and configure deployment pipelines
Design and implement full and incremental data loads
Prepare data for loading into a dimensional model
Choose an appropriate data store
Transform data by using PySpark, SQL, and KQL
Design and implement loading patterns
Optimize a Lakehouse table
Optimize query performance
Identify and resolve notebook errors
Identify and resolve Dataflow Gen2 errors
Identify and resolve Eventhouse errors
Identify and resolve OneLake shortcut errors
Monitor data transformation
Choose between Dataflows Gen2, notebooks, KQL, and T-SQL for data transformation
Implement row-level, column-level, object-level, and folder/file-level access controls
Configure version control
Optimize Eventstream and Eventhouse
Ingest data by using pipelines
Optimize a data warehouse
Handle duplicate, missing, and late-arriving data
Choose between native tables and OneLake shortcuts in Real-Time Intelligence
Configure domain workspace settings
Process data by using Spark structured streaming
Optimize Spark performance