exam questions

Exam DP-420 All Questions

View all questions & answers for the DP-420 exam

Exam DP-420 topic 4 question 16 discussion

Actual exam question from Microsoft's DP-420
Question #: 16
Topic #: 4
[All DP-420 Questions]

HOTSPOT
-

You have an Azure Cosmos DB for NoSQL account.

You plan to create a container named container1. The container1 container will store items that include two properties named name and age.

The most commonly executed queries will query container1 for a specific name. The following is a sample of the query.



You need to define an opt-in indexing policy for container1. The solution must meet the following requirements:

• Minimize the number of request units consumed by the queries.
• Ensure that the _etag property is excluded from indexing.

How should you define the indexing policy? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

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
8fe085a
4 months, 3 weeks ago
For excluded paths, the correct answer is all - "/*", because this is a required entry in either included or excluded.
upvoted 3 times
...
xRiot007
10 months ago
For excluded paths, the correct answer is all - "/*" You cannot exclude etag with policies because it's a system property You can still create custom indexes with specific paths even if excludedPaths is /*
upvoted 4 times
RosaHutor
1 month, 4 weeks ago
Huh? You've probably never created a single indexing policy in your life. Otherwise, you'd know that you can actually exclude _etag. Moreover, if you create a new container and open indexing policy you will see that "/\"_etag\"/?" is already there.
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago