AI-102 Question 377
Select 3You are tasked with creating an Azure Cognitive Search solution that indexes data stored in an Azure SQL Database. The indexer should run automatically every day to ensure the index remains up to date. Additionally, you want to ensure that only specific columns from the database are indexed. Which steps should you take to achieve this?
- A
Define a data source that connects to the Azure SQL Database and specify the connection string.
- B
Create a skillset to preprocess the data before indexing.
- C
Define an index that includes only the required fields from the database.
- D
Create an indexer and set its schedule to run daily.
- E
Enable semantic search to refine the indexing process.
Show answer and explanation
Correct answers: A, C, D
Explanation
To create and run an indexer for an Azure Cognitive Search solution, you need to define a data source, create an index to specify the structure of the searchable content, and configure an indexer to automate the indexing process. Scheduling the indexer ensures the index is kept up to date. A skillset or semantic search is not necessary unless specific data enrichment or advanced search capabilities are required.
- A. Correct.
Correct: Defining a data source is essential as it specifies where the data comes from and how to connect to it.
- B. Incorrect.
Incorrect: A skillset is used for enriching data, such as extracting entities or running custom models. It is not required for simply indexing specific columns.
- C. Correct.
Correct: Defining an index allows you to specify which fields from the data source should be included in the search index.
- D. Correct.
Correct: An indexer automates the process of populating the index, and setting a schedule ensures it runs daily as required.
- E. Incorrect.
Incorrect: Semantic search is an optional feature that enhances search relevance but is unrelated to the process of creating and running an indexer.