Implement knowledge mining and information extraction solutions →mediumMultiple SelectObjective-mapped
AI-102 Practice Question: Implement knowledge mining and information extraction solutions
Which TWO options are valid ways to index content from Azure SQL Database into Azure AI Search? (Select TWO.)
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use the Push API to send data directly to the search index.
Azure AI Search supports indexing from SQL Database using either a SQL Server indexer or a push API. Data Factory and Event Hubs are not direct indexers for SQL.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Use the Push API to send data directly to the search index.
Why this is correct
The Push API allows programmatic indexing of data.
- ✗
Use Azure Data Factory to copy data to Blob Storage, then index from Blob.
Why it's wrong here
This is an indirect method but not a direct indexer; the question asks for valid ways to index into Azure AI Search, but this is not a built-in indexer.
- ✗
Use Azure AI Document Intelligence to extract data and push to index.
Why it's wrong here
Document Intelligence is for document extraction, not direct SQL indexing.
- ✗
Use Azure Event Hubs to stream data into the search index.
Why it's wrong here
Event Hubs is not a built-in indexer source; you would need a custom solution.
- ✓
Use the Azure AI Search SQL Server indexer.
Why this is correct
The SQL Server indexer can connect to Azure SQL Database and index data.
Go deeper
Related to this question
About these practice questions
One of 945 original AI-102 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on AI-102
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Which TWO configurations are required to enable Azure AI Search to index content from an Azure SQL database?
medium- A.Create a custom skillset for data enrichment
- B.Configure semantic ranking on the index
- ✓ C.Enable change tracking on the Azure SQL table
- ✓ D.Define a data source connection to the Azure SQL database
- E.Enable high availability on the Azure SQL database
Why C: Azure AI Search requires change tracking to be enabled on the Azure SQL table to support incremental indexing. Without change tracking, the indexer would have to re-read the entire table on each run, which is inefficient for large datasets. Change tracking allows the indexer to detect only new, updated, or deleted rows since the last indexing cycle.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AI-102 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AI-102 exam.