exam questions

Exam DP-420 All Questions

View all questions & answers for the DP-420 exam

Exam DP-420 topic 4 question 3 discussion

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

HOTSPOT -
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account.
The following is a sample of a document in container1.

The container1 container has the following indexing policy.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Yes -
"path": "/*" is in includePaths.
Include the root path to selectively exclude paths that don't need to be indexed. This is the recommended approach as it lets Azure Cosmos DB proactively index any new property that may be added to your model.

Box 2: No -
"path": "/firstName/?" is in excludePaths.

Box 3: Yes -
"path": "/address/city/?" is in includePaths
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/index-policy

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
[Removed]
Highly Voted 10 months ago
Box 1: Yes - "path": "/*" is in includePaths. Include the root path to selectively exclude paths that don't need to be indexed. This is the recommended approach as it lets Azure Cosmos DB proactively index any new property that may be added to your model. Box 2: No - "path": "/firstName/?" is in excludePaths. Box 3: Yes - In this case, the included path takes precedence over the excluded path because it's more precise "path": "/address/city/?" is more precise than "path": "/address/*" Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/index-policy
upvoted 5 times
...
matejka
Most Recent 3 months, 2 weeks ago
YYY There is obviously a typo, but it is both in the data and in the index definition. But in the question it reads correctly and differently. So Y in the second option too. There is obviously a typo, but it is both in the data and in the index definition. But in the question it reads correctly and differently. So Y in the second option too.
upvoted 1 times
...
8fe085a
6 months, 4 weeks ago
With the procided question it should be YYY. Als The second question says fisrtname (sr excanged), the document also says fisrtname, but the index excludes firstname (spelled correctly)
upvoted 4 times
3709334
5 months, 4 weeks ago
correct its "fisrtname" not "firstname" which is exlcuded.
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 ...