Designing and Implementing a Microsoft Azure AI Solution — Question 56

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?

Answer options

• A. Migrate the data in HR to Azure Blob storage.
• B. Migrate the data in HR to the on-premises SQL server.
• C. Export the data in Finance to Azure Data Lake Storage.
• D. Migrate the data in Sales to the MongoDB API.

Correct answer: C

Explanation

The correct answer is C because exporting the Finance data to Azure Data Lake Storage allows it to be indexed by Azure AI Search. The other options do not facilitate compatibility with Azure AI Search, as moving data to Blob storage or on-premises SQL server does not support the search functionality, and migrating Sales data to the MongoDB API is irrelevant to the search requirement.