Pass the Microsoft Microsoft Certified: AI Business Professional AB-730 Questions and answers with CertsForce

When building a custom analytics agent in Microsoft 365 Copilot that must process structured data from Excel files, advanced analytical capabilities are required. According to Microsoft AI Business Professional guidance, tasks such as performing mathematical calculations, generating aggregations, creating charts, and conducting structured data analysis require programmatic execution capabilities rather than simple text generation.

A code interpreter enables the agent to run Python-based analytical operations in a secure execution environment. This allows the agent to manipulate datasets, compute totals and averages, perform grouping and filtering, and generate visualizations such as bar charts or line graphs based on the Excel data. The interpreter bridges the gap between natural language instructions and executable analytical logic.

An image generator is designed for creative visual content and is unrelated to structured data analytics. Suggested prompts and templates improve usability and consistency but do not provide computational or visualization capabilities.

Therefore, to enable mathematical operations, aggregation, data analysis, and visualization of Excel sales data, the correct component to add to the agent is a code interpreter.

Microsoft provides centralized activity management controls through the My Account portal, which allows users to manage privacy settings, activity history, and data associated with Microsoft 365 services, including Copilot. When the requirement is to delete all conversations with minimal effort, the most efficient method is to use the account-level activity management tools rather than deleting conversations individually.

The My Account portal enables bulk management of Copilot activity data, allowing users to clear conversation history in a consolidated manner. This approach aligns with Microsoft’s privacy-by-design framework, giving users control over their AI-generated interaction history without requiring administrative intervention.

Using the Copilot web or desktop app would typically require manually deleting conversations one at a time, increasing effort. The Windows 11 Settings app is unrelated to Microsoft 365 Copilot data management.

Therefore, to delete all Copilot conversations efficiently and with the least amount of effort, the correct approach is to use the My Account portal in Microsoft 365.

Statements:

You can add a Microsoft Teams chat as a knowledge source to a Microsoft 365 Copilot agent.

Answer: Yes

You can add a Microsoft 365 Copilot conversation as a knowledge source to a Copilot agent.

Answer: No

You can use an image file, such as a JPG file, as a knowledge source for a Microsoft 365 Copilot agent.

Answer: NO

Microsoft 365 Copilot Agent Builder supports grounding agents in approved knowledge sources so responses are accurate and permission-trimmed. Teams chats can be used as a knowledge source: Microsoft Learn confirms you can ground an agent in Teams data, including chat messages (and optionally scope to specific chats), enabling the agent to reference collaboration context when answering questions.

A Copilot conversation itself is not a supported “knowledge source” option; knowledge sources are configured from items like SharePoint content, Teams, email, websites, uploaded files, and connectors—not prior chat transcripts.

Finally, JPG images are not supported as knowledge-source file types . Microsoft’s supported file types for agent knowledge include documents like .doc/.docx, .pdf, .ppt/.pptx, .txt, and Excel formats (.xls/.xlsx), but not image formats. Therefore, you cannot use a JPG as a knowledge source for a Copilot agent.

In Microsoft 365 Copilot, the Copilot Prompt Gallery is used to store and reuse prompts that have been created and tested. To save a prompt into the gallery, Copilot must first have the prompt as an executed interaction so it can be captured as a reusable prompt (often alongside the context and intended outcome). Microsoft guidance for prompt management emphasizes validating prompts by running them and reviewing the output, then saving the prompt for reuse once it produces the desired results.

Option D is therefore the correct first step: run the prompt . After execution, you can save it to the Prompt Gallery so it becomes easily discoverable and reusable for future project reports or for sharing within your organization (subject to policy).

Creating a notebook is useful for organizing reference materials across related conversations, but it is not required to publish a prompt to the gallery. Adding an agent is for creating specialized assistants with knowledge and capabilities, not for saving a single prompt. Creating a page is used to refine and collaborate on generated content, not to make a prompt available in the gallery.

Therefore, the first action is to run the prompt .

Evaluating spend and performance trends and determining ROI is a structured analytics task. In Microsoft 365 Copilot, the Analyst agent is designed for quantitative analysis workflows: it can interpret tables, analyze datasets, identify trends over time, calculate metrics (such as ROI), and present results clearly (often including charts or summarized insights). This makes it the best fit when your goal is to compare marketing channels and understand which ones are delivering the strongest return based on last year’s data.

Chat (Option B) can help you brainstorm questions or explain results, but it is not purpose-built for deep numeric analysis. The Researcher agent (Option C) is optimized for gathering and synthesizing information from sources and producing research-style outputs, not performing ROI calculations on internal performance data. A notebook (Option D) is useful for organizing files and keeping shared reference material across related conversations, but it does not itself perform the analysis—you would still need an analysis-capable agent.

Therefore, the best choice to evaluate spending and performance trends and calculate ROI is the Analyst agent .

Microsoft 365 Copilot can use Microsoft Graph-grounded data (based on the user’s permissions) to help users work with Microsoft 365 content. This includes surfacing and summarizing information from Teams chats , so statement 1 is true. Copilot can also summarize and generate content related to Teams meetings (for example, meeting recap details, key discussion points, and follow-up actions when meeting artifacts such as transcript/notes are available), and it can answer questions and draft related content—so statement 3 is true.

Statement 2 is false because, while Copilot can draft emails and help prepare messages, it does not independently schedule and send emails automatically “based on conditions” as a native Copilot function. Conditional sending is typically handled through workflow automation tools (for example, Power Automate) and still requires appropriate configuration, permissions, and governance. In enterprise environments, this separation helps reduce risk by ensuring that automated outbound communication remains controlled, auditable, and compliant.

The correct answer is a page because Microsoft 365 Copilot supports Copilot Pages as a place to capture AI output and then refine it collaboratively. When Researcher generates a report, saving it to a page turns the response into an editable artifact where you can reorganize sections, polish wording, add supporting details, and continue iterating with Copilot while keeping the content structured.

A “conversation” is the chat thread itself and isn’t the primary editable format for producing a finalized deliverable. An “agent” is the experience that generates the content, not the storage/edit surface. A “notebook” is used for broader organization of work, but the direct save-and-edit unit for a generated response is the page , which is designed specifically for drafting, editing, and preparing content for business use (for example, exporting or reusing in Word/Teams/Outlook workflows).

Microsoft 365 Copilot agents are designed to integrate with Microsoft 365 data sources and provide flexible, natural-language-driven configuration. Agents can be connected to organizational data such as SharePoint, OneDrive, and Exchange. Since shared mailboxes are part of Exchange Online and accessible through Microsoft Graph (subject to permissions), agents can be configured to search shared mailboxes, making Statement 1 correct.

Microsoft also enables natural language creation of agents , allowing users to describe what the agent should do, its purpose, and behavior using conversational instructions rather than requiring code. This simplifies agent creation and aligns with Copilot’s low-code/no-code approach, so Statement 2 is correct.

However, agents cannot use other agents as knowledge sources. Knowledge sources are limited to structured content such as files, sites, and data repositories. Agents operate independently rather than being nested or chained as data sources, making Statement 3 incorrect.

Thus, the correct answers are Yes, Yes, No .