AI-102 Question 347
Single answerYou are designing an Azure AI Search solution for an e-commerce website that needs to provide search functionality for millions of product records stored in an Azure SQL Database. The requirements are as follows:
- The solution should support full-text search with filters and faceted navigation.
- The search index must be kept up to date with minimal latency as new products are added to the database.
- The solution should allow for synonyms in search queries.
Which approach should you take to meet these requirements?
- A
Use Azure Cognitive Search with an indexer connected to the Azure SQL Database and define a synonym map.
- B
Use Azure Synapse Analytics to execute SQL queries with full-text search and implement a custom synonym dictionary in the application layer.
- C
Deploy Elasticsearch on Azure Virtual Machines and create a custom pipeline to sync the Azure SQL Database with Elasticsearch.
- D
Use Azure Cosmos DB with full-text search enabled and implement synonyms using custom search logic in the application.
Show answer and explanation
Correct answer: A
Explanation
Azure Cognitive Search is specifically designed for implementing advanced search solutions with features like full-text search, filters, faceted navigation, and synonym maps. Using an indexer to sync with Azure SQL Database ensures minimal latency and simplifies the process of keeping the search index up to date. This makes it the most suitable solution for the given scenario.
- A. Correct.
This is the correct approach. Azure Cognitive Search provides built-in support for full-text search, filters, faceted navigation, and synonym maps. Using an indexer ensures minimal latency by syncing data from Azure SQL Database automatically.
- B. Incorrect.
This is not the best choice. While Azure Synapse Analytics supports SQL queries, it is not designed for advanced search scenarios like faceted navigation or synonyms. Implementing this functionality in the application layer would require significant custom development.
- C. Incorrect.
While Elasticsearch is a capable search engine, deploying and maintaining it on Azure Virtual Machines would introduce unnecessary complexity and effort, especially when Azure Cognitive Search provides a managed solution with similar capabilities.
- D. Incorrect.
Azure Cosmos DB does not natively support advanced full-text search or synonyms. Implementing such functionality in the application layer would be cumbersome and not aligned with the requirements.