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





Previous Questions Next Questions