Choosing a shard key

• A

  submission_id, so that the rows spread out evenly across all of the shards

• B

  student_id, so a student's rows are together on one shard

• C

  created_at, so rows are ordered by time

• D

  problem_id, since problems are the other main entity