You have the following data sources: - Finance: On-premises Microsoft SQL Server database - Sales: Azure Cosmos DB using the Core (SQL) API - Logs: Azure Table storage - HR: Azure SQL database You…

The correct answer is B. Mirror Finance to an Azure SQL database. On-premises Microsoft SQL Server database cannot be used as an index data source. Note: Indexer in Azure AI Search: : Automate aspects of an indexing operation by configuring a data source and an indexer that you can schedule or run on demand. This feature is supported for a…

Submitted by stefanr· Mar 30, 2026Implement knowledge mining solutions

Question

You have the following data sources: - Finance: On-premises Microsoft SQL Server database - Sales: Azure Cosmos DB using the Core (SQL) API - Logs: Azure Table storage - HR: Azure SQL database You need to ensure that you can search all the data by using the Azure AI Search REST API. What should you do?

Options

AConfigure multiple read replicas for the data in Sales.
BMirror Finance to an Azure SQL database.
CMigrate the data in Sales to the MongoDB API.
DIngest the data in Logs into Azure Sentinel.

How the community answered

(45 responses)

A
9% (4)
B
71% (32)
C
2% (1)
D
18% (8)

Explanation

On-premises Microsoft SQL Server database cannot be used as an index data source. Note: Indexer in Azure AI Search: : Automate aspects of an indexing operation by configuring a data source and an indexer that you can schedule or run on demand. This feature is supported for a limited number of data source types on Azure. Indexers crawl data stores on Azure. Azure Blob Storage Azure Data Lake Storage Gen2 (in preview) Azure Table Storage Azure SQL Database SQL Managed Instance SQL Server on Azure Virtual Machines https://docs.microsoft.com/en-us/azure/search/search-indexer-overview#supported-data-sources

Topics

#Azure AI Search#Data source indexing#On-premises data migration#Azure SQL Database

Community Discussion

No community discussion yet for this question.

Full AI-102 Practice