This post is a part of the AB-900: Microsoft 365 Copilot and Agent Administration Fundamentals Exam Prep Hub.
This topic falls under these sections:
Understand data protection and governance tasks for Microsoft 365 and Copilot (35–40%)
--> Identify and monitor oversharing in SharePoint in Microsoft 365
--> Run a data access governance report in SharePoint
Note that there are 10 practice questions (with answers) at the end of each section to help you solidify your knowledge of the material. Also, there are 4 practice tests with 30 questions each available from the hub's main page below the exam topics section.
Introduction
That is an excellent next topic for the AB-900 exam because it combines SharePoint governance, Microsoft Purview, and Copilot data security. Although the feature continues to evolve, the exam focuses on understanding what the report is, when to use it, and what problems it helps administrators solve, rather than memorizing every UI step.
Why Data Access Governance Matters
One of the largest security challenges in Microsoft 365 is oversharing. Over time, organizations accumulate millions of files, thousands of SharePoint sites, and numerous Microsoft Teams workspaces. Permissions often become increasingly complex as users:
- Share files externally
- Create anonymous sharing links
- Grant access to “Everyone”
- Add guests to Teams
- Break inheritance on folders
- Forget to remove temporary permissions
As organizations adopt Microsoft 365 Copilot, overshared content becomes an even greater concern because Copilot can surface information that a user already has permission to access—even if that access was unintentionally granted.
Microsoft provides Data Access Governance (DAG) capabilities in SharePoint to help administrators discover, understand, and remediate excessive access before it becomes a security issue.
What is Data Access Governance?
Data Access Governance is a collection of reporting and analysis capabilities within SharePoint Advanced Management that helps administrators answer questions such as:
- Which sites are accessible by everyone?
- Which files are overshared?
- Which sites have external users?
- Which sites contain highly sensitive information?
- Which permissions may expose confidential content?
- Which sites should be reviewed?
Rather than examining permissions one site at a time, administrators receive organization-wide visibility.
Primary Goals of Data Access Governance
Data Access Governance helps organizations:
- Discover overshared sites
- Review permissions
- Reduce excessive access
- Identify high-risk collaboration
- Improve Microsoft 365 security posture
- Prepare for Microsoft 365 Copilot deployment
- Reduce accidental data exposure
- Support compliance initiatives
Why It Is Important for Microsoft 365 Copilot
Microsoft 365 Copilot never ignores permissions.
Instead, it retrieves content using the same security model that governs Microsoft 365.
If a user has permission to open a document manually, Copilot can potentially reference that document when generating responses.
For example:
Suppose Human Resources accidentally grants the entire company read access to salary spreadsheets.
Without Copilot:
- Most employees may never discover the files.
With Copilot:
A user might ask:
“Summarize employee compensation data.”
Because the files are already accessible, Copilot could retrieve them.
The problem is not Copilot—it is the underlying permissions.
Data Access Governance helps identify these permission problems before they become security risks.
What the Data Access Governance Report Shows
The report provides administrators with visibility into SharePoint permissions and sharing configurations across the tenant.
Common information includes:
- Site owners
- Site sensitivity
- External sharing status
- Number of members
- Anonymous links
- Organization-wide access
- Guest access
- Sharing activity
- Permission inheritance
- Access patterns
- High-risk sites
- Overshared content indicators
Rather than searching manually, administrators can prioritize the highest-risk locations.
Types of Oversharing That Can Be Identified
The report can identify situations such as:
Organization-wide access
Sites accessible by:
- Everyone
- Everyone except external users
- Large security groups
These sites often expose more content than intended.
Anonymous Links
Files shared through links that require no authentication.
These links may remain active long after they are needed.
Guest Access
Sites containing:
- External users
- Partner accounts
- Vendor accounts
Administrators can verify whether guest access is still appropriate.
Excessive Sharing
Examples include:
- Large numbers of shared files
- Broad sharing permissions
- Public document libraries
- Open collaboration spaces
Sensitive Sites
The report can identify sites that contain:
- Financial information
- HR records
- Legal documents
- Intellectual property
- Customer information
Combined with Microsoft Purview sensitivity labels, administrators gain better visibility into where important information resides.
Typical Workflow
Administrators generally follow this process:
Step 1
Open SharePoint administration tools.
Step 2
Generate or review a Data Access Governance report.
Step 3
Review identified risks.
Examples:
- Overshared sites
- External sharing
- Everyone permissions
- Sensitive content
Step 4
Investigate high-risk sites.
Questions include:
- Does this access need to exist?
- Are guests still required?
- Is inheritance broken?
- Should permissions be reduced?
Step 5
Take corrective action.
Possible actions include:
- Remove permissions
- Restrict sharing
- Apply sensitivity labels
- Disable anonymous links
- Reduce guest access
- Educate site owners
Step 6
Run reports regularly to verify improvements.
Relationship with Microsoft Purview
Data Access Governance works alongside Microsoft Purview.
Purview answers questions such as:
- What sensitive data exists?
- How is it classified?
- Which labels are applied?
- Are DLP policies triggered?
SharePoint Data Access Governance answers:
- Who can access the data?
- Is the data overshared?
- Which sites expose information?
- Which permissions should be reviewed?
Together they provide both:
- Content awareness
- Permission awareness
Relationship with Microsoft 365 Copilot
Data Access Governance helps administrators prepare for Copilot by reducing permission-related risks.
Benefits include:
- Finding overshared SharePoint sites
- Identifying unnecessary permissions
- Reducing broad access
- Reviewing guest sharing
- Protecting confidential information
- Improving search security
- Supporting Zero Trust principles
Best Practices
Microsoft recommends that organizations:
- Review sharing reports regularly.
- Audit external access periodically.
- Minimize “Everyone” permissions.
- Remove unused guest accounts.
- Apply sensitivity labels to important sites.
- Use Microsoft Purview DLP alongside SharePoint governance.
- Educate site owners on responsible sharing.
- Review high-risk collaboration sites before deploying Copilot broadly.
- Follow the principle of least privilege.
- Continuously monitor permission changes.
Common Exam Tips
Remember these key points:
- Data Access Governance focuses on permissions and access, not document content.
- It helps identify oversharing across SharePoint.
- It is especially valuable before deploying Microsoft 365 Copilot.
- Copilot respects existing Microsoft 365 permissions.
- Oversharing is a permissions problem, not a Copilot problem.
- Reports help administrators prioritize high-risk sites for remediation.
- Data Access Governance complements Microsoft Purview rather than replacing it.
Practice Exam Questions
Question 1
Why would an administrator run a Data Access Governance report in SharePoint?
A. To update SharePoint servers
B. To identify overshared sites and permission risks
C. To encrypt all documents automatically
D. To generate Microsoft 365 licenses
Correct Answer: B
Explanation: Data Access Governance helps administrators identify sites with excessive permissions, external sharing, and other access-related risks.
Question 2
Which issue is Data Access Governance primarily designed to identify?
A. SQL database corruption
B. Printer failures
C. Oversharing of SharePoint content
D. Network latency
Correct Answer: C
Explanation: The primary purpose is to detect oversharing and excessive permissions across SharePoint.
Question 3
Why is Data Access Governance especially important before deploying Microsoft 365 Copilot?
A. Copilot automatically changes permissions.
B. Copilot ignores SharePoint security.
C. Copilot copies all SharePoint files.
D. Copilot can reference content users already have permission to access.
Correct Answer: D
Explanation: Copilot honors existing permissions. Overshared content may therefore appear in Copilot responses if users already have legitimate access.
Question 4
Which type of access represents a potential oversharing risk?
A. Anonymous sharing links
B. Azure subscription ownership
C. Exchange mailbox size
D. Microsoft Teams background images
Correct Answer: A
Explanation: Anonymous links allow access without authentication and should be reviewed carefully.
Question 5
What question does Data Access Governance primarily help answer?
A. Which users have excessive access to SharePoint content?
B. Which Windows updates are missing?
C. Which devices need antivirus software?
D. Which Microsoft 365 licenses should be purchased?
Correct Answer: A
Explanation: Data Access Governance focuses on permissions, sharing, and access to SharePoint content.
Question 6
Which Microsoft 365 principle is supported by regularly reviewing Data Access Governance reports?
A. Unlimited collaboration
B. Least privilege
C. Maximum storage allocation
D. Unlimited guest access
Correct Answer: B
Explanation: Regular reviews help ensure users have only the permissions necessary to perform their work.
Question 7
Which type of SharePoint site would likely appear as higher risk in a Data Access Governance report?
A. A private HR site with restricted access
B. A site shared with only one administrator
C. A site containing sensitive files that is accessible to everyone
D. A newly created empty site
Correct Answer: C
Explanation: Sensitive information combined with broad permissions represents a significant oversharing risk.
Question 8
How does Data Access Governance complement Microsoft Purview?
A. Both products only classify documents.
B. Data Access Governance focuses on permissions, while Purview focuses on data protection and governance.
C. They perform identical functions.
D. Purview replaces SharePoint permissions.
Correct Answer: B
Explanation: Purview governs and protects data, while Data Access Governance helps administrators understand who has access to that data.
Question 9
Which action should an administrator consider after identifying an overshared SharePoint site?
A. Delete all documents immediately.
B. Disable Microsoft 365 Copilot.
C. Purchase additional SharePoint storage.
D. Review and reduce unnecessary permissions.
Correct Answer: D
Explanation: The appropriate response is to evaluate existing permissions and remove excessive or unnecessary access while maintaining business needs.
Question 10
Which statement about Microsoft 365 Copilot and Data Access Governance is true?
A. Data Access Governance prevents all Copilot responses.
B. Copilot bypasses SharePoint permissions when generating answers.
C. Data Access Governance helps reduce the risk of Copilot surfacing overshared information by identifying excessive permissions.
D. Copilot encrypts all SharePoint documents before using them.
Correct Answer: C
Explanation: By identifying and remediating overshared permissions, Data Access Governance helps ensure Copilot only surfaces information that users are appropriately authorized to access.
Go to the AB-900 Exam Prep Hub main page
