AB-731 practice question 11 of 35
Tailwind Traders’ finance controller wants to understand budget vs. actual performance using an exported Excel file. They attach the file in the…
Full set: 389 questionsThe finance controller's tasks—finding unusual cost centers, plotting trends, and asking "what-if" questions—are all core data analysis activities. The "Analyst" agent is the conceptual tool designed specifically for this purpose. It is optimized to work with structured data, such as an Excel file, to perform calculations, identify statistical outliers, generate visualizations (plots), and model scenarios. This specialized function provides the interactive, in-depth analysis required, which goes beyond the capabilities of a general chat or a research-focused agent.
A. The Researcher agent is designed for gathering and synthesizing information from a broad set of documents or web sources, not for deep numerical analysis of a single file.
B. Standard Copilot Chat has general file-handling capabilities but lacks the specialized, deep analytical and visualization functions required for this scenario.
C. The Create agent is focused on generating new content like a report or presentation, not on the interactive analysis and exploration of a dataset.
1. Microsoft Support. (2024). Analyze data with Copilot in Excel. "Ask Copilot to... 'Show me a bar chart of sales by product'... 'Project the impact of a [variable change]'... This demonstrates the 'what-if' and plotting capabilities of the Analyst function. Section: "Prompt ideas to try".
2. Microsoft 365 Blog. (2024). Announcing Microsoft 365 Copilot. The initial announcements and subsequent feature descriptions consistently differentiate between content creation, summarization, and data analysis as distinct pillars of Copilot's functionality, supporting the use of a specialized agent for analysis.
Keep practicing
Take the free AB-731 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other AB-731 practice questions
- Question 1A retailer is deciding where to invest in AI. Some tasks are simple rule lookups, while o…
- Question 2A team designing a policy assistant wants the model to follow a specific questions–answer …
- Question 3How should AI risk management be integrated into an enterprise governance approach?
- Question 4Which driver emphasizes running focused pilots, measuring outcomes, and developing repeat…
- Question 5Contoso’s field-operations team is rolling out a mobile app that lets inspectors take phot…
- Question 6Which Azure capability best supports a unified data foundation for analytics and governanc…
