AZ-204 – Question 45

0
437
DRAG DROP –
You are developing a new page for a website that uses Azure Cosmos DB for data storage. The feature uses documents that have the following format:
You must display data for the new page in a specific order. You create the following query for the page:
You need to configure a Cosmos DB policy to support the query.
How should you configure the policy? To answer, drag the appropriate JSON segments to the correct locations. Each JSON segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct Answer:

Box 1: compositeIndexes –
You can order by multiple properties. A query that orders by multiple properties requires a composite index.

Box 2: ascending – Answer should be ‘ascending’. You cannot support ASC (default), DESC query with DESC, DESC index.
Example: Composite index defined for (name ASC, age ASC):
It is optional to specify the order. If not specified, the order is ascending.
{
“automatic”:true,
“indexingMode”:”Consistent”,
“includedPaths”:[
{
“path”:”/*”
}
],
“excludedPaths”:[],
“compositeIndexes”:[
[
{
“path”:”/name”,
},
{
“path”:”/age”,
}
]
]
}