InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
{"firstName" : "Arthur", "lastName" : "Aaronson", "state" : "WA", "city" : "Seattle", "likes" : [ "dogs", "cats" ] } {"firstName" : "Beth", "lastName" : "Barnes", "state" : "WA", "city" : "Richland", "likes" : [ "forest", "cats" ] } {"firstName" : "Charlie", "lastName" : "Carlson", "state" : "CA", "city" : "San Diego", "likes" : [ "desert", "dogs" ] } {"firstName" : "Dawn", "lastName" : "Davis", "state" : "WA", "city" : "Seattle", "likes" : [ "forest", "mountains" ] } |
|
Answer» Shard key selection is based on the workload. Since the first query is being USED 90% it should be driving the selection for selection of shard key. Combination of FIELDS from that query would make the best shard key. This ELIMINATES option b, c and d. Option a and e uses a subset of fields from the most used workload and both can be shard key but option has more fields and so would be more suitable. |
|