Your question is Database Trade-Offs for Use Case. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Explain the trade-offs between different database technologies for our specific use case.
Clarify the use case before proposing a design. Discuss how workload shape, query patterns, consistency, latency, availability, data volume, compliance, operational complexity, and cost affect the choice among relational, key-value, document, analytical, search, and vector databases. Explain whether one technology or a polyglot approach is appropriate, and describe how the decision would be validated in production.