Question

What is the best method to store row data in a sorted order ?

use a clustering key

minimize the number of partions.

partition

use a primary key

Answer 1

use a clustering key