Your question is SQL vs NoSQL Trade-Offs. 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).
What architectural trade-offs do you consider when choosing between SQL and NoSQL databases for a highly transactional cloud service at Oracle?
Explain how you would make the choice based on transaction boundaries, consistency, schema requirements, query patterns, operational complexity, and long-term maintainability. Describe how the database decision should be isolated behind application-layer boundaries and how you would validate the choice with tests.