Get Your CertAI-103PlayCompete
‹ All AI-103 questions

AI-103 Practice Question 85: BYO Thread Storage Cosmos

Microsoft Azure AI Apps and Agents Developer Associate (AI-103) · Test 9 · question 5 of 10

Implement generative AI and agentic solutionshard

A regulated fintech company runs Foundry Agent Service with the standard agent setup. Compliance requires that all customer conversation history be stored exclusively in Azure resources the company's own tenant controls, and the data-residency exception that was just approved covers only an existing Azure SQL Server estate the company already operates for other regulated workloads, not any newly provisioned NoSQL database. The team also wants the platform to keep managing conversation state automatically through thread IDs; they don't want to rewrite the application to resend full conversation history on every turn.

Can standard agent setup's bring-your-own thread storage be pointed at that existing SQL Server database?

Select one answer
Show answer and explanation

Answer:

  • D. No: standard agent setup's bring-your-own thread storage is specifically an Azure Cosmos DB for NoSQL account provisioned in the customer's tenant; conversation history can't be redirected to an arbitrary existing datastore like SQL Server, so a new Cosmos DB account is required even though the current exception doesn't cover it

Standard agent setup's resource table is specific about the technology, not just "a customer-owned database": Azure Cosmos DB (BYO Thread Storage) stores "messages, conversation history, and agent metadata," and the prerequisites call for "an Azure Cosmos DB for NoSQL account" sized to at least 3000 RU/s across its containers. There's no documented option to substitute a different engine such as SQL Server; the connection the project capability host expects is a Cosmos DB for NoSQL connection specifically. The compliance team's SQL Server exception, however solid, doesn't change what the platform will connect to.

- A is wrong because it invents a substitution the documentation doesn't support; the BYO thread-storage prerequisite is Cosmos DB for NoSQL, not "any relational or NoSQL store." - B is wrong because standard agent setup exists specifically to keep agent data (files, vector stores, and threads) in customer-owned Azure resources inside the customer's tenant; claiming Foundry Agent Service is always Microsoft-managed contradicts the entire purpose of the standard setup. - C is wrong against the stated constraint: setting store to false is the Responses API's zero-data-retention pattern, and it requires the application itself to carry conversation context forward on every call, exactly the rewrite the team said it wants to avoid. It also isn't standard agent setup's BYO thread storage; it's a different mechanism for a different API shape.

Reference: Set up standard agent resources for Foundry Agent Service

Practice Test 9 ›

Study guides for AI-103

AI engineer roadmap 2026: skills, certs and the orderAI engineer roadmap for 2026: skills to learn in order, AI engineer vs ML engineer, which certifications fit each stage, and what to skip.
AI-200 exam guide: Azure AI Cloud Developer AssociateAI-200 replaced AZ-204: what the Azure AI Cloud Developer exam tests, how it differs from AI-103, price in USD and INR, format and how to prepare.
How AI Is Changing Software Jobs: Where to PrepareHow AI is changing software jobs: what history shows, the evidence on junior developers, what Klarna learned, new AI roles and five domains to prepare for.
AI-901 exam guide: Azure AI Fundamentals after AI-900AI-901 replaced AI-900: learn what changed, how much Python and Microsoft Foundry you need, exam costs in India, and how to prepare.
Best AI certifications 2026: AWS, Google, Microsoft, ClaudeThe best AI certifications in 2026 from AWS, Google, Microsoft, Claude and Databricks, by level, with price, status and which one to take first.
Microsoft AI certification path 2026: which exam firstMicrosoft AI certification path for 2026 - AI-901, AB-730, AI-103, AI-200, AI-300, AB-100, AI-500 and GH-300 by role, and which exam to take first.
AI-103 Certification Guide: What Changed From AI-102The AI-103 certification replaced AI-102 in 2026. Exam format, cost, the five skill domains, what changed and how to prepare, with free practice questions.
What Is RAG? How Retrieval-Augmented Generation WorksWhat RAG is and how it works: chunking, embeddings, vector search, hybrid search, reranking, GraphRAG and agentic RAG on AWS, Google and Azure.
Prompt engineering vs RAG vs fine-tuningWhen to use prompt engineering, retrieval-augmented generation, fine-tuning or continued pre-training, compared on cost, freshness, hallucination and privacy.