AI-200 Data Management Services And Vector Search Practice Question
You are building an AI search solution in Azure AI Search. You need to ensure that when documents are deleted from the primary database, they are also automatically removed from the search index without requiring manual API calls. How should you configure the indexer?
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
✓
Configure a soft-delete policy on the indexer referencing a deletion tracking column or flag in the data source
Azure AI Search indexers support change detection and soft-delete policies (such as Soft Delete Column) to automatically reflect deletions in the search index.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Write a custom Azure Function triggered by every delete event to issue an HTTP DELETE to the search index
Why it's wrong here
While possible, Azure AI Search indexers provide native soft-delete tracking without custom Azure Functions.
- ✓
Configure a soft-delete policy on the indexer referencing a deletion tracking column or flag in the data source
Why this is correct
Soft-delete policies enable indexers to detect and propagate document deletions automatically.
- ✗
Re-create the entire search index from scratch daily
Why it's wrong here
Re-creating indexes daily is inefficient and unnecessary when indexer data synchronization is available.
- ✗
Set the index retention policy to auto-purge every 24 hours
Why it's wrong here
Retention policies do not handle selective document deletions from data sources.
About these practice questions
One of 507 original AI-200 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 →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Microsoft exam blueprint
This AI-200 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-200 exam.