Bazaarvoice Interview Question

How would you solve this technical problem?