AI-102 Question #436: Real Exam Question with Answer & Explanation

Question

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 AI Search REST API. What should you do?

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.

Explanation

To search all data using Azure AI Search, the on-premises SQL Server data must be made accessible to Azure AI Search indexers.

Common mistakes.

• A. 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).
• B. 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.
• D. 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

Reference. https://learn.microsoft.com/en-us/azure/search/search-howto-create-indexers

No community discussion yet for this question.