nerdexam
MicrosoftMicrosoft

AI-102 · Question #150

AI-102 Question #150: Real Exam Question with Answer & Explanation

Sign in or unlock AI-102 to reveal the answer and full explanation for question #150. The question stem and answer options stay visible for context.

Submitted by takeshi77· Mar 30, 2026Implement knowledge mining solutions

Question

You plan create an index for an Azure AI Search service by using the Azure portal. The Azure AI Search service will connect to an Azure SQL database. The Azure SQL database contains a table named UserMessages. Each row in UserMessages has a field named MessageCopy that contains the text of social media messages sent by a user. Users will perform full text searches against the MessageCopy field, and the values of the field will be shown to the users. You need to configure the properties of the index for the MessageCopy field to support the solution. Which attributes should you enable for the field?

Options

  • ASearchable and Retrievable
  • BSortable and Retrievable
  • CSearchable and Facetable
  • DFilterable and Retrievable

Unlock AI-102 to see the answer

You've previewed enough free AI-102 questions. Unlock AI-102 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#AI Search Index Fields#Searchable attribute#Retrievable attribute
Full AI-102 PracticeBrowse All AI-102 Questions