Stream (CO) interview question

System design for an event driven system, database optimizations for performance