DP-420 Exam QuestionsBrowse all questions from this exam

DP-420 Exam - Question 65


HOTSPOT -

You configure Azure Cognitive Search to index a container in an Azure Cosmos DB Core (SQL) API account as shown in the following exhibit.

Exam DP-420 Question 65

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Hot Area:

Exam DP-420 Question 65
Show Answer
Correct Answer:
Exam DP-420 Question 65

Box 1: country -

The country field is filterable.

Note: filterable: Indicates whether to enable the field to be referenced in $filter queries. Filterable differs from searchable in how strings are handled. Fields of type

Edm.String or Collection(Edm.String) that are filterable do not undergo lexical analysis, so comparisons are for exact matches only.

Box 2: name -

The name field is not Retrievable.

Retrievable: Indicates whether the field can be returned in a search result. Set this attribute to false if you want to use a field (for example, margin) as a filter, sorting, or scoring mechanism but do not want the field to be visible to the end user.

Note: searchable: Indicates whether the field is full-text searchable and can be referenced in search queries.

Reference:

https://docs.microsoft.com/en-us/rest/api/searchservice/create-index

Discussion

3 comments
Sign in to comment
dtodorov
Sep 18, 2024

Yes, correct, Country & Name

Bviljoen
Oct 8, 2024

https://learn.microsoft.com/en-us/azure/search/search-what-is-an-index#field-attributes "filterable" - Referenced in $filter queries. Filterable fields of type Edm.String or Collection(Edm.String) don't undergo word-breaking, so comparisons are for exact matches only. For example, if you set such a field f to "sunny day", $filter=f eq 'sunny' finds no matches, but $filter=f eq 'sunny day' will. "retrievable" - Determines whether the field can be returned in a search result. This is useful when you want to use a field (such as profit margin) as a filter, sorting, or scoring mechanism, but don't want the field to be visible to the end user. This attribute must be true for key fields. Yes County and I believe Id would be more correct as a key field.

WimTS
Apr 15, 2025

Country is Filterable => exact match Name is not Retrievable => cannot be returned in search result