New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-420 Exam - Topic 3 Question 4 Discussion

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

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

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.


by Kimbery at May 03, 2022, 09:21 AM

Limited Time Offer

25%

Off

Get Premium DP-420 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Demetra
4 months ago
Wait, why would we need two different index directions? That seems odd.
upvoted 0 times
...
Sylvia
5 months ago
B seems overkill with both ASC and DESC indexes.
upvoted 0 times
...
Lorean
5 months ago
Not so sure about D, what if the timestamp isn't as relevant?
upvoted 0 times
...
Catalina
5 months ago
Totally agree, D covers all the bases!
upvoted 0 times
...
Peggy
5 months ago
I think option D is the best choice for this query.
upvoted 0 times
...
Nieves
5 months ago
I’m a bit confused about the timestamp part. Should it be included in the index if it’s only used for filtering?
upvoted 0 times
...
Justine
5 months ago
I practiced a similar question where the order of columns in the index really mattered. I think option D might be the best choice here.
upvoted 0 times
...
Blossom
5 months ago
I think we need to focus on the order of the fields in the index. The sensor is a key filter, right?
upvoted 0 times
...
Ruth
5 months ago
I'm not entirely sure, but I remember something about composite indexes needing to match the query's filter conditions closely.
upvoted 0 times
...
Lura
5 months ago
I'm a little unsure about the differences between some of these options. I'll need to double-check the ZFS documentation to make sure I understand the implications of each one.
upvoted 0 times
...
Brett
6 months ago
Okay, let me break this down step-by-step. I think the key is understanding what "tag along rights" are in the context of a Buy-Sell agreement.
upvoted 0 times
...

Save Cancel