AI-102 Question 363
Select 3You are tasked with designing an Azure Cognitive Search solution for a retail company that wants to enable full-text search capabilities on their product catalog. The product catalog data resides in an Azure SQL Database. You need to create an index to enable search functionality. Which of the following steps are required to successfully create and configure the index?
- A
Define the fields and attributes for the index, such as searchable, filterable, and sortable.
- B
Use the Azure Blob Storage account to store the index configuration file.
- C
Choose a data source, such as Azure SQL Database, and connect it to the search service.
- D
Run a query to deploy the index using the Azure SQL Database Query Editor.
- E
Set up a Cognitive Search indexer to populate the index with data from the connected data source.
Show answer and explanation
Correct answers: A, C, E
Explanation
To create an index in Azure Cognitive Search, you need to define the fields and their attributes, connect a supported data source (like Azure SQL Database), and optionally set up an indexer to populate the index with data. These steps ensure the index is properly configured and ready for search operations. Azure Blob Storage or SQL Query Editor are not involved in creating or managing the index.
- A. Correct.
Correct. Defining the fields and their attributes is a critical step when creating an index in Azure Cognitive Search. This determines how the data can be queried and used.
- B. Incorrect.
Incorrect. Azure Blob Storage is not required to store the index configuration. The index is managed and stored within the Azure Cognitive Search service.
- C. Correct.
Correct. Connecting a data source like Azure SQL Database ensures that the data can be indexed and made searchable.
- D. Incorrect.
Incorrect. Azure SQL Database Query Editor is not used to deploy indexes in Azure Cognitive Search. The index is created and managed within the Azure Cognitive Search service.
- E. Correct.
Correct. A Cognitive Search indexer is used to automate the process of pulling data from the data source into the index.