Which database design pattern stores historical changes to data by adding new rows instead of updating existing ones?
- Soft Delete
- Temporal Tables
- Event Sourcing
- Both B and C
Answer: Both B and C
Temporal Tables (SQL:2011 standard) automatically track row history with system-versioned tables. Event Sourcing stores state changes as immutable events, enabling reconstruction of any historical state. Both support audit trails, time-travel queries, and compliance. Trade-offs: increased storage and query complexity for historical analysis.