AI-102 Question 357
Single answerYou are building a conversational AI application using Azure Cognitive Services. Your application needs to analyze user input stored in a SQL database and derive insights using Azure Cognitive Services. Which step is required to create a data source for Azure Cognitive Search to index the data from the SQL database?
- A
Define an index schema in Azure Cognitive Search to match the SQL database structure.
- B
Create an Azure Blob Storage container and export the SQL data to the container.
- C
Configure a data source in Azure Cognitive Search that connects directly to the SQL database.
- D
Enable Azure Data Factory to process and transform the SQL data prior to indexing.
Show answer and explanation
Correct answer: C
Explanation
To create a data source in Azure Cognitive Search, you can connect directly to an Azure SQL database using the built-in data source configuration. This allows Azure Cognitive Search to read data from the SQL database for indexing, without requiring additional steps like exporting the data to another service.
- A. Incorrect.
Defining an index schema is a separate step in Azure Cognitive Search and does not involve creating the data source itself.
- B. Incorrect.
While exporting SQL data to Azure Blob Storage is an option, it is not necessary for creating a data source directly from the SQL database.
- C. Correct.
Azure Cognitive Search allows you to directly configure a data source to connect to an Azure SQL database, making this the correct choice.
- D. Incorrect.
Azure Data Factory can be used for data transformation, but it is not required for creating a data source in Azure Cognitive Search.