🔒 Guided

Pre-launch preview. Authorised access only.

Incorrect code

Guided by A Guide to Cloud
Explore AB-900 AI-901
Guided AB-900 Domain 2
Domain 2 — Module 10 of 10 100%
20 of 28 overall

AB-900 Study Guide

Domain 1: M365 Core Features & Objects

  • Welcome to Microsoft 365
  • Exchange Online: Mailboxes & Distribution
  • SharePoint: Sites, Libraries & Permissions
  • Microsoft Teams: Teams, Channels & Policies
  • Users, Groups & Licensing
  • Zero Trust: Never Trust, Always Verify
  • Authentication: Passwords, MFA & Beyond
  • Microsoft Defender XDR
  • Microsoft Entra: Your Identity Hub
  • PIM, Audit Logs & Identity Governance

Domain 2: Data Protection & Governance

  • Microsoft Purview: The Big Picture
  • Sensitivity Labels & Data Classification
  • Data Loss Prevention (DLP)
  • Insider Risk & Communication Compliance
  • DSPM for AI & Data Lifecycle
  • How Copilot Accesses Your Data
  • Responsible AI Principles
  • Compliance Manager & eDiscovery
  • Activity Explorer & Data Monitoring
  • Oversharing in SharePoint

Domain 3: Copilot & Agent Admin

  • What is Microsoft 365 Copilot? Free
  • What Are Agents? Free
  • Copilot vs Agents: When to Use Which Free
  • Copilot Licensing: Monthly vs Pay-as-You-Go Free
  • Researcher, Analyst & Real-World Use Cases Free
  • Managing Copilot: Billing, Monitoring & Prompts Free
  • Building Agents: Create, Test & Publish Free
  • Agent Lifecycle: Access, Approval & Monitoring Free

AB-900 Study Guide

Domain 1: M365 Core Features & Objects

  • Welcome to Microsoft 365
  • Exchange Online: Mailboxes & Distribution
  • SharePoint: Sites, Libraries & Permissions
  • Microsoft Teams: Teams, Channels & Policies
  • Users, Groups & Licensing
  • Zero Trust: Never Trust, Always Verify
  • Authentication: Passwords, MFA & Beyond
  • Microsoft Defender XDR
  • Microsoft Entra: Your Identity Hub
  • PIM, Audit Logs & Identity Governance

Domain 2: Data Protection & Governance

  • Microsoft Purview: The Big Picture
  • Sensitivity Labels & Data Classification
  • Data Loss Prevention (DLP)
  • Insider Risk & Communication Compliance
  • DSPM for AI & Data Lifecycle
  • How Copilot Accesses Your Data
  • Responsible AI Principles
  • Compliance Manager & eDiscovery
  • Activity Explorer & Data Monitoring
  • Oversharing in SharePoint

Domain 3: Copilot & Agent Admin

  • What is Microsoft 365 Copilot? Free
  • What Are Agents? Free
  • Copilot vs Agents: When to Use Which Free
  • Copilot Licensing: Monthly vs Pay-as-You-Go Free
  • Researcher, Analyst & Real-World Use Cases Free
  • Managing Copilot: Billing, Monitoring & Prompts Free
  • Building Agents: Create, Test & Publish Free
  • Agent Lifecycle: Access, Approval & Monitoring Free
Domain 2: Data Protection & Governance Premium ⏱ ~12 min read

Oversharing in SharePoint

Oversharing is the #1 risk when deploying Copilot. If your SharePoint permissions are too broad, Copilot will surface sensitive data to anyone who asks. Here's how to find and fix it.

Why oversharing is Copilot’s biggest risk

☕ Simple explanation

Oversharing is like leaving your office doors unlocked for years — nobody noticed because nobody wandered in. Then Copilot arrives, and suddenly it’s guiding everyone to every open door.

Before Copilot, an intern might technically have access to the Board’s SharePoint site but would never navigate there directly. After Copilot, they ask “What was discussed in the latest board meeting?” and Copilot finds and summarises it — because the permissions allow it.

Copilot doesn’t create the problem. It reveals the problem that was always there.

Oversharing in SharePoint occurs when site permissions are broader than intended — too many users have access to content they don’t need for their role. This is a pre-existing issue in most organisations, but Copilot amplifies its impact because Copilot makes all accessible content easily discoverable through natural language queries.

Microsoft provides several tools to detect and remediate oversharing: Data Access Governance (DAG) reports, SharePoint Advanced Management (SAM), and restricted site access policies. These are critical preparation steps before deploying Copilot.

The oversharing → Copilot pipeline

Before CopilotAfter Copilot
”Everyone” permission on SharePoint sites → nobody noticesCopilot surfaces sensitive content to anyone who asks
Sharing links set to “Anyone” → link not widely sharedCopilot finds the linked content and includes it in responses
Old project sites with stale permissions → forgottenCopilot queries historical content and brings it back to life
Guest access enabled broadly → guests rarely visitCopilot shows guests internal content they technically can see

Exam tip: “Fix oversharing BEFORE deploying Copilot” is the #1 best practice. Every Copilot deployment guide starts here.

Tool 1: Data Access Governance (DAG) reports

DAG reports in the SharePoint admin center show you where oversharing exists:

ReportWhat It Shows
Sharing linksSites with “Anyone” links or “People in your org” links
Sensitivity labelsSites with sensitive content and their sharing settings
”Everyone except external users”Sites shared with all internal users (oversharing indicator)
Oversharing baselineIdentifies the biggest risk areas before Copilot deployment

Where: SharePoint admin center → Reports → Data access governance

💡 Scenario: Northwave's pre-Copilot audit

Before deploying Copilot, Maya runs DAG reports:

Findings:

  • 🔴 47 sites shared with “Everyone except external users” (most are old project sites)
  • 🟡 23 sites have “Anyone” sharing links active (some are 3+ years old)
  • 🟢 12 sites with sensitivity labels and appropriate sharing restrictions

Actions:

  1. Remove “Everyone” permissions from 47 sites → restrict to specific groups
  2. Expire 23 “Anyone” links → set expiration to 30 days max going forward
  3. Audit the 12 labelled sites → confirm restrictions are correct
  4. Set a policy: new sites default to “Specific people” sharing (not “Everyone”)

Timeline: 2 weeks of cleanup before Copilot pilot begins.

Tool 2: SharePoint Advanced Management (SAM)

SAM provides enterprise-grade governance features:

SharePoint Advanced Management features
FeatureWhat It DoesWhy It Matters for Copilot
Restricted site accessLimits site access to members of the site's M365 Group ONLYPrevents 'Everyone' access from leaking data to Copilot
Site lifecycle policiesAutomatically identify and manage inactive sitesOld sites with stale permissions are cleaned up
Conditional access for sitesApply Conditional Access at the site levelRequire compliant devices for sensitive SharePoint sites
Block downloadsPrevent downloads from specific sitesSensitive content can be viewed but not taken offline
Data access governance reportsEnhanced oversharing detectionComprehensive pre-Copilot audit capability

Restricted site access — the key feature

Restricted site access is a SAM feature that limits who can access a SharePoint site to ONLY the members of its associated M365 Group. Even if other users technically have permissions through inherited or legacy sharing, restricted access overrides them.

Why this matters for Copilot: When restricted site access is enabled, Copilot can only surface content from that site to group members — even if other users were previously able to access the site.

ℹ️ Restricted access vs permission cleanup

You have two approaches to fix oversharing:

Approach 1: Manual permission cleanup

  • Review each site’s permissions individually
  • Remove “Everyone” groups, fix inheritance, correct sharing links
  • Thorough but time-consuming (weeks for large tenants)

Approach 2: Restricted site access (SAM)

  • Enable restricted access on sensitive sites
  • Access is automatically limited to group members regardless of other settings
  • Fast but requires SAM license

Best practice: Use restricted access for immediate Copilot safety, then do thorough cleanup in the background.

Pre-Copilot checklist — the exam expects this

  1. ✅ Run DAG reports to identify overshared sites
  2. ✅ Remove “Everyone except external users” permissions from sensitive sites
  3. ✅ Expire old “Anyone” sharing links
  4. ✅ Enable restricted site access on sensitive sites (SAM)
  5. ✅ Apply sensitivity labels to critical content
  6. ✅ Set default sharing to “Specific people” (not “People in your org”)
  7. ✅ Review guest access permissions
  8. ✅ Clean up inactive sites with stale permissions

🎬 Video walkthrough

🎬 Video coming soon

Oversharing in SharePoint — AB-900 Module 20

Oversharing in SharePoint — AB-900 Module 20

~10 min

Flashcards

Question

Why is oversharing the #1 risk for Copilot deployments?

Click or press Enter to reveal answer

Answer

Copilot accesses data through Microsoft Graph using the user's permissions. If SharePoint permissions are too broad (everyone can see everything), Copilot will surface sensitive content to anyone who asks. Copilot doesn't create the problem — it reveals pre-existing oversharing.

Click to flip back

Question

What are Data Access Governance (DAG) reports?

Click or press Enter to reveal answer

Answer

Reports in the SharePoint admin center that show where oversharing exists — sites with 'Anyone' links, sites shared with 'Everyone except external users', and sites with sensitive content. Used for pre-Copilot audit.

Click to flip back

Question

What is restricted site access in SharePoint Advanced Management?

Click or press Enter to reveal answer

Answer

A feature that limits site access to ONLY the members of the site's M365 Group, overriding any other permissions. Even if legacy sharing gives others access, restricted access blocks them. Critical for Copilot safety.

Click to flip back

Knowledge Check

Knowledge Check

Northwave is preparing to deploy Copilot. Maya discovers 47 SharePoint sites shared with 'Everyone except external users'. What should she do FIRST?


🎉 Congratulations! You’ve completed all 10 modules in Domain 2: Data Protection & Governance. You now understand Purview, sensitivity labels, DLP, insider risk, responsible AI, and the critical oversharing problem.

You’ve completed all 28 modules across all 3 domains. Time to test yourself with the Practice Lab!

← Previous

Activity Explorer & Data Monitoring

Next →

What is Microsoft 365 Copilot?

Guided

I learn, I simplify, I share.

A Guide to Cloud YouTube Feedback

© 2026 Sutheesh. All rights reserved.

Guided is an independent study resource and is not affiliated with, endorsed by, or officially connected to Microsoft. Microsoft, Azure, and related trademarks are property of Microsoft Corporation. Always verify information against Microsoft Learn.