ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AI-102 All Questions

View all questions & answers for the AI-102 exam
Go to Exam

Exam AI-102 topic 4 question 14 discussion

Actual exam question from Microsoft's AI-102
Question #: 14
Topic #: 4
[All AI-102 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by MaliSanFuu at May 16, 2023, 9:27 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
zellck
Highly Voted 1 year, 7 months ago
Selected Answer: D
D is the answer. https://learn.microsoft.com/en-us/rest/api/searchservice/create-index#-field-definitions- - retrievable Indicates whether the field can be returned in a search result. - searchable Indicates whether the field is full-text searchable and can be referenced in search queries.
upvoted 12 times
...
syupwsh
Most Recent 1 day, 17 hours ago
Selected Answer: D
You need the MessageCopy field to be full-text searchable so users can perform searches against its content, and retrievable so that the values of the field can be displayed to users. Answer is D
upvoted 1 times
...
reigenchimpo
8 months ago
Selected Answer: D
It is obvious that D is the correct answer.
upvoted 1 times
...
reiwanotora
8 months, 3 weeks ago
Selected Answer: D
D is right answer.
upvoted 1 times
...
evangelist
1 year ago
Selected Answer: D
only option D meets the demand
upvoted 1 times
...
rdemontis
1 year, 3 months ago
Selected Answer: D
correct
upvoted 2 times
...
MaliSanFuu
1 year, 9 months ago
Selected Answer: D
Should be correct. reference: https://learn.microsoft.com/en-us/azure/search/search-what-is-an-index
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago