5 / 6 SQL vs NoSQL & Data Models

Picking the Billing Store

A team is choosing between a relational database and a document store for a B2B billing product. Which factors argue for the relational option? (Select all that apply.)

A

The engine should enforce referential integrity, so a line item cannot outlive its invoice

B

Write volume already exceeds what a single primary node can absorb without partitioning the data

C

Analysts run ad hoc queries that nobody anticipated when the data model was written

D

Entities carry many-to-many relationships that get traversed from either direction

E

Records are almost always fetched whole by their primary key and never filtered on a nested field