AI-102 · Question #436
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. Create a mirror of the data in Finance in an Azure SQL database. To search all data using Azure AI Search, the on-premises SQL Server data must be made accessible to Azure AI Search indexers.
Question
Options
- AMigrate the data in HR to Azure Blob storage.
- BMigrate the data in HR to the on-premises SQL server.
- CCreate a mirror of the data in Finance in an Azure SQL database.
- DIngest the data in Logs into Azure Data Explorer.
How the community answered
(47 responses)- A26% (12)
- B13% (6)
- C55% (26)
- D6% (3)
Why each option
To search all data using Azure AI Search, the on-premises SQL Server data must be made accessible to Azure AI Search indexers.
Migrating HR data to Azure Blob storage does not address the issue of the unsupported on-premises SQL Server for Finance data, as HR data is already in a supported source (Azure SQL DB).
Migrating HR data to the on-premises SQL Server would move it from an already supported source (Azure SQL DB) to an unsupported source for direct Azure AI Search indexing.
Azure AI Search indexers can directly pull data from Azure SQL Database, but not directly from on-premises SQL Server. Creating a mirror of the on-premises Finance data in an Azure SQL database makes it a compatible data source for Azure AI Search to index and search.
Ingesting Logs data into Azure Data Explorer does not resolve the issue with the on-premises SQL Server, and Azure Data Explorer is not a direct data source for standard Azure AI Search indexers.
Concept tested: Azure AI Search supported data sources for indexers
Source: https://learn.microsoft.com/en-us/azure/search/search-howto-create-indexers
Topics
Community Discussion
No community discussion yet for this question.