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

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 365 Copilot respects Microsoft 365 permissions (“permission trimming”). This means it can only access and summarize content you are authorized to view. Therefore, Copilot cannot answer questions about Teams meetings you are not invited to (and otherwise don’t have access to), making statement 1 No .

Copilot can summarize and answer questions about Teams artifacts you do have access to—such as chat messages, channel posts, and meeting content (for example, transcripts, notes, recordings, and meeting recap details when available). That makes statement 2 Yes .

Copilot can also help you prepare for your schedule by summarizing upcoming meetings you’re invited to , using calendar and meeting context (subject, time, participants, related emails/files, and available agenda/notes). This supports planning and prioritization for the week ahead, so statement 3 is Yes .

Microsoft 365 Copilot Chat is included at no additional cost for users with qualifying Microsoft 365 subscriptions such as Business Basic, Business Standard, Business Premium, E3, and E5. Therefore, users without a Microsoft 365 Copilot add-on license can still access Copilot Chat.

Copilot Chat allows users to upload documents from their local device within a session for summarization, analysis, and drafting assistance. However, advanced enterprise-integrated features—such as creating agents that access organizational SharePoint folders—require a Microsoft 365 Copilot license.

Agent creation and enterprise data grounding leverage Microsoft Graph integration and are considered premium Copilot capabilities tied to licensed Copilot services.

This distinction reflects Microsoft’s licensing model: baseline AI chat access is included with qualifying subscriptions, while deep Microsoft 365 app integration and enterprise data agents require the additional Copilot license.

Use the Analyst agent for Prompt 1 because it is optimized for structured data work: consolidating worksheets, performing calculations, sentiment breakdowns by category (product line), and producing visualizations. These tasks align with analysis-style workflows where quantitative processing and charting are required.

Use the Researcher agent for Prompt 2 because it is designed to synthesize information from multiple sources, including SharePoint content plus web grounding , and to produce a well-structured brief with citations . Researcher is best when you need evidence-backed insights, reputable sourcing, and an organized narrative with risks and gaps.

Use Chat for Prompt 3 because the goal is drafting a refined executive email based on an attached document with tone control and communication standards. Chat excels at business writing, rewriting, tone adjustment, and producing polished communications without needing the deeper research workflow or heavy data analytics specialization.

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 operates within the security, compliance, and identity boundaries of a Microsoft 365 tenant. Shared prompts, prompt links, and Copilot artifacts are governed by organizational access controls and tenant isolation. If a prompt is created and shared from outside your organization, cross-tenant access may not be supported depending on the sharing configuration and administrative policies.

When a user attempts to open a prompt that resides in another organization’s tenant without proper cross-tenant sharing permissions, Copilot cannot locate or validate the resource within the user’s own environment. As a result, the system displays a “Prompt not found” message.

Option B would typically result in an access or permissions error rather than the prompt being unavailable entirely. Sensitivity labels and scheduled prompts do not inherently cause a “not found” error. Therefore, the most likely cause is that the prompt exists outside your organization’s tenant boundary and is not accessible to you.

==================================================

The Describe tab is where you leverage generative AI to help build an agent by describing what you want the agent to do in natural language. Instead of manually configuring everything first, you provide the agent’s purpose, target users, tone, and the tasks it should perform (for example: “Create an onboarding agent that answers HR policy questions in a friendly tone and references SharePoint policies”). Copilot then uses that description to propose an initial agent setup—such as suggested behaviors, starter prompts, and structure—accelerating agent creation and improving consistency. By contrast, the Configure tab is typically used to fine-tune and finalize settings (such as knowledge sources, actions, and other parameters) after the agent concept is established. A Copilot notebook or Copilot page can help organize content and outputs, but they are not the primary place where generative AI “builds” the agent definition. Using the Describe tab reflects best practice: start with clear intent and constraints, then refine configuration for governance, accuracy, and usability.

Microsoft 365 Copilot agents dynamically reflect updates such as new suggested prompts. When an agent is updated, users who already have the agent installed do not need to reinstall or have the agent reshared. Instead, the updated configuration becomes available when the agent is used again.

Suggested prompts are surfaced when a user interacts with the agent. Therefore, once Ben Smith issues any prompt to Agent1, the agent session refreshes and displays the latest suggested prompts, including the newly added one.

Stopping and resharing the agent (Option A) or reinstalling it (Option B) is unnecessary overhead. Option D refers to a non-standard command and is not part of Microsoft Copilot functionality.

Thus, the correct action is simply to have the user interact with the agent again.

==================================================

Prompt scheduling in Microsoft 365 Copilot enables users to automate recurring AI-driven tasks such as generating reports, summaries, or updates. However, there are defined operational limits to ensure system performance, responsible AI usage, and governance compliance.

First, the most frequent interval at which a prompt can be scheduled is once per day . Scheduling more frequently, such as hourly, is not supported. This limitation prevents excessive automated execution that could strain system resources or generate unnecessary redundant outputs.

Second, a scheduled prompt has a maximum execution limit of 15 times . After reaching this threshold, the schedule must be recreated if further automation is required. This control ensures users periodically review and validate automated prompts for relevance, accuracy, and business alignment.

These constraints reflect Microsoft’s enterprise AI governance strategy: balancing productivity automation with performance optimization, cost control, compliance oversight, and responsible AI lifecycle management within Microsoft 365 Copilot environments.

In Microsoft 365 Copilot, agents such as Researcher are accessed through the Agents experience within the Copilot app. If the user interface does not immediately display a specific agent, the correct action is to browse or search the available agents catalog. The exhibit shows the left navigation pane with an Explore agents option.

According to Microsoft AI Business Professional guidance, built-in and custom agents can be discovered and enabled through the Explore agents section. If the user already has the appropriate Copilot license and is signed in with their work account, there is no need to switch accounts or request another license.

Signing in through a browser does not change feature availability, and using a personal account would remove access to organizational features. Therefore, to access the Researcher agent, you should select Explore agents and search for Researcher.