Interviewer asked literally everything related, from API to queries to DB. You need to have experience and knowledge in caching, NoSQL/SQL DBs and how to design their structure, consistence hashing, message queue systems, scalability, etc. Cassandra with tag/entities first table and inverted second table can be basic solution here.