Question 52 of 179 from exam AZ-204: Developing Solutions for Microsoft Azure

Question 52 of 179 from exam AZ-204: Developing Solutions for Microsoft Azure

Prev Question Next Question

Question

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:

“name”: “John”, “seattle”

You must display data for the new page in a specific order.

You create the following query for the page:

SELECT* FROM People p ORDER BY p.name, p.city DESC

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:

JSON segments orderBy sortOrder ascending descending compositeIndexes Answer Area “automatic”: true, “ngMode”: “Consistent”, “includedPaths”: [ ! } “path”: »/# 1, “excludedpaths”: [], Vaart “path”: “/name”, “order”: “descending” “path”: “/eity”, “order”: ”

Explanations

JSON segments orderBy sortOrder ascending descending compositeIndexes Answer Area “automatic”: true, “ngMode”: “Consistent”, “includedPaths”: [ ! “path”: »/# } 1, “excludedpaths”: [], compositeIndexes|"? [ C { } “path”: “/name”, “order”: “descending” h { “path”: “/eity”, “order”: descending ”

Box 1: compositeIndexes - You can order by multiple properties.

A query that orders by multiple properties requires a composite index.

Box 2: descending - 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", } ] ] }

Prev Question Next Question