Question

A retail analytics team is building an agent in Microsoft Foundry that must answer ad-hoc business questions by running calculations, statistical aggregations, and generating charts from CSV files that analysts upload during a conversation. The data and required computations vary unpredictably from question to question, so the logic cannot be hard-coded in advance. Which Foundry tool should the architect configure to satisfy this requirement?

Accepted Answer

Code Interpreter, which lets the agent write and execute Python in a sandboxed environment against the uploaded files

Answer

Grounding with Bing Search to retrieve current market data from the web

Answer

A File Search (vector store) tool to perform retrieval-augmented generation over the uploaded documents

Answer

A custom function tool with a predefined schema that returns calculated aggregates