Question 249 of 988

Implement knowledge mining and information extraction solutions →mediumMultiple SelectObjective-mapped

Quick Answer

The answer is using the Azure AI Search SQL Server indexer and the push API. These are the two direct methods to index content from Azure SQL Database into Azure AI Search because the SQL Server indexer natively connects to your database, extracts data, and loads it into a search index, while the push API allows you to programmatically send data from any source, including SQL, into the index. On the Microsoft Azure AI Engineer Associate AI-102 exam, this question tests your understanding of native indexing pipelines versus indirect data movement tools; a common trap is selecting Azure Data Factory or Event Hubs, which are orchestration and streaming services but not direct indexers for Azure AI Search. To remember this, think of the two paths: the indexer pulls from SQL automatically, and the push API lets you push data manually—only these two are valid for direct indexing.

AI-102 Practice Question: Implement knowledge mining and information extraction solutions

This AI-102 practice question tests your understanding of implement knowledge mining and information extraction solutions. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

Which TWO options are valid ways to index content from Azure SQL Database into Azure AI Search? (Select TWO.)

Question 1mediummulti select

Full question →

A
Use the Push API to send data directly to the search index.
The Push API allows programmatic indexing of data.
B
Use Azure Data Factory to copy data to Blob Storage, then index from Blob.
Why wrong: 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.
C
Use Azure AI Document Intelligence to extract data and push to index.
Why wrong: Document Intelligence is for document extraction, not direct SQL indexing.
D
Use Azure Event Hubs to stream data into the search index.
Why wrong: Event Hubs is not a built-in indexer source; you would need a custom solution.
E
Use the Azure AI Search SQL Server indexer.
The SQL Server indexer can connect to Azure SQL Database and index data.

Full breakdown with real-world context →

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.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

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.
Related concept
Read the scenario before looking for a memorised answer.
✗
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.
Related concept
Read the scenario before looking for a memorised answer.

Common exam traps

Common exam trap: answer the scenario, not the keyword

Many certification questions include familiar terms but test a specific constraint. Read the exact wording before choosing an answer that is generally true but wrong for this case.

Detailed technical explanation

How to think about this question

This question should be treated as a scenario, not a definition check. Identify the problem, the constraint and the best action. Then compare each option against those facts.

KKey Concepts to Remember

Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
Use explanations to understand the rule behind the answer.

TExam Day Tips

Underline the problem statement mentally.
Watch for words such as best, first, most likely and least administrative effort.
Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.

What to study next

Got this wrong? Here's your next step.

Identify which AI-102 exam domain this question belongs to, then review the specific concept being tested. Practise related questions in that domain and focus on understanding why each wrong answer is tempting — not just why the correct answer is right.

Related AI-102 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Implement an agentic solution practice questions

Practise AI-102 questions linked to Implement an agentic solution.

Implement computer vision solutions practice questions

Practise AI-102 questions linked to Implement computer vision solutions.

Implement knowledge mining and information extraction solutions practice questions

Practise AI-102 questions linked to Implement knowledge mining and information extraction solutions.

Implement image and video processing solutions practice questions

Practise AI-102 questions linked to Implement image and video processing solutions.

Implement natural language processing solutions practice questions

Practise AI-102 questions linked to Implement natural language processing solutions.

Implement generative AI solutions practice questions

Practise AI-102 questions linked to Implement generative AI solutions.

Implement agentic AI solutions practice questions

Practise AI-102 questions linked to Implement agentic AI solutions.

Implement knowledge mining and document intelligence solutions practice questions

Practise AI-102 questions linked to Implement knowledge mining and document intelligence solutions.

Plan and manage an Azure AI solution practice questions

Practise AI-102 questions linked to Plan and manage an Azure AI solution.

Implement content moderation solutions practice questions

Practise AI-102 questions linked to Implement content moderation solutions.

AI-102 fundamentals practice questions

Practise AI-102 questions linked to AI-102 fundamentals.

AI-102 scenario practice questions

Practise AI-102 questions linked to AI-102 scenario.

Practice this exam

Start a free AI-102 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

10 questions 20 questions 30 questions 50 questions Timed 30

AI-102 practice-test guide →Study guide →Browse all practice tests

FAQ

Questions learners often ask

What does this AI-102 question test?

Implement knowledge mining and information extraction solutions — This question tests Implement knowledge mining and information extraction solutions — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: 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.

What should I do if I get this AI-102 question wrong?

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

1 more ways 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: Options A and C are correct. A: A data source connection is needed to define the source. C: A skillset is optional but required if enrichment is needed; however, the question asks for required configurations, but a skillset is not required for basic indexing. Actually, for basic indexing, only data source and index with indexer are required. However, the question may imply enrichment. But typical required: data source, index, indexer. Skillset optional. So A and C? Wait, skillset is not required. Let's re-evaluate: For basic indexing, you need a data source definition and an index. The indexer ties them together. Skillset is optional. So required: data source and index. But options: A (data source), C (skillset) - skillset not required. D (index) is not listed. Options: A: data source, B: high availability, C: skillset, D: semantic configuration, E: change tracking. Required for SQL indexing: data source (A) and change tracking (E) to detect new/modified rows. Skillset not required. So correct: A and E. Yes.

Keep practising

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

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.