Exam AB-100 Topic 1 Question 18 Discussion

Actual exam question for Microsoft's AB-100 exam
Question #: 18
Topic #: 1
A company plans to deploy a Microsoft Copilot Studio agent that will analyze historical business data to predict customer behavior.
The data is currently stored in an Azure SQL database, flat files, APIs, and logs.
You need to organize the data into a format that can be used as a knowledge source in Copilot Studio.
What should you include in the solution?

Suggested Answer: A Vote an answer

Comprehensive and Detailed Explanation From Agentic AI Business Solutions Topics:
The correct answer is A. Azure AI Search .
This scenario involves data coming from multiple sources:
* Azure SQL database
* flat files
* APIs
* logs
The requirement is to organize the data into a format that can be used as a knowledge source in Copilot Studio .
Why A is correct
Azure AI Search is the best answer because it is designed to ingest, index, and organize content from multiple heterogeneous data sources so that AI applications can retrieve and use relevant information effectively.
For Copilot and agent scenarios, Azure AI Search is especially useful because it supports:
* unifying data from different sources
* creating searchable indexes
* enabling retrieval-based grounding
* improving relevance for AI responses
From an AI business solutions perspective, when data is spread across structured and unstructured systems, Azure AI Search provides the retrieval layer that turns that fragmented data into a usable knowledge source.
It is much better suited than raw storage options because the question is not only about storing data. It is about organizing it for AI-driven access and use in Copilot Studio.
Why the other options are incorrect
B). Azure Data Lake Storage
Data Lake Storage is excellent for storing large volumes of raw and processed data, but by itself it does not provide the indexing and retrieval capabilities needed to make the content a strong knowledge source for Copilot Studio.
C). Azure Cosmos DB
Cosmos DB is a NoSQL operational database. It is not the primary service for consolidating and indexing multi-source business content into a knowledge source for Copilot Studio.
D). Azure Translator in Foundry Tools
Translator is for language translation, not for organizing business data into a knowledge source.
Expert reasoning
When the question asks how to make data from many sources usable as a knowledge source for an AI agent, think about the service that:
* ingests
* indexes
* organizes
* retrieves
That service is Azure AI Search .

by Elmer at Aug 04, 2026, 10:50 AM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

0
0
0
10