Kickdrum Interview Question

Mostly on DB indexing, design based questions.