You plan create an index for an Azure Cognitive Search service by using the Azure portal. The Cognitive Search service will connect to an Azure SQL database. Th...

You plan create an index for an Azure Cognitive Search service by using the Azure portal. The Cognitive 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?

A. Sortable and Retrievable B. Filterable and Retrievable C. Searchable and Facetable D. Searchable and Retrievable