- Implement workspace roles, item permissions, and OneLake security roles to control data access in Microsoft Fabric.
In this module, you'll:
- Describe the Fabric security model and its layers of access control.
- Configure workspace roles and item permissions.
- Apply granular permissions using T-SQL and OneLake security roles.
- Learn the key concepts and strategies for protecting sensitive data in Microsoft Fabric data warehouses.
In this module, you'll:
- Identify the security layers available in a Microsoft Fabric warehouse.
- Describe how dynamic data masking obscures sensitive column values.
- Explain how row-level security restricts row access by user.
- Describe how column-level security controls access to specific columns.
- Explain how SQL granular permissions control access to warehouse objects.
- Implement Fabric-native governance practices including data classification, sensitivity labels, endorsement, and documentation to ensure data assets are trustworthy and governed for both human and AI consumption.
By the end of this module, you're able to:
- Apply data classification and sensitivity labels to Fabric items.
- Use endorsement (promoted, certified, and master data) as a governance mechanism.
- Implement documentation practices for data discoverability.
- Describe how governance controls affect AI agent data consumption.
- Use OneLake catalog features for data estate management.
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
PowerBI Data Analyst - Create visualizations and dashboards from scratch
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Syllabus
- Secure data access in Microsoft Fabric
- Introduction
- Understand the Fabric security model
- Configure workspace and item permissions
- Apply granular permissions
- Exercise: Secure data access in Microsoft Fabric
- Module assessment
- Summary
- Secure a Microsoft Fabric data warehouse
- Introduction
- Explore dynamic data masking
- Implement row-level security
- Implement column-level security
- Configure SQL granular permissions using T-SQL
- Exercise: Secure a warehouse in Microsoft Fabric
- Module assessment
- Summary
- Govern analytics data in Microsoft Fabric
- Introduction
- Classify and protect data in Microsoft Fabric
- Endorse and document data assets
- Govern data for AI consumption
- Exercise - Govern analytics data in Microsoft Fabric
- Knowledge check
- Summary