AI-102 · Question #344
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 C. Export the data in Finance to Azure Data Lake Storage. To search across multiple data sources using Azure AI Search, all data needs to be accessible to the Azure Search service. The on-premises Finance data (hosted in Microsoft SQL Server) cannot be directly indexed by Azure Cognitive Search because it is on-premises. The best…
Question
Options
- AMigrate the data in HR to Azure Blob storage.
- BMigrate the data in HR to the on-premises SQL server.
- CExport the data in Finance to Azure Data Lake Storage.
- DMigrate the data in Sales to the MongoDB API.
How the community answered
(29 responses)- A7% (2)
- B14% (4)
- C76% (22)
- D3% (1)
Explanation
To search across multiple data sources using Azure AI Search, all data needs to be accessible to the Azure Search service. The on-premises Finance data (hosted in Microsoft SQL Server) cannot be directly indexed by Azure Cognitive Search because it is on-premises. The best approach is to mirror Finance to an Azure SQL database, which can be indexed by Azure Cognitive Search alongside the other Azure-hosted data sources (Sales, Logs, and HR).
Topics
Community Discussion
No community discussion yet for this question.