Exam DP-200 topic 4 question 33 discussion

Actual exam question from Microsoft's DP-200

Question #: 33
Topic #: 4

HOTSPOT -
You have an Azure Cosmos DB database.
You need to use Azure Stream Analytics to check for uneven distributions of queries that can affect performance.
Which two settings should you configure? To answer, select the appropriate settings in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: RIGHT -
Use right for dates.
1- RIGHT means < or >=
2- LEFT means <= and >.
Box 2: 20090101, 201001010, 20110101, 20120101
Four values are better than three or two.
Reference:
https://medium.com/@selcukkilinc23/what-it-means-range-right-and-left-in-table-partitioning-2d654cb99ade

by vaseva1 at April 5, 2021, 1:02 p.m.

Comments

Submit Cancel

rakadhar

Highly Voted 4 years, 1 month ago

The answer is correct . See this link --> https://www.cathrinewilhelmsen.net/table-partitioning-in-sql-server/ From this link below excerpt :- Partition functions are created as either range left or range right, it is not possible to combine both in the same partition function. In a range left partition function, all boundary values are upper boundaries, they are the last values in the partitions. If you partition by year, you use December 31st. If you partition by month, you use January 31st, February 28th / 29th, March 31st, April 30th and so on. In a range right partition function, all boundary values are lower boundaries, they are the first values in the partitions. If you partition by year, you use January 1st. If you partition by month, you use January 1st, February 1st, March 1st, April 1st and so on:

upvoted 8 times

...

satyamkishoresingh

Most Recent 3 years, 5 months ago

This question doesn't make any sense !

upvoted 2 times

...

MsIrene

4 years, 1 month ago

The answer is correct. Should be RIGHT. Basically, it means that partition starts from the given value, i.e. from 20090101 to 20091231, the next one from 20100101 to 20101231 and so on.

upvoted 4 times

...

vaseva1

4 years, 2 months ago

i think its should be LEFT

upvoted 4 times

...