Correct Answer: B
Range strategy results in grouping the related items together in the same shard, and ordering them by shard key. In the case of the application that frequently requires finding all orders delivered in a particular month, the data could be quickly retrieved/accessed if all orders associated with a month are stored in time and date order in the same shard.
Option A is incorrect. Lookup strategy is not the best sharding strategy in the given scenario.
Option B is correct. range strategy will put all the related orders (i.e. orders for a month) in the same shard which will result in quick data retrieval.
Option C is incorrect. Hash strategy distributes the data across the shards to achieve a balance among the size of every shard and the average load to be encountered by each shard.
Option D is incorrect. There is no such sharding strategy as a normalized strategy.
Reference:
To know more about sharding patterns, please visit the below-given link:
https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding#sharding-strategies