- 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.
- Apply governance controls in Microsoft Fabric to classify sensitive data, signal trust with endorsement, and monitor governance posture using the OneLake catalog.
By the end of this module, you're able to:
- Apply sensitivity labels to classify and protect Fabric items.
- Use endorsement, tags, and documentation to signal trust and improve discoverability.
- Monitor governance posture using the OneLake catalog's Govern section.
- Understand how the Secure section provides centralized access management.
AI, Data Science & Cloud Certificates from Google, IBM & Meta
Learn Backend Development Part-Time, Online
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
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
- Monitor and manage governance
- Exercise - Govern analytics data in Microsoft Fabric
- Knowledge check
- Summary