1 / 5
What is 'sharding' a database?
-
-
-
-
Sharding horizontally partitions data across servers so each holds part of the dataset.
2 / 5
A poorly chosen 'shard key' causes a 'hotspot'. What is a hotspot?
-
-
-
-
A hotspot is uneven distribution where one shard is overloaded while others sit idle.
3 / 5
'Horizontal partitioning' splits a table how?
-
-
-
-
Horizontal partitioning divides rows across partitions; vertical partitioning splits columns.
4 / 5
After adding a node the cluster 'rebalances'. What does that mean?
-
-
-
-
Rebalancing moves data so the new capacity is used and no node is overloaded.
5 / 5
Which sentence correctly uses 'cross-shard query'?
-
-
-
-
Cross-shard queries span multiple shards and are costlier, so shard keys are chosen to minimise them.