Free Preparation Discussions
MENU
Microsoft DP-420 Exam - Topic 3 Question 4 Discussion
Topic #: 3
You have the following query.
SELECT * FROM
WHERE c.sensor = "TEMP1"
AND c.value < 22
AND c.timestamp >= 1619146031231
You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query.
What should you recommend?
If a query has a filter with two or more properties, adding a composite index will improve performance.
Consider the following query:
SELECT * FROM c WHERE c.name = ''Tim'' and c.age > 18
In the absence of a composite index on (name ASC, and age ASC), we will utilize a range index for this query. We can improve the efficiency of this query by creating a composite index for name and age.
Queries with multiple equality filters and a maximum of one range filter (such as >,<, <=, >=, !=) will utilize the composite index.
Demetra
10 months agoSylvia
10 months agoLorean
11 months agoCatalina
11 months agoPeggy
11 months agoNieves
11 months agoJustine
11 months agoBlossom
11 months agoRuth
11 months agoLura
11 months agoBrett
11 months ago