AI-102 Question 354
Select 3You are building an Azure AI solution to analyze customer feedback stored in a SQL database. The feedback data needs to be ingested into Azure Cognitive Search for further analysis. Which steps should you take to create the data source in Azure Cognitive Search?
- A
Use the Azure portal to create a data source by configuring the connection string and specifying the SQL database.
- B
Create a data source using Azure PowerShell by providing the necessary parameters, including data source name, type, and connection details.
- C
Manually upload the SQL database file into Azure Cognitive Search.
- D
Use the REST API to create a data source by defining the connection string, data source type, and credentials.
- E
Connect the SQL database directly to Azure Cognitive Search without defining a data source.
Show answer and explanation
Correct answers: A, B, D
Explanation
To ingest data from a SQL database into Azure Cognitive Search, you must create a data source that defines the connection details and database type. This can be achieved via the Azure portal, Azure PowerShell, or the REST API. Manual uploads and direct connections without defining a data source are not supported.
- A. Correct.
This option is correct because the Azure portal allows you to create and configure a data source by specifying the connection details for the SQL database.
- B. Correct.
This option is correct because Azure PowerShell can be used to create a data source programmatically by providing the required parameters.
- C. Incorrect.
This option is incorrect because Azure Cognitive Search does not support manual uploads of SQL database files as a data source.
- D. Correct.
This option is correct because the REST API can be used to programmatically define and configure a data source, including connection strings and authentication.
- E. Incorrect.
This option is incorrect because you must define a data source to connect SQL databases to Azure Cognitive Search. Direct connections without data source configuration are not supported.