Learn the vocabulary of splitting a table's rows across multiple servers by a partition key to scale beyond one server's capacity.
0 / 5 completed
1 / 5
A teammate explains that a large orders table is split by row, so orders for customers A through M live on one database server and orders for customers N through Z live on another, with every server storing the same set of columns for its own subset of rows. What data-partitioning strategy is being described?
Horizontal partitioning, also called sharding, is exactly this: rows of a table are split across multiple servers based on a partition key, such as a customer name range, so each server holds the full set of columns but only a subset of the rows, letting the table's total row count scale beyond what any single server could hold or serve. A DNS zone transfer is an unrelated concept about replicating name server records. This split-rows-across-servers-by-key approach is exactly why horizontal partitioning is the standard technique for scaling a table's row count beyond one server's capacity.
2 / 5
During a design review, the team horizontally partitions an orders table across four database servers by customer ID range, specifically so total storage and query throughput scale by adding more servers rather than being capped by one server's disk and CPU. Which capability does this provide?
Horizontal partitioning here provides horizontal scalability of storage and throughput, since adding more partitioned servers increases total row capacity and query capacity beyond what one server could provide. Keeping the entire orders table on a single server regardless of how many partitions are configured caps total capacity at that one server's disk and CPU limits. This distribute-rows-across-more-servers behavior is exactly why horizontal partitioning is favored once a table's data volume outgrows a single server.
3 / 5
In a code review, a dev notices an orders table has grown so large that queries are timing out on disk I/O, and the plan is to keep vertically scaling the single server with more disk and CPU, instead of horizontally partitioning the rows across multiple servers by customer ID range. What does this represent?
This is a missed horizontal-partitioning opportunity, since splitting rows across multiple servers would scale capacity beyond what upgrading a single server's hardware can sustain indefinitely. A cache eviction policy is an unrelated concept about discarded cache entries. This keep-vertically-scaling-one-server pattern is exactly the kind of scaling ceiling a reviewer flags once a table's growth has outpaced what a single server's hardware can hold.
4 / 5
An incident report shows orders queries began timing out because the single server hosting the entire orders table ran out of disk I/O capacity, and the team had already upgraded that server's hardware to its maximum available tier. What practice would prevent this?
Horizontally partitioning the orders table across multiple servers by customer ID range lets total capacity scale by adding servers instead of being capped by one server's maximum hardware tier. Continuing to host the entire orders table on the single, already-maxed-out server regardless of how many queries time out is exactly what caused the timeouts described in this incident. This split-rows-across-servers approach is the standard fix once a single server's hardware ceiling is confirmed to be the bottleneck.
5 / 5
During a PR review, a teammate asks why the team reaches for horizontal partitioning instead of vertical partitioning, which splits a table by column instead of by row, given that vertical partitioning is already used elsewhere for a wide table with rarely accessed columns. What is the reasoning?
Horizontal partitioning scales total row count and throughput by distributing rows across servers, while vertical partitioning instead separates columns to reduce the size of frequently accessed rows, so the choice depends on whether the bottleneck is row count or wide-row column access. This is exactly why horizontal partitioning is favored when a table has too many rows for one server, while vertical partitioning remains the better fit when a table has manageable row counts but very wide rows with rarely accessed columns.
What does the "Horizontal Partitioning Vocabulary" vocabulary exercise cover?
This exercise tests real IT vocabulary related to horizontal partitioning vocabulary through 5 multiple-choice questions, each built from realistic workplace sentences rather than abstract definitions.
Is this vocabulary exercise free to use?
Yes. Every exercise on CoderSlingo, including this one, is completely free — no account, sign-up, or payment required.
How many questions does this exercise have?
This exercise has 5 questions. Each one shows a real-world sentence or scenario with multiple-choice options and an explanation once you answer.
What happens after I answer a question?
You'll see immediate feedback showing whether your answer was correct, along with a short explanation of why — then a button to move to the next question, and a full results screen at the end.
Can I retry the exercise if I get questions wrong?
Yes. Once you reach the results screen, click "Try again" to reset your answers and go through the exercise from the start as many times as you like.
Do I need to create an account to take this exercise?
No account is needed. Your answers are scored in your browser during the session — nothing is saved to a server, so you can jump straight in.
Is my progress saved if I leave the page?
No — progress within an exercise resets if you navigate away or reload. Each exercise is short enough to complete in a few minutes in one sitting.
Are these vocabulary exercises connected to other topics?
Yes — this module shares real-world context with 14 other vocabulary modules. See "Related vocabulary" below to keep building a connected skill set.
How is this different from reading a glossary or blog article?
Exercises like this one are active recall drills — you have to choose the correct term or phrasing yourself, which builds retention faster than passively reading a definition.
Where can I find more vocabulary exercises?
Browse the full Vocabulary exercises hub for hundreds of modules covering Agile, DevOps, security, databases, architecture, and more — organised by IT role and skill.