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 Cognitive Search REST API.
What should you do?
Azure Cognitive Search supports indexing data from various data sources on Azure, such as Azure SQL Database, Azure Cosmos DB, and Azure Table Storage. However, an on-premises Microsoft SQL Server cannot be used directly as an index data source for Azure Cognitive Search. To enable search functionality across datasets, the data from the on-premises Finance database should be mirrored to an Azure SQL Database, which is a supported data source for Azure Cognitive Search. This will ensure that all necessary data sources can be indexed and searched using the Azure Cognitive Search REST API.
B is correct answer : Mirror Finance to an Azure SQL database. https://docs.microsoft.com/en-us/azure/search/search-indexer-overview#supported-data-sources
A modified version of this was in the exam today.
correct, a similar question was already present before
Agreed is B
Selected Answer: B
Many similar questions are registered; I'm not sure why only Finance is on-premise.
B is right answer.