What should you do?

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?
A . Configure multiple read replicas for the data in Sales.
B. Mirror Finance to an Azure SQL database.
C. Migrate the data in Sales to the MongoDB API.
D. Ingest the data in Logs into Azure Sentinel.

View Answer

Answer: B

Explanation:

On-premises Microsoft SQL Server database cannot be used as an index data source.

Note: Indexer in Azure Cognitive 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 Cosmos DB

✑ Azure SQL Database

✑ SQL Managed Instance

✑ SQL Server on Azure Virtual Machines

Reference: https://docs.microsoft.com/en-us/azure/search/search-indexer-overview#supported-data-sources