Configuring Copilot Studio with SharePoint as a Knowledge Source
You are an AI engineer at Contoso. Contoso has a Microsoft Copilot for Microsoft 365 deployment. They want to build a custom copilot in Microsoft Copilot Studio that can answer questions about their internal IT support knowledge base stored in a SharePoint Online document library. The knowledge base includes hundreds of PDF and Word documents. Requirements: - The copilot must only answer from the approved knowledge base documents. - Responses must be grounded in the documents and include citations. - The solution must use generative answers with a prebuilt AI model (no custom model training). - Authentication must be via Microsoft Entra ID with single sign-on (SSO). - The copilot should be published to a Microsoft Teams channel. You need to recommend the minimal configuration steps. What should you do?
Quick Answer
The correct answer is to create a new copilot in Copilot Studio, add the SharePoint document library as a knowledge source, configure Microsoft Entra ID authentication for SSO, enable generative answers, and publish to the Teams channel. This works because Copilot Studio’s prebuilt generative AI model can directly ground responses in SharePoint content without custom training, automatically citing source documents to meet the grounding requirement. On the AI-102 exam, this scenario tests your understanding of when to use a low-code knowledge source versus building a custom Azure AI Search pipeline—a common trap is overcomplicating the solution with Azure AI Language or custom skills, which violates the “no custom model training” constraint. Remember the key distinction: Copilot Studio’s “add knowledge” feature handles SharePoint grounding natively, while Azure AI Search requires index creation and is not minimal. Memory tip: “SharePoint source, Copilot Studio course—no custom, just connect and enforce.”
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
In Copilot Studio, create a new copilot. Add the SharePoint document library as a knowledge source. Configure authentication with Microsoft Entra ID. Enable generative answers. Publish to the Teams channel.
Copilot Studio allows you to create a copilot and add a SharePoint Online document library as a knowledge source, which enables generative answers grounded in those documents. Authentication can be configured with Microsoft Entra ID for SSO, and publishing to the Teams channel is a built-in capability. This meets all requirements without custom code or model training. Option A is wrong because building a custom Azure AI Language model requires training, violating the 'no custom model training' requirement. Option B is wrong because Power Virtual Agents (now part of Copilot Studio) does not natively provide the same seamless integration with SharePoint for generative answers with citations; the recommended approach is using Copilot Studio knowledge sources. Option C is wrong because using Azure AI Search requires creating an index and custom connector, which adds complexity beyond the minimal configuration.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Create a custom Azure AI Language model using the documents. Then build a bot with Azure Bot Service and connect it to Copilot Studio.
Why it's wrong here
Custom model training is not allowed per requirements, and this is not the minimal approach.
- ✗
Use Power Virtual Agents to create a bot. Add a custom entity to map document content. Use Power Automate to retrieve documents.
Why it's wrong here
Manually mapping document content with custom entities and using Power Automate to retrieve documents does not leverage Microsoft Copilot Studio's prebuilt generative AI capabilities for unstructured data. This approach would require extensive custom logic to process hundreds of PDF and Word documents for grounded answers and citations, failing the "prebuilt AI model" and "minimal configuration" requirements. However, this method is suitable for building bots that interact with structured data sources or APIs, where specific data points are mapped to entities for rule-based responses, offering precise control over information retrieval.
- ✗
Use Azure AI Search to index the documents. Create a custom connector in Copilot Studio to query the search index. Configure authentication and publish to Teams.
Why it's wrong here
This requires additional infrastructure (Azure AI Search) and is not minimal.
- ✓
In Copilot Studio, create a new copilot. Add the SharePoint document library as a knowledge source. Configure authentication with Microsoft Entra ID. Enable generative answers. Publish to the Teams channel.
Why this is correct
This uses built-in features without custom coding, meeting all requirements.
Go deeper
Related to this question
About these practice questions
This AI-102 question is part of Courseiva's 945-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on AI-102
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. You are implementing a chatbot using Microsoft Copilot Studio that helps employees find company policies. The chatbot must: - Use generative answers based on a SharePoint Online site. - Only respond with information from approved policy documents. - Include citations in responses. - Be accessible from Microsoft Teams. - Require no custom code. What should you do?
easy- A.Use Power Automate to retrieve documents and feed them to Azure OpenAI. Build a custom connector for Teams.
- ✓ B.In Copilot Studio, create a new copilot. Add the SharePoint site as a knowledge source. Enable generative answers with citations. Publish to Teams.
- C.Build a bot using Azure Bot Service and QnA Maker. Train it with the policy documents. Deploy to Teams.
- D.Create a custom GPT in Azure OpenAI Studio. Upload the policy documents. Deploy via Azure API Management and expose to Teams.
Why B: Microsoft Copilot Studio natively supports adding a SharePoint Online site as a knowledge source, enabling generative answers that retrieve and cite only approved policy documents. It requires no custom code, automatically includes citations in responses, and can be published directly to Microsoft Teams, fulfilling all stated requirements.
Variation 2. You are designing a conversational AI solution using Microsoft Copilot Studio. The solution must: - Allow users to ask questions about company policies stored in SharePoint Online. - Use generative answers with grounding data. - Ensure that responses are based only on approved documents. - Support authentication via Microsoft Entra ID. Which THREE components must be configured as part of the solution?
hard- ✓ A.Create a new data source in Copilot Studio pointing to SharePoint Online.
- B.Create a Power Automate flow to retrieve documents from SharePoint.
- ✓ C.Configure authentication settings to require Microsoft Entra ID sign-in.
- D.Train an AI Builder model to classify policy documents.
- ✓ E.Add a generative answers topic with a 'knowledge source' node referencing SharePoint.
Why A: Copilot Studio allows you to create a new data source that connects directly to SharePoint Online, enabling the generative answers feature to retrieve and ground responses on approved policy documents stored there. This ensures that only content from the specified SharePoint site is used, meeting the requirement for grounding data from approved documents.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AI-102 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AI-102 exam.