Microsoft Fabric Administration & Governance

Setting Up Microsoft Fabric: Architecture, Domains & Workspaces

This module introduces the structural concepts that make Microsoft Fabric a cohesive, end-to-end analytics platform. By exploring how modern data architectures evolved and how Fabric organizes data into domains and workspaces, learners see why governance, collaboration, and scalability depend on getting these foundations right. Understanding these building blocks also provides the context for implementing patterns like the Medallion Architecture and for making informed decisions about capacity and licensing.

• What is Microsoft Fabric?
• From Traditional Data Warehousing to Data Lakes
• Domains and Workspaces in Microsoft Fabric
• Options for Implementing a Medallion Architecture
• Microsoft Fabric Licensing
• Assigning Capacities to Workspaces
• LAB: Create domain and workspaces

Introduction to Microsoft Fabric

This chapter introduces you to the essential artifacts in Microsoft Fabric. It covers the key storage options — Lakehouses and Warehouses — alongside the main tools for ingesting and transforming data: Pipelines, Dataflow Gen2, and Apache Spark Notebooks.

• Data Storage Options in Microsoft Fabric
• Introduction to Lakehouses and Warehouses
• Data Ingestion Options in Microsoft Fabric
• Introduction to Pipelines, Dataflow Gen2, and Apache Spark Notebooks for loading and transforming data
• Lab: exploring a Fabric Solution

Microsoft Fabric Security Essentials

A solid security foundation is essential for any Microsoft Fabric deployment because it protects both the platform's governance layer (control plane) and the data assets that drive analytics (data plane). This module equips administrators with the understanding needed to secure workspaces, lakehouses, warehouses, and folders; ensuring that the right people have the right access at the right scope.

• Control plane versus data plane security
• Overview of the Fabric permission model
• Workspace, Lakehouse & Warehouse Security
• Shortcut security in OneLake
• Network Security: Private Links, Trusted Workspace Access and Managed Private Endpoints
• LAB: Configuring Microsoft Fabric security

OneLake Security in Microsoft Fabric

OneLake security enables you to define granular role-based security for data stored in OneLake and enforce that security consistently across all compute engines in Fabric. OneLake security is the data plane security model for data in OneLake

• OneLake Security Overview
• Data Access Control Model
• Creating and Managing Security Roles
• SQL Analytics Endpoint Security
• Table and Folder Security
• Column-Level Security
• Row-Level Security
• LAB: Implementing OneLake Security

Monitoring Microsoft Fabric

As your Fabric tenant grows, you need visibility into usage, capacity load, storage and activity. Monitoring lets you catch issues early, control costs and keep performance stable, so the platform stays reliable for all teams.

• Monitoring from the Azure Portal
• Tenant Settings for Monitoring and Auditing
• Azure Log Analytics for Power BI
• Workspace Monitoring
• Working with the Microsoft Fabric Capacity Metrics App
• OneLake Diagnostics
• Fabric Unified Admin Monitoring (FUAM)
• LAB: Monitoring a Microsoft Fabric Tenant

Introduction to the Fabric CLI

The Fabric CLI is a command-line interface for Microsoft Fabric that brings a file-system-inspired, terminal-based way to interact with your Fabric environment. It enables you to explore, manage, and automate workspaces, items, pipelines, and more — using familiar commands

• Introduction to the Fabric CLI
• Authentication with the Fabric CLI
• Overview of the Fabric CLI commands
• The Fabric CLI Deploy Command
• LAB: Using the Fabric CLI

Managing Apache Spark in Microsoft Fabric

Apache Spark is a key compute engine in Microsoft Fabric. This module shows you how to standardize and govern Spark compute so teams can work efficiently while the platform remains controlled and predictable.

• Introduction to Starter Pools
• Creating Custom Pools
• Pool sizing/performance tuning
• Billing and Utilization
• Manage Spark Compute with Environments
• Library management in Fabric environments

Microsoft Fabric Governance from Purview

Governance and compliance become important aspects of data management. Microsoft Fabric integrates with Microsoft Purview. And although advanced features require a paid Purview account, even with the free Purview version basic governance becomes possible.

• What is Microsoft Purview?
• Purview Licensing
• Navigating the Purview Portal
• Annotating the Metadata
• Overview of Purview Enterprise Features
• LAB: Governing Fabric from within Microsoft Purview

Automating Microsoft Fabric Administration

Once Fabric moves beyond a few workspaces, doing everything by hand becomes slow and error-prone. Automation lets you roll out changes faster, repeat them the same way every time and keep control as more teams come on board.

• Infrastructure as Code for Microsoft Fabric
• Creating Capacities with Bicep and ARM
• Managing Artifacts from Python with semPy
• Using NotebookUtils to Create Fabric Items
• Microsoft Fabric REST API
• LAB: Managing Microsoft Fabric from Code