Architecture questions separate senior engineers from juniors. Anyone can write SQL. Designing systems that scale, maintain, and evolve takes experience.
Your interviewer gives open-ended problems: "Design a data platform for an e-commerce company." There's no single right answer. Your interviewer wants to see your thought process.
I'll cover the architectural patterns you need to discuss trade-offs intelligently.