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 ...
Microsoft AI-102 Exam
Questions Number: 169 out of 241 Questions
70.12%
Question 169
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?
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