Crucial Exams

Microsoft Azure AI Engineer Associate AI-102 Practice Question

You are implementing an Azure AI Search solution that must index data from an Azure SQL Database named SalesDB. Only rows added or updated since the previous indexing run should be processed. You have already created an Azure AI Search index named sales-index. When creating the data source in the Azure portal, which configuration must you set to achieve this requirement?

  • Set the indexer schedule to run in incremental mode with a daily frequency.

  • Define a connection policy that uses managed identity authentication instead of a connection string.

  • Configure a high-watermark change detection policy that references the LastModifiedDate column.

  • Configure a soft delete policy that identifies inactive records by the IsDeleted column.

Microsoft Azure AI Engineer Associate AI-102
Implement knowledge mining and information extraction solutions
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot