Exam DP-420 topic 4 question 16 discussion

Actual exam question from Microsoft's DP-420

Question #: 16
Topic #: 4

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

Suggested Answer:

by xRiot007 at Jan. 4, 2024, 6:13 p.m.

Comments

Submit Cancel

marc104456563

1 week, 3 days ago

according to the https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/how-to-manage-indexing-policy?tabs=dotnetv3%2Cpythonv3#opt-in-policy-to-selectively-include-some-property-paths it should be /* in excluded and /name/? in composite index

upvoted 1 times

...

8fe085a

6 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

11 months, 3 weeks 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

3 months, 3 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

...