3.1.2. Resolving Data Readiness Issues
💡 First Principle: Copilot honors permissions exactly, so data readiness means making permissions match intent. Microsoft separates the work into finding exposure (reports and assessments), reducing it (access and discoverability controls), and guarding what remains (labels and DLP).
Three kinds of problem that Microsoft's guidance distinguishes:
- A data leak — sensitive content available to a wider audience than policy intends.
- Oversharing — broad permissions, groups or links authorizing more people than intended.
- A compliance gap — standing access or handling that doesn't meet an applicable policy.
SharePoint Advanced Management (SAM) is included with the Microsoft Copilot license and supplies most of the tooling. Microsoft's Secure and governed data foundation blueprint organizes it into three pillars: remediate oversharing, set up guardrails, meet regulations.
Finding exposure — evidence sources:
| Source | What it shows | Cadence |
|---|---|---|
| Site permissions for your organization (data access governance report) | Sites by number of permissioned users — top 100 on the web, up to 1 million sites in the CSV | First run can take days; run at most every 30 days |
| "Everyone Except External Users" (EEEU) activity report | Sites where the org-wide EEEU group grants access | Every 24 hours |
| Content management assessment | Recommendations; takes no action without admin consent | Every 30 days |
| DSPM data risk assessment (Purview) | The top 100 SharePoint sites by usage, assessed weekly by default; custom assessments for chosen sites | Weekly default; custom on demand |
Reducing exposure — controls:
- Site access review — a SharePoint admin starts it and the site owner remediates. It's a workflow, not proof that a site is fixed.
- Restricted Access Control (RAC) — an access control. Users outside the configured Microsoft 365 or Entra groups (up to 10 per site) are denied even if they hold a permission or a sharing link. Group membership doesn't itself grant access.
- Restricted Content Discovery (RCD) — a discoverability control. It removes a site from organization-wide search and Copilot discovery, but doesn't change permissions, doesn't block direct access, and doesn't support OneDrive.
- EEEU — turning off the ability to select EEEU in future doesn't remove existing grants; remove them explicitly or constrain the site with RAC.
- Labels and DLP (Phase 2.4) guard the sensitive items that remain: a DLP rule for the Copilot location can exclude labeled content, and encryption without EXTRACT stops summarization.
Monitoring isn't remediation, but it confirms the result: Copilot interactions are logged in Purview Audit (Standard) as CopilotInteraction records, searchable with the Audit Logs or View-Only Audit Logs role.
Roles: SharePoint Administrator (or SharePoint Advanced Management Administrator) for SAM and RAC; Compliance Administrator for DSPM assessments. The AI Administrator can view DSPM but not configure it.
⚠️ Exam Trap: Restricted Content Discovery is the most-confused control on the exam. It hides a site from Copilot and organization-wide search, but anyone with permission can still open it directly — so it doesn't fix a data leak. When a requirement says users "must not be able to access" a site, the answer is fixing permissions or Restricted Access Control, not RCD.
Reflection Question: A site shared with Everyone Except External Users holds draft merger documents that only the deal team should see. Rank site access review, RAC and RCD by how completely each fixes the problem, and explain the gap each one leaves.