nerdexam
Microsoft

AI-102 · Question #318

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 A. Export the data in Finance to Azure Data Lake Storage. To make data from an on-premises Microsoft SQL Server database searchable by Azure AI Search, the data must first be moved to a cloud-based data source that Azure AI Search can index, such as Azure Data Lake Storage.

Submitted by yaw92· Mar 30, 2026Implement knowledge mining solutions

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

  • AExport the data in Finance to Azure Data Lake Storage.
  • BConfigure multiple read replicas for the data in Sales.
  • CIngest the data in Logs into Azure Data Explorer.
  • DMigrate the data in HR to Azure Blob storage.

How the community answered

(57 responses)
  • A
    84% (48)
  • B
    2% (1)
  • C
    5% (3)
  • D
    9% (5)

Why each option

To make data from an on-premises Microsoft SQL Server database searchable by Azure AI Search, the data must first be moved to a cloud-based data source that Azure AI Search can index, such as Azure Data Lake Storage.

AExport the data in Finance to Azure Data Lake Storage.Correct

Azure AI Search cannot directly connect to an on-premises SQL Server database for indexing. Exporting the Finance data to Azure Data Lake Storage (or Azure Blob Storage) provides a cloud-native source that Azure AI Search can readily connect to and index, enabling the data to be searched via its REST API.

BConfigure multiple read replicas for the data in Sales.

Configuring multiple read replicas for Azure Cosmos DB improves read performance and availability but does not address the requirement to make on-premises SQL Server data searchable by Azure AI Search.

CIngest the data in Logs into Azure Data Explorer.

Ingesting data from Azure Table Storage into Azure Data Explorer moves the data to an analytics service but does not directly integrate it with Azure AI Search, which has its own connectors for Azure Table Storage.

DMigrate the data in HR to Azure Blob storage.

Migrating HR data from Azure SQL Database to Azure Blob Storage is unnecessary, as Azure AI Search can directly index data from Azure SQL Databases.

Concept tested: Azure AI Search data source compatibility

Source: https://learn.microsoft.com/en-us/azure/search/search-what-is-data-source

Topics

#Azure AI Search#Data indexing#Azure Data Lake Storage#Hybrid data sources

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AI-102 Practice