Microsoft
AI-102 · Question #150
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…
The correct answer is A. Searchable and Retrievable. https://learn.microsoft.com/en-us/rest/api/searchservice/create-index#-field-definitions- Indicates whether the field can be returned in a search result. Indicates whether the field is full-text searchable and can be referenced in search queries.
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
How the community answered
(57 responses)- A82% (47)
- B9% (5)
- C5% (3)
- D4% (2)
Explanation
https://learn.microsoft.com/en-us/rest/api/searchservice/create-index#-field-definitions- Indicates whether the field can be returned in a search result. Indicates whether the field is full-text searchable and can be referenced in search queries.
Topics
#AI Search Index Fields#Searchable attribute#Retrievable attribute
Community Discussion
No community discussion yet for this question.