AI-102 Question 345
Single answerYou are designing an Azure AI Search solution for a retail company to enable customers to search for products using natural language queries. The product data is stored in Azure SQL Database. You want to ensure that the search index is updated automatically when the product data changes. Which approach should you implement?
- A
Use Azure Search Indexer with an Azure SQL Database data source.
- B
Manually trigger the indexer whenever product data changes.
- C
Use Azure Synapse Analytics to periodically sync the data with the Azure Search index.
- D
Implement an Azure Event Grid solution to monitor changes in the database and trigger an index update.
Show answer and explanation
Correct answer: A
Explanation
To fulfill the requirement of automatically updating the Azure AI Search index when product data changes, the best solution is to use an Azure Search Indexer configured with an Azure SQL Database data source. Indexers are specifically designed to periodically synchronize data from supported data sources, including Azure SQL Database, to an Azure AI Search index in an automated manner.
- A. Correct.
This is correct because Azure Search Indexers can be configured to work with Azure SQL Database as a data source and can automatically synchronize changes to the search index.
- B. Incorrect.
This is incorrect because manually triggering the indexer is not an automated solution and does not align with the requirement for automatic updates.
- C. Incorrect.
This is incorrect because Azure Synapse Analytics is not intended for directly managing Azure AI Search indexes. It is primarily used for big data analytics and data integration.
- D. Incorrect.
This is incorrect because while Azure Event Grid can monitor changes, it does not natively support triggering Azure AI Search index updates directly. Additional custom development would be required.