You have an application that runs frequent queries to identify all the orders placed in a specific month. This process can be run more efficiently if all orders for a month are stored in date and time order in the same shard. Which Sharding strategy must be used here?

Answer options:

A.Lookup
B.Hash
C.Range
D.None

Correct Answer: C
The question says that if all orders for a month are stored in date and time order in the same shard, it will increase the query. This is the Range strategy. The related items are put together in the same shard and orders by a Shard key. Also, the shard keys will be sequential. 

Image source: Microsoft Documentation
Option A is incorrect: This strategy actually works using routes. When data needs to be located, it then routes the request to the particular shard where it is located. This routing is supported by a shard key.
Option B is incorrect: This is the correct strategy to be used in this scenario.
Option C is correct: This strategy is used to make shards get equal size and load.
Reference: To know more, please refer to the docs below: 

https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding#sharding-strategies