Crucial Exams

Microsoft Azure AI Engineer Associate AI-102 Practice Question

You are configuring an Azure AI Search indexer that imports data from an Azure SQL Database table containing a LastModifiedDate column of type datetime2. After the first full crawl, the indexer should process only those rows that were inserted or updated since the previous run, so that each incremental execution finishes quickly and minimizes database load. Which setting must you add to the indexer definition to meet this requirement?

  • Set the parameters.batchSize value to 1,000 documents per batch.

  • Enable a SoftDeleteColumnDeletionDetectionPolicy on the LastModifiedDate column.

  • Set the indexer schedule interval to a short period, such as every five minutes.

  • Configure a HighWaterMarkChangeDetectionPolicy that points to the LastModifiedDate 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