Which statement about horizontal partitioning is true?

Which statement about horizontal partitioning is true?

• A. Rows across partitions while keeping the same columns.
• B. Columns across partitions while keeping the same rows.
• C. Both rows and columns across separate machines.
• D. Only indexes are partitioned.

Answer: (A)

Horizontal partitioning divides a table by rows across multiple partitions, with each partition having the same set of columns. This is why the statement that describes distributing rows across partitions while keeping the same columns is the correct one: you scale by splitting the data horizontally but preserve the table’s schema in every partition. In contrast, splitting by columns (vertical partitioning) would put different columns in different partitions, which is not what horizontal partitioning does. The idea of both rows and columns across separate machines describes a mixed or more complex setup rather than the pure horizontal approach. And partitioning only indexes doesn’t reflect how horizontal partitioning treats the data rows itself.

Horizontal partitioning divides a table by rows across multiple partitions, with each partition having the same set of columns. This is why the statement that describes distributing rows across partitions while keeping the same columns is the correct one: you scale by splitting the data horizontally but preserve the table’s schema in every partition.

In contrast, splitting by columns (vertical partitioning) would put different columns in different partitions, which is not what horizontal partitioning does. The idea of both rows and columns across separate machines describes a mixed or more complex setup rather than the pure horizontal approach. And partitioning only indexes doesn’t reflect how horizontal partitioning treats the data rows itself.