{CodeRoyale}
All challenges
Multiple ChoiceBeginner 45s

SQL vs NoSQL access pattern

Which scenario most strongly favors a document/NoSQL store over a relational DB?
Options
  1. 1Complex multi-table joins run inside strong ACID transactions spanning many foreign-key entities
  2. 2Massive write throughput of denormalized, semi-structured documents accessed by key
  3. 3Strict foreign-key enforcement across dozens of tables, integrity guaranteed on every write
  4. 4Reporting workloads that rely heavily on ad-hoc joins across arbitrary table combinations
system-designdatabasesnosql

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.

Play this in a 3-minute battle